Microsoft Access Training Course

Access, the Microsoft Office database management program, provides a powerful set of tools that are sophisticated enough for professional developers, yet easy for new users to learn. Now everyone in your organization can create or use powerful database solutions that make organizing, accessing and sharing information easier than ever.

A 1 day Introduction Course, aimed at the new user, this course aims to give users the confidence and knowledge to create and use Access databases. By the end of the course, users will be able to create and amend database structures, manipulate data and produce forms and reports.

Flat and Relational Databases

• Gain an understanding of the differences between the two different types of database structures.

Getting started with Access Databases

• Introduces you to the key features of Access before creating an amending your own databases.

• Understanding Database terminology

• The specification

• The Access screen tour

• The Access objects

• Creating a database

• Amending an existing database

Tables
Shows you how to add/edit the Tables that are used to hold all the data used within the database.

• Field properties

• Data entry

• Design mode and working mode

• Primary and foreign keys

• Naming conventions

• Modifying an Access table

• Saving a table

• Filtering information

• Sorting information

Queries
Manipulate the data and find specific records.

• Running queries

• Creating queries

• Amending existing queries

• Working with different views

• Finding information

Forms
Create and edit user friendly forms for you users to complete.

• Creating forms using Wizards

• Creating forms using Design View

• Edit existing form properties

Reports
Presentable ways of printing your data.

• Reporting wizards

• Printing Report Labels

• Creating custom reports

Problem solving

• Throughout the two days you will be shown a variety of common errors and solutions to these problems.

• An improved user experience, automatic error checking, automatic property updating, and the capability to view object dependencies help you work more productively.