Microsoft Access 2013 Advanced

Course Code: MSACC2013ADV
Duration: 1 day
 
Overview
Training in and use of Microsoft Office Access 2013 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft Office Access 2013. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
 
Prerequisites
To ensure the successful completion of Microsoft Office Access 2013 Advanced, the Introduction and Intermediate courses or equivalent knowledge are recommended.
 
COURSE CONTENT
Structing existing data
Writing advanced queries
Simplifying tasks with macros
Improving forms and reports
 
Structuring Existing Data
Normalise tables
Analyse tables
Create a junction table
Improve the table structure
 
Writing Advanced Queries
Create subqueries
Create unmatched and duplicate queries
Summarize data using a crosstab query
 
Simplifying Tasks with Macros
Create a macro
Attach a macro to events of database objects
Validate data using a macro
Automate data entry using a macro
 
Making Effective Use of Forms
Display a calendar on a form
Organise information with tab pages
Display a summary of data in a form
Making Reports More Effective
Include a chart in a report
Print data in columns
Cancel printing of a blank report
Create a report snapshot
Maintaining an Access Database
Link tables to external data sources
Manage a database
Determine object dependency
Document a database