Learn how to create a database in Microsoft Access. Understand the basic concepts and get started straight away. Create a table and design the columns, restrict data entry with rules and calculations. Interogate a table with a select query and export the result through a report. Understand how to use basic queries. Create simple forms to use as data entry mechanisms. Import data or link data from Excel. Link tables to SharePoint.

This is the first step of three training courses in the Microsoft Access series. The course content is as follows:

Understand The Database Window

Database Objects - Tables - Queries - Forms - Report - Macro

Database Terminology -fields - records - data set

Creating a Database

Basic Tables and Table design, data types, data formatting and field rules

Using Queries and design your own. Select queries

Using the Auto Form Feature

Form Design -starting from a blank form. Add a table to a form and manipulate the fields

Using the Auto Report Feature

Report Design, create your own report, move and resize fields and labels.

Copying Data

Freezing Columns

Printing Tables

Printing Reports

Sorting Records

Using the Filter Sorts and advanced filters

Renaming Columns

Using the Chart Wizard

Importing data from Excel

Linking to Excel Data

After this course you will a good understanding of the basic concepts used in a Microsoft Access database.