Microsoft Access 2013 Intermediate

Course Code: MSACC2013ITM
Duration: 1 day
 
Overview
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.
 
Prerequisites
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.
 
COURSE CONTENT
Controlling data entry
Create advanced queries
Improving forms
Customising reports
Sharing data between applications
 
Review
Tables
Table relationships
Queries
Forms
Reports
 
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
 
PivotTable
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