View Basket
Recover Basket
Microsoft Access 2007 Advanced (1 day)
Assumes familiarity with all Access basics and experience of creating database tables forms, queries and reports .
Exchanging data
Importing data
Exchanging data with Excel
Exchanging data with Word
Linking to external data
Advanced forms
Creating option groups
Using a ComboBox control to select a record
Creating tabbed form layouts
Creating your own smart tags
Using the CanGrow and CanShrink properties
Hiding fields in printouts
Setting tab stops
Advanced queries
Using crosstab queries
Finding duplicate records
Working with action queries and backups
Update queries
Queries for creating tables and appending
Moving records with append and delete queries
Delete queries
Working with SQL statements
Creating trusted locations
Encryting and decrypting a database
Compacting and repairing a database
Database back up
Package and sign
Macros
Creating a macro
Running a macro
Using the macro builder
Conditional macros
Assigning macros to controls
Autoexec macros
Charts
The Chart Wizard
Adding charts to forms
Adding charts to reports
Editing charts
Switchboards
What is a switchboard?
The Switchboard Manager
Creating switchboard in design view
Adding buttons
Displaying a switchboard on startup