Course description
Who is this course for?
With basic skills and some experience of Microsoft Access, the topics covered on this intensive course will help you to develop the power of your relational databases.
Content
Database Structure
Review of the elements of an Access database and the importance of table relationships.
Understanding Indexes.
More on Queries
Reviewing the basics of SELECT Queries.
Using parameters as selection criteria.
Creating ACTION queries to perform automatic updates, archive and deletion of records.
More on Forms
Reviewing basic form creation.
Using controls such as Combo-Boxes to enhance forms.
Calculating simple expressions.
Using forms to provide selection criteria for queries.
Creating sub-forms.
More on Reporting
Reviewing basic reports design.
Using sorting and grouping in reports.
Calculating aggregate values, like totals and averages.
Using sub-reports.
Creating Menus
Introducing the Navigation options to design basic menus.
Startup menu options.
Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Suitability - Who should attend?
It is assumed that you have a skill level equivalent to that gained through attending the introductory Access training.