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

Book Now or Enquire

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

New Features of Access 2007

New General Features
Getting Started Window
Navigation Pane
Status Bar
Tabbed documents
File Type
Help
Security
Formatting
New Table Features
Sorting and Filtering
Field Enhancements
Data Type Recognition
Datasheet Total Row
Adding Fields
New Form and Report Features
Quick Create
New Layout Views
New Report View
Split Forms
Group and Sort
Stacked and Tabular Layouts
New Integration Features
Import and Export Wizards
Data Collection
SharePoint Services