Microsoft Access Intermediate

Microsoft Access Intermediate

About the course:
This courses aims to develop participants skill in database techniques and terminology.

By the end of the course delegates will be able to modify table structure, field properties, queries and reports. Customise forms , create basic data access pages and manage database files.

Course Content:
Modifying Table Structure

• Move and Delete Fields
• Modify Multiple Data Types
• Create and Use Hyperlinks

Creating Lookup Lists and Input Masks

• Understand the Lookup Wizard
• Create and Use Lookup Lists
• Generate and Use Value Lists
• Understand Input Masks
• Apply and Use Input Masks

Modifying Field Properties

• Understand Field Properties
• Add Captions to Fields
• Add Default Values
• Understand Smart Tags
• Propagate Field Properties
• Specify Field Size and Format
• Understand Indexes

Importing and Exporting Data

• Import Data to Existing Tables
• Export Data from Access to other Applications
• Import XML Files to New Tables
• Export Databse Data into XML Files

Creating and Modifying Queries

• Create Multi-table Queries
• Examine Operators and Expressions
• Specify Criteria
• Create Crosstab Queries
• Display Queries in PivotChart
• Add Calculated Fields Using Expression Builder
• Format Calculated Fields
• Understand Aggregate Functions

Customising Forms

• Understand Form Sections
• Understand Controls
• Create Calculated Controls
• Add Option Groups
• Define Tab Order
• Change Form Properties

Modifying Reports

• Understand Report Sections
• Add Calculated Controls
• Format Controls
• Align, Resize and Space Controls

Creating Basic Data Access Pages

• Save Forms and Reports as Data Access Pages
• Create Data Access Pages Using a Wizard
• Create Hyperlinks

Managing Database Files

• View Object Dependencies
• Use the Documenter
• Compact and Repair Databases
• Back Up Database Files

Equipment Requirements:
All equipment will be supplied by City Business.

Assessment:
Due to the workshop nature of this one day course, there are no formal examinations or assessments.

Progression:
Delegates may wish to extend their knowledge by attending an Access Advanced course after successfully completing the Intermediate level.

Code : Time : Duration : Day : Tuition Fee : Admin Fee
B02181 001 09:30 - 16:30 22/09/2009 - 22/09/2009 Tuesday Fee Enquiry

B02181 002 09:30 - 16:30 21/10/2009 - 21/10/2009 Wednesday Fee Enquiry

B02181 003 09:30 - 16:30 19/11/2009 - 19/11/2009 Thursday Fee Enquiry

B02181 004 09:30 - 16:30 02/12/2009 - 02/12/2009 Wednesday Fee Enquiry

B02181 005 09:30 - 16:30 19/01/2010 - 19/01/2010 Tuesday Fee Enquiry

B02181 006 09:30 - 16:30 10/02/2010 - 10/02/2010 Wednesday Fee Enquiry

B02181 007 09:30 - 16:30 23/03/2010 - 23/03/2010 Tuesday Fee Enquiry

B02181 008 09:30 - 16:30 21/04/2010 - 21/04/2010 Wednesday Fee Enquiry

B02181 009 09:30 - 16:30 25/05/2010 - 25/05/2010 Tuesday Fee Enquiry

B02181 010 09:30 - 16:30 09/06/2010 - 09/06/2010 Wednesday Fee Enquiry

B02181 011 09:30 - 16:30 27/07/2010 - 27/07/2010 Tuesday Fee Enquiry