Access 2002/3 Power User

Target Audience

Experienced users of Access or those upgrading from a previous version.

Pre-requisites

To fully benefit from this course, attendees are expected to be confident users of Access and have attended the Access Creating Databases course or be familiar with these topics.

On completion of the course, delegates will be able to:

• Analyse a database for performance
• Use multi-field primary keys
• Create a Crosstab query to analyse data in a table or query
• Use the Expression Builder to create complex calculations/lookups
• Use the Find Duplicates and Find Unmatched Query Wizards
• Create a chart on a form
• Use form controls to collect report criteria from a user
• Include PivotTables analysis in the database
• Use a SQL Union Query to consolidate data from different tables
• Split the tables from a database file
• Secure a database file and its objects to prevent unauthorised access
• Create simple macros
• Use conditions in macros
• Use macros with form objects
• Use simple VBA commands in the database
• Create sophisticated forms with macro or VBA functionality
• Create custom functions using VBA

Analysing Tables & Working with Indexes

Check a Table for Performance  • Creating Single & Multiple Field Indexes • Multiple Field Primary Keys

Special Query Wizards

The Crosstab Query Wizard • Modifying/Formatting Crosstab Queries • Crosstabs based on Queries • Using Criteria and Adding Parameters to a Crosstab • Find Duplicates and Find Unmatched Query Wizards

Expression Builder

Create Complex Expressions • Use Domain Aggregate Functions

Charting

Creating a Chart using a Wizard • Modifying & Formatting a Chart • Updating Chart Data

Form Controls to Collect Query Criteria

Create Combo/Unbound Text Box to Collect Criteria • Use Criteria with a Query

Pivot Table Analysis

Create Pivot Table Using Access Data  • Refresh an Access Pivot Table

SQL

SQL Basics  • Consolidate Data Using An Sql Union Query

Splitting a Database

Choosing to Split a Database  • Using the Database Splitter • Working with a Split Database • Updating Database Links

Database Security & Protection

Creating A Workgroup/Administrator • Adding Groups/Users • Assigning Permissions & Testing Database Security • Setting/Removing Passwords • Encoding/Decoding Database Files • Hiding/Unhiding Database Objects

Macro Basics

Creating/Running/Modifying Macros • Using Conditional Macros • The MsgBox & InputBox Functions • Using Macro Names

Macros on Forms

Attaching Macros to Form Events • Option Groups and Macros  • ApplyFilter Macro Action • Handling Exceptions

VBA Introduction

Understand Difference Between Macros and VBA  • Simple Form/Sub Procedures  • MSGBOX & INPUTBOX Functions  • Standard Modules  • Running Procedures from Controls  • Navigating the VBA Editor

You may also be interested in some of the following related courses below:

Microsoft - Access 2002/3 - Queries & Reports
Microsoft - Access 2002/3 - Creating Databases
Microsoft - Access 2002/3 - VBA

Send this course to a friend
 

Course Fee

We have a rolling programme of Scheduled Public sessions for the majority of standard courses – both in IT Productivity and Management & Soft Skills. Group sizes are limited to ensure optimum learning amongst delegates.

Passport Saving Plans

The advertised rates are on a per delegate basis, however if you have more than one attendee you may be entitled to a discount. To maximise your training budget why not email or contact one of our training consultants to see what rates/discounts may apply for your particular requirement.

Alternatively, if you have regular, ongoing training requirements, you may find one of our Training Passports of interest. Each is designed to provide our clients with significant benefits:
• Far better discounts
• Less administrative overhead
• Better control of your training schedules

Scheduled Training Passports
Enables you to pre-purchase training places on any of our standard scheduled courses.

Private Training Passports
Enables you to pre-purchase private training days against any of our standard courses.

Each of the above passports come with substantial discounts.

To maximise your training budget why not email or contact one of our training consultants who will be happy to provide you with the latest offers on any of our Training Passports. See what rates/discounts may apply for your particular requirement.

Please fill out the form below for more details:

First Name
Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details	Characters Left.