Access

at_logo

.

Welcome to AutoTRAIN

“The Professionals Choice”

for all Training, Consultancy

and Support

.

Microsoft Product Courses
Microsoft Product Courses
MS Access
MS Access Introduction MS Access Intermediate MS Access Advanced

Microsoft Access Introductory Level
Course Duration: 1 Day Pre-requisites: Working knowledge of Microsoft Windows would be useful but not essential Printable Version back to contents			Course Contents What is a Database? Creating a Database The Database Window Understanding Access Objects Creating a Table The Primary Key Adding and Viewing Records Saving Records Moving quickly around the Table Editing Data in a Tale Formatting the Table Searching for Records Editing the Table Design Creating Queries Selecting Records Using a Query Sorting Records Creating and Manipulating Forms and Reports

Microsoft Access Intermediate Level

Course Duration: 1 Day Pre-requisites: Students should be familiar with Microsoft Access and have a sound knowledge of the topics indicated in the introductory course structure Printable Version back to contents			Course Contents Setting up Table Relationships Importing Data from Other Databases and Spreadsheets Creating the Table Relationships Multi-Table Queries Using Multiple Criteria Creating Calculated Fields Summarising Data Using a Select Query More on Form and Report Design Control Properties Using the Toolbox Merging With Microsoft Word Using Action Queries

Microsoft Access Advanced Level

Course Duration: 1 Day Pre-requisites: Students should have a thorough knowledge and understanding of all introduction and intermediate course topics. Printable Version back to contents			Course Content Advanced Queries Creating Form or Query based Macros Using Auto-Executing Macros Application Design Creating a User Interface Creating Main and Sub Forms with Form Controls Using Custom Toolbars Understanding Administrators, Owners and Groups Backing up a Database Compacting a Database Repairing a Database Using Attached Tables from other Databases

home

courses

- Other

- Microsoft

special offers

e-booking

enquiry

consultancy

drawing management

portfolio

free newsletter

map

contact us

.

User Group Website

© AutoTRAIN 2006. All rights reserved