Microsoft Access 2013 Intermediate

Course Code: MSACC2013ITM
Duration: 1 day
With the basic skills needed to work with Microsoft Office Access 2013 databases, including creating and working with Access tables, relationships, queries, forms, and reports. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
Microsoft Office Access 2013 Introduction course, or equivalent knowledge, is recommended.
Delegates will learn how to:
Maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft Office Access 2013 with other applications.
Controlling data entry
Create advanced queries
Improving forms
Customising reports
Sharing data between applications
Table relationships
Controlling Data Entry
Restrict data entry using field properties
Establish a pattern for entering field values
Create a list of values for a field
Creating Advanced Queries
Add a calculated field to a query
Create query joins
Group and summarize records using criteria
Set query properties
Create parameter queries
Create action queries
Improving Forms
Design a form layout
Enhance the appearance of a form
Restrict data entry in forms
Add a command button to a form
Create a subform
Customizing Reports
Organize report information
Format the report
Set report control properties
Control report pagination
Summarize report information
Add a sub report to an existing report
Create a mailing label report
View PivotTable and Pivot Charts
Sharing Data Between Applications
Import data into Access
Export data
Analyse Access data in Excel
Export data to a text file