Describing a Database
Overview and explaining Tables
Viewing Tables
Create a Query
Looking at Design View
Exploring Forms
Exploring Reports
Create a Database using the Wizard template
Modify Database - contacts, key fields
Creating Tables
Primary Keys
Creating Specific Headers in a Table
Create a Supplier Table
Using Design View and Primary Fields
Data Types and Properties
Error Alerts - Incorrect data keyed in
Change or Delete Field Names
Tables and Rows
Importing for Excel
Importing Data
Importing Delimited
Importing a fixed width text file
Importing from Access
Importing from HTML web page
Checking the tables have updated
Exporting from Access to Excel
Using form wizards and design views
Simplifying Data Entry
Change Text/Font Properties in Design View
Changing Fields in properties
Selecting Objects, colour, special effects
Aligning Text
Changing Background
Adding Graphics and Captions
Creating a Combo box and Query
Form Creation
Changing Form Design
Relationships between Forms, Tables & Queries
Creating a Subform using the Wizard
Change Design Layout
Locating Information
Filter by name, Character or wildcard
Filter by exclusion or by selection
Display results in report or form
Filter information in Table by Area
Using 'OR' to increase filter choices
Advanced Sort/Filter of Data
Sorting Information using Queries
Using Expression Builder for Auto Calculations
Creating Test Tables and Fields
Changing Properties of Test Fields
Setting Data Restrictions in a Field
Field Tests
Creating a delete query
Check query
Creating a Report using Report Wizard
Report Wizard Evaluating
Adding Sub Reports to a report
Modifying the Sub Reports
Using the Expression Builder
Static Webpages
Visual Basic Application
Using Auto Page
Open the Browser and Make Changes
Add Headers, Bullets
Importing XML
Linking Databases
Creating the Switchboard Manager
Edit the Switchboard Page
Using a Macro
Preview and Edit Forms
Create Splash Screen
Format Splash Screen
Adding Check Box and Command Button
Start Up Options and Controls
Custom Menus - Switchboard
Custom Menus - Splashscreen
Splitting a Database
Security