Introduction to Microsoft Access

Course Overview

Is your business data proliferating beyond your control? Are the links between your various files, spreadsheets and documents becoming too difficult to manage?

In which case, you need to consider consolidating your data within a database. This can seem an intimidating task, but if you approach it through Access, it is within the grasp of any computer literate user. While having the power of many more expensive and heavy-duty systems, it provides a much more familiar and intuitive approach to both building and using a database. It has the added advantage of probably already existing on your system. Microsoft Access training is thus perhaps the simplest and cheapest way for the non-technical person to approach databases.

What You Will Learn

• Basic database concepts and database design
• Building your database
• Entering, amending and viewing data
• Querying your database
• Creating and using reports

Audience

Anyone having simple database requirements or who wants to take the first steps towards database expertise.

Requirements

Duration

1 day

Structure

Learning Unit 1; Designing your database

1.1 Basic concepts; Tables, Rows and Columns

1.2 Data Types and Properties

1.3 Creating a Primary Key

1.4 Relationships between Tables; Foreign Keys and Referential Integrity

Learning Unit 2; Implementing Your Design

2.1 Finding your way around Access

2.2 Creating the Database

2.3 Creating the Tables

2.4 Creating the Relationships

2.5 Importing Data

Learning Unit 3; Querying and Editing Your Database

3.1 The Query Grid

3.2 Simple Queries

3.3 Sorting Data

3.4 Complex Queries; multiple criteria queries and multi-table queries

3.5 Adding, Editing and Deleting data in the datasheet

Learning Unit 4; Basic Database Applications I; Forms

4.1 Form Design

4.2 Creating Forms with the Form Wizard

4.3 Manually creating Forms

4.4 Sub Forms

4.5 Adding, viewing, filtering and sorting information in a form

Learning Unit 5; Basic Database Applications II; Reports

5.1 Designing Reports

5.2 Creating Reports in the Reports Wizard

5.3 Manually creating Reports

5.4 Multi-table Reports

5.5 Using Reports

Back to Top