Course Description
You need to know more about MS Access. Which one of these situations suits you?

• You already use pre-existing databases and all you need to do is input or recall data.
• You want to build your own databases, be it from a simple table to completely interfaced menu applications.

If you fall into the first category you probably understand what a database is and what it can do. In a (relational) database data is stored in tables. Each table can be compared to a box of index cards, where details are recorded. A database is a collection of one or more tables. Access makes it very easy to make tables and to input and recall data. It is not difficult! In fact you will find it easy and even enjoyable! At Learnit we will teach you how this all works and, if you like, you can even bring one of your own databases with you to work on during the course.

If you fall into the second category then you probably want to spend less time dealing with understanding databases and Access components, and instead devote yourself to practicing making forms, queries, tables and even complete databases.

In both cases you have come to the right place! You will be able to learn exactly what you want to get from Access and at you own level.

Course Content

• Introduction to Databases
• Tables in a database
• Making Tables and inputting data
• Changing, updating, and removing details
• Designing your own Table
• Changing a Table’s set-up
• Sorting and searching for data
• Form and Selection filters
• Indexing
• The Database and Relationships Window
• Recalling data using Queries
• Working with multiple tables
• Importing data from Excel
• Creating simple input Forms for use by data-entry staff
• Modifying Form design
• Making Reports from Records

Course Prerequisites
Basic understanding of Microsoft Windows operating system

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.

Het is ook mogelijk een incompany-training te volgen. Bel 020-6369179, of mail ons voor een offerte op maat. Wist u dat u met strippenkaarten voordeliger uit bent?