Microsoft Access 2010: Advanced

Producer: Gopas

Duration: 9 hours.
This product is an online product and is a single-user, 1-year licence.


This course focuses on the creation of reports, data access pages and macros. It will also familiarize you with the options for database management, data import and export, as well as with the SQL language.
The course takes the form of tutorials, exercises and quizzes.

Course Content
- Pre-assessment (optional)
- 18 lessons
- Final test

Please Note: The demo is designed to be representative of this course, and may not be the course itself.

This product allows the student to print a certificate from the course on successful completion.

The recommended settings to run this course are:
- Any of following internet browsers: Internet Explorer 6.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
- 1 GHz CPU; 512 MB RAM; OS Windows 2000, XP, Vista or Windows7
- Display resolution of 1280 x 1024
- Soundcard, speakers or headphones are recommended


Screenshot 1Screenshot 2Screenshot 3


This course covers the following topics
• Report creation
• Reports with calculations
• Graphical editing of Reports
• Additional report options
• Pivot table and chart
• Object dependencies and properties inheritance
• Macro basics
• Assigning a macro to a button
• Data validation using macros
• Data evaluation via macros
• Database print and documentation
• Importing Access Objects and splitting a database
• Data exporting
• Program import and export
• XML format
• Navigation in a database
• Security and privacy in databases
• SQL language


Once you have completed this course you will be able to:
• Create and run reports
• Generate and use macros to perform specific functions
• Import and export information
• Understand the basics of SQL language

* required field