Learning Outcomes
By the end of this course students will be able to:

Create advanced queries to manipulate data
Build advanced forms for efficient data entry
Layout detailed reports
Create macros to carry out tasks
Use productivity tools to automate your database and analyse your data
Understand how to use a database in a network environment
Operate a database securely

Method
This course is provided as hands on and includes and extensive workshop manual and data disk for use during the course.

More on Tables and Queries

Adding an OLE object to a table
Adding a Hyperlink to a table
Advanced Select queries
Using advanced calculations
Revisiting built-in functions
Using totals in queries
Types of totals
Creating Crosstab queries
Action Queries
Update Queries
Delete Query
Append Query
Make table Query
Duplicate records
Unmatched records

More On Forms

Using form wizards
Chart wizards
Pivot tables wizard
Creating a Subform
Properties of forms
More on controls
Using combo boxes and list boxes
Using a Value list
Using Option groups
Using Hyperlinks in forms
Using OLE objects in forms
Creating a form template

Advanced Reports

Sorting and Grouping
Headers and Footers with Expressions
Subreports
Multiple column reports
Saving reports as HTML

Macros

What is a macro?
Events and macros
Creating and running a macro
Command button macro
Creating a macro from forms or reports
Using conditions in macros
Creating macro groups

Database Administration

Multi-user environments
Locking records
Database splitter
Converting databases

Database Security

Access Security Model
Workgroup database
User database
Securing your database
Database password
Running the security wizard
Creating user and group accounts
Setting and assigning permissions