INTERMEDIATE ACCESS - Stage 2 Course

Overview

This course is designed for those users who wish to advance their current knowledge of Access to take advantage of the more complex features. On completion students will understand relational databases, be able to work with related tables as well as being able to generate more complicated queries and create advanced forms and reports.

Prior Knowledge Requirements

The intermediate course is suitable for those with a basic working knowledge of Microsoft Access, and preferably have attended the Introduction to Access course.

The course covers the following areas:

Creating Relational Databases

• Database normalising
• Establishing relationships
• Table links
• Types of relationships
• Adding referential integrity

Working with related tables

• The lookup wizard
• Changing lookup fields
• Inputting data to related tables

Defining data entry rules

• Using Input Masks
• Setting a field property
• Setting a validation rule

Controlling Data Entry

Restrict data entry using field properties

Establish a pattern for entering field values

Create a list of values for a field

Using advanced Query features

• How to join tables in Queries
• Creating a calculated field
• Action Queries

Creating advanced Queries

• Summarise and group values
• Create a Crosstab Query
• Using a Parameter Query

What's next?

At the end of this course the student will have the knowledge and experience to progress the Advanced Access course which shows how to simplify tasks using macros, ensure effective use of forms and reports with advanced features, create advanced queries including pivot tables and charts and to maintain the database.

 

 

    

Improving Forms

• Design a Form layout
• Enhance the appearance of a Form
• Restrict Data Entry in Forms
• Add a Command Button to a Form

Advanced Form design

• Working with graphics
• Working with calculations
• Working with Combo Boxes
• Working with Unbound Controls

Working with Subforms

• Creating Subforms
• Merging Forms and Subforms
• Analysing data with Subforms

Using advanced Report features

• Organize Report information
• Format a Report
• Set Report Control properties
• Control Report Pagination
• Summarize Report information
• Add a Subreport to an existing Report
• Create a Mailing Label Report

Sharing data accross Applications

• Import data into Access
• Export data
• Analyse Access data in Excel
• Export data to a text file