Training/course: Access 2007/2010 Intermediate
Course Description
You have already noticed how easy it is to learn the basics of Access. Requesting information from databases using queries and filters is no problem for you. Now you realize that you have just scratched the surface of Access' potential. Access is such a useful program, you are tempted to go further and build your own databases. As with any construction you must start with the foundations. Poor foundations will result in a bad database.
At Learnit you will learn how to lay the foundations of a good database. Then you will learn how to construct the tables and the relationships, before finally designing the forms, queries, and rapports that are necessary for inputting and recalling data.
You can come to us even if you have already built a database but have encountered a few problems. But it is then important to inform the trainer of any issues prior to the course by email. If possible, your problems will then be solved during the course.
Course Content
On request we can cover other related topics, beyond those listed below:
- Advanced Forms and Reports
- Creating Action Queries
- Tab controls/elements
- Key Fields And Table Relations
- Fine-Tuning Data Entry Forms
- Pivot Table Macros
- Creating a Macro
- Testing and executing a Macro
- Macro-groups
- Applying Conditions
- Making/adjusting Toolbars
- Passwords and user definitions
- Appointing access-rights
- Introduction to Visual Basic
Course Prerequisites
Access foundation level or some experience with setting up your own database. You need to have experience of making tables, queries and simple forms.
Comments
This Access training course is given in tutorial form in a class of MS Office students. This means that students will work on their own course and at their own pace under the careful and diligent guidance of a tutor, rather than using a classical lesson with the teacher presenting to everyone at the same time. Only MS Office subjects are dealt with during the Office tutorial class. The tutor will help explain the theory and show you how to work through the course. He or she will be on hand to help you with any problems, give you practical tips and answer your questions. This class-based tutorial system has been tried and tested by us for many years and proves to be a satisfying and rewarding teaching method.
This system has many advantages. Not only does it allow you to learn at your own pace but it also gives you the opportunity to bring with you practical database applications from your own workplace. It is better if you can send these to Learnit before the course by email. Otherwise you can bring it with you on a USB or cd-rom.
All MS Office training courses are given using recent versions of MS Office. Most versions are as good as identical to each other, but the teacher will explain exactly any differences between versions. If you want to take the course using a particular version, you can bring this to our attention on the registration form.
