Microsoft Access – Database Design Essentials

Is it right for me?

Our Access Database Design - Essentials course is designed for new users who need to build relational database systems.

The course will enable you to build databases, e.g. training records, help call log, etc., and quickly and easily enter and extract information.

You should be competent in using a PC for general business use. No previous experience of Access is required.

What will I get out of it?

By the end of the course you will be able to:

• Create a database
• Build tables, forms, queries and reports
• Create fully relational databases

Versions available

2003, 2007, 2010

Related courses in our range

• Access Query Writing
• Access Advanced Forms and Interfaces
• VBA in Access Part 1 - Automation
• VBA in Access Part 2 - Access Objects and DAO

What does it cover?

Creating a database

• Creating a new database
• Database elements

Creating a data table

• Setting field properties
• Using input masks
• Validation rules
• Default values
• Setting a primary key
• Creating lookup fields

Working with data tables

• Adding data
• Deleting data
• Sorting data
• Data entry quick keys
• Filtering

Creating simple data forms

• The form wizard
• Building and amending forms
• Entering data using forms

Extracting data using queries

• Creating select queries
• Setting criteria
• Creating parameter queries
• Adding calculations to queries

Printing and reporting

• Printing tables and queries
• The report wizard
• Building and amending reports
• Error checking
• Using layout view (2007 and 2010)

Principles of relational databases

Importing data

• Importing data from Excel

Building relational databases

• Linking information between tables
• One-to-one and one-to-many links
• Defining referential integrity
• Printing table relationships

Sub datasheets

• Viewing a subdatasheet
• Adding a subdatasheet

Building multiple table queries

• Deciding which tables to use
• Adding tables to the query
• Creating links between tables
• Join properties

Advanced form and report design

• Field properties
• Adding calculations
• Adding headers and footers
• Adding dates, times, page numbers
• Sorting and grouping
• Concatenating fields

Case study