Microsoft Access Advanced

Microsoft Access Advanced

About the course:
This course aims to develop participants skills in database techniques and terminology to an advanced level.

By the end of the course delegates will be able to manage well-structured databases, create advance level queries, forms and reports, enhance data access pages, establish database security and use the database maintenance tools.

Course Content:
Course Content Includes:

Managing Well-structured Databases

• Understand Database Design
• Use the Table Analyzer Wizard
• Link Tables from Different Databases
• Make a Linked Table Local

Customizing Field Properties

• Modify Lookup Fields
• Create and Modify Custom Input Masks
• Set Validation Parameters
• Understand How to Optimise Data Type Usage

Defining Relationships

• Set Multiple-field Primary Keys
• Examine One-to-one Ralationships
• Examine Many-to-many Relationships
• Look at and Use Cascade Updates and Deletes

Creating Advanced Queries

• Find Records Based on Several Criteria
• Apply Filters to Queries
• Create Parameter, Action, Update and Append Queries
• Look at Relationship Joins

Creating Advanced Forms

• Create Forms in Design View
• Examine Subforms and Subreports
• Create and Use Toggle Buttons and Combo Boxes
• Create Tabbed Forms
• Create Switchboards

Producing Reports

• Add and Modify Images
• Group and Sort Report Data
• Add Subreport Controls to Reports
• Create Parameter Reports
• Add and Modify Shapes and Lines

Enhancing Data Access Pages

• Create Access Pages in Design View
• Group Data in Data Access Pages
• Add PivotTables and PivotCharts to Data Access Pages

Establishing Database Security

• Examine Security Issues
• Set Database Passwords
• Encode and Decode Databases

Using Database Maintenance Tools

• Replicate Databases
• Use the Database Splitter
• Create MDE Files

Using Macros to Automate Database Tasks

• Examine Macros and Modules
• Create Modules
• Create Buttons and Assign Modules

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 completing an ECDL qualification or improve their understanding other Microsoft Office packages.


Code : Time : Duration : Day : Tuition Fee : Admin Fee
B02183 003 09:30 - 16:30 01/06/2010 - 01/06/2010 Tuesday Fee Enquiry