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.
How long is this course?
What do I need to know before attending?
It is assumed that you have a skill level equivalent to that gained through attending the introductory Access training.
What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:
- Enhance your Access databases by developing selective queries and action queries.
- Automate actions using macros and simple Visual Basic procedures.
- Manipulate data for reports, either within Access or by outputting to other Office applications.
Review of the elements of an Access database and the importance of table relationships.
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.
Automating simple tasks using the Controls Wizard.
Calculating simple expressions.
Using forms to provide selection criteria for queries.
More on Reporting
Revieing basic reports design.
Using sorting and grouping in reports.
Calculating aggregate values, like totals and averages.
Introducing the Switchboard Manager to design basic menus.
Startup menu options.
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.