Microsoft Access Level 2

Microsoft Access Level 2 – Course Outline

 

About This Course

You will improve and customise tables, queries, forms and reports, and share Access data with other applications. This course is designed for individuals who wish to learn intermediate-level operations of Microsoft Access.

 

Target Audience

Delegates may also include individuals whose job responsibilities include creating databases, tables and relationships, as well as working with and revising intermediate-level queries, forms and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.

 

At Course Completion

After completing this course, students will be able to:

 

• Understand the basics of a relational database

• Cover the basic process of starting Access and creating a database

• Create tables and add, edit or delete data

• Add validation to prevent incorrect data from being entered

• Sort and filter tables

• Create queries to retrieve specific items from an Access database

• Create forms to make it easier to view or get the items that you want

• Create reports to view, format and summarise the information in your database

 

Course Content

 

Unit 1 - Controlling Data Entry

• Constrain Data Entry Using Field Properties

• Establish Data Entry Formats for Entering Field Values

• Create a List of Values for a Field

 

Unit 2 - Joining Tables

• Create Query Joins

• Join Tables That Have No Common Fields

• Relate Data within a Table

 

Unit 3 - Creating Flexible Queries

• Set the Select Query Properties

• Retrieve Records Based on Input Criteria

• Create Action Queries

 

Unit 4 - Improving Forms

• Restrict Data Entry in Forms

• Organise Information with Tab Pages

• Add a Command Button to a Form

• Create a Subform

• Display a Summary of Data in a Form

• Change the Display of Data Conditionally

 

Unit 5 - Customising Reports

• Organise Report Information

• Format Reports

• Control Report Pagination

• Add a Calculated Field to a Report

• Add a Subreport to an Existing Report

• Create a Mailing Label Report  

 

Unit 6 - Sharing Data Across Applications

• Import Data into Access

• Export Data to Text File Formats

• Export Access Data to Excel

• Create a Mail Merge

 

 

Course duration: one day.

​