Microsoft Access 2010: Intermediate

Producer: Gopas

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


In this course, you will learn advanced techniques of designing tables and queries. You will acquaint yourself in depth with the creation and use of forms.
The course takes the form of tutorials, exercises and quizes

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
• Field indexing and data validation
• Totals
• Aggregate functions
• Crosstab query
• Action queries
• Data normalization
• Make-Table query
• Form creation using wizard
• Working with form
• Creating forms in design view
• Working with form controls
• Calculated form fields
• Combo Box in forms
• Option buttons in forms
• Organising Form fields
• Creating a Form with a subform
• Subform insertion in design view
• Form as a user interface


Once you have completed this course you will be able to:
• design and create more advanced tables and queries
• create and use forms for data entry

* required field