IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals

Course Title:
Microsoft Access - Advanced

Duration: 2 days

Course Overview
With basic skills and some experience of Microsoft Access, the topics covered on this course will help you to enhance your relational databases and move towards the creation of genuine "user" applications.

Target Audience


It is assumed only that you have a skill level equivalent to that gained through attending the
Access Introductory Course.

Course Content


Database Structure
Review of the elements of an Access database and the importance of table relationships and referential integrity.

Advanced Querying
Creating multi-table queries with parameters and selection criteria. Action queries to perform automatic updates, archive and deletion of records.

Forms & Reports
Using sub-forms and sub-reports, grouping data and displaying summary statistics for groups.

Macros
Creating macros to assist users with navigation through an application and other routines. Assigning macros to buttons and designing end-user forms.

Access Basic
An Introduction to the programming power within Access, reading and writing simple procedures, with and without Wizards.

Importing & Exporting
Importing data and structures from other database applications. Exporting selective data to Microsoft Word and Excel.

Security
Creating Users and Groups, assigning object permissions to users and groups. Repairing and Compacting your databases.

Enter your email address to register for our newsletter: