MICROSOFT ACCESS INTRODUCTION COURSE OVERVIEW

A 2 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 2 days, 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.