Microsoft Access Training

Master the fundamentals of Microsoft Access the quick way on this 2-day introductory Access training course. Microsoft Access is a very popular database programme. It allows data to be analysed and sorted, specific information to be searched for, and the results to be used to produce reports, lists and more very easily.

Led by a certified Access trainer, this course involves a number of hands-on exercises so that you can experiment with what you are being taught and there is plenty of time to ask questions.

What Will I Learn

By the end of this training course, you will be a confident, independent Access user. You will be able to describe and create databases, access, view and process data using queries, produce forms for data entry and view data in report format.

You will learn how to:

• Design and create a new database in Access.
• Modify the structure of an existing database.
• Add records to a new table.
• Add transactional records to a lookup database.
• Use the various data validation features in Access to protect data.
• Format the data in a table.
• Export records to, and import records from, a wide variety of sources and applications.
• Quickly create simple queries.
• Create and use parameter and calculated queries.
• Create meaningful reports from tables.
• Use forms to create a helpful user interface.