Overview & Prerequisite

This course is designed for existing intermediate users of Access 2007 or those who have attended an intermediate or foundation course. This course is aimed at those people who will be designing the database.

Course content

Getting Started with 2007
Using the Ribbon instead of menus
The Quick Access Toolbar
Command Tabs
Contextual Command Tabs
The New File Menu

Querying
Crosstabs
Parameters
Calculated
Totals
Action Queries
Make table
Append
Delete
Update

Multiple Table Queries
Joining tables
Types of joins
Relationships Vs Joins
AutoLookup Query

Relationships
Understanding relational databases
Types of relationships
1-1
1-Many
Many-Many
Bridging tables

Forms
Using expressions
Inherited filters
Subforms / subreports
Grouping and sorting data

Object Linking and embedding
Adding a picture / object
Editing objects
drag and drop database objects

Protecting data
Valadating data entry
Setting passwords
Hiding objects
Introduction to database sucurity

Creating and using macros
Creating
Editing
Running
Grouping
Conditional macros

Creating a database application
Using forms
Autostart-ups
Hiding windows options
Creating buttons