Access 2010 - Course List
-
The course is designed to introduce users to the basics of Access and to enable them to create a database from scratch to include basic input forms, queries and reports.
2 days
ACC-10-01
-
Learn to navigate an existing database. Use forms to search for, add, edit and delete information. Incorporates module: ACC-10-06 Access 2010 Viewing & Searching a Database.
2 hours
ACC-10-02
-
Design simple forms to ease the input and display of information held in the database.
2 hours
ACC-10-03
-
Create simple queries to find information in a database
2 hours
ACC-10-04
-
Extract information from the database with reports. Use the wizard to create simple reports. Edit the properties & controls.
Half day
ACC-10-05
-
How to find and view information in a database through the use of existing forms, queries and reports.
2 hours
ACC-10-06
-
Create effective forms using some of the more advanced form design features.
Half day
ACC-10-07
-
Understand the types of query available. Build queries that manipulate or archive the data in a database.
2 hours
ACC-10-08
-
A look at the more complex reporting options. Enhance reports with the use of graphics/charts and subreports.
Half day
ACC-10-09
-
An overview of the VBA language in Access.
2 days
ACC-10-11
-
Apply security to a database and understand security files.
Half day
ACC-10-12
-
A session to cover any aspects of Access.
1 hour - 1 day
ACC-10-13