Getting Started with Access

• • Starting Access
• • The Database Window
• • Basic Access On-Screen Features
• • Database Objects
• • The Database Wizard

Getting Assistance with Access

• • The Office Assistant
• • The Ask a Question Box
• • Other Ways to Get Help

Creating Tables and Adding Records

• • Creating a Table in Design View
• • Datasheet View; Adding a Record
• • Saving Changes; Moving Around the Datasheet
• • Finding a Record; Modifying and Deleting Records
• • Undoing Changes

Designing a Table

• • Determine data inputs and outputs for a database
• • Set a Primary Key
• • Creating Tables with Multiple Field Data Types
• • Switching Between Views and Object Windows
• • Basic Field Properties

Working with Data

• • Modify the Layout and Formatting of a Datasheet
• • Sorting & Filtering Data; Using Advanced Filters

Forms

• • Using AutoForm & Wizards to Design Forms
• • Entering Records Using a Form
• • Navigate through Records Using a Form
• • Using Form Sections (header, footer and detail)
• • Add Move Resize and Format Controls
• • Add a Calculated Control to a Form

Queries

• • Creating & Modifying Simple Select Queries
• • Restricting Records Returned by a Query
• • The Query Wizard
• • Multi-Table Select Queries; Calculated Fields and Query Properties
• • The Expression Builder

Reports

• • Creating, Printing & Modifying Reports
• • Using Report Wizards & AutoReports
• • Report Controls & Control Layout
• • Create a Label Report
• • Add Move Resize and Format Controls
• • Use report sections (header, footer and detail)
• • Add a calculated control to a report
• • Save a table, query or form as a web page; hyperlinks

Relational Database Management Systems

• • Design and Plan a Database
• • Determine Appropriate Data Inputs and Outputs
• • Describe Basic Principles of Relational Database Management Systems
• • Split a Database into Relational Tables Using Primary Keys

Table Relationships

• • Create and Edit Table Relationships
• • Enforce Referential Integrity
• • Specify Join Properties for Relationships
• • Use the Lookup Wizard
• • Display Related Records in a Subdatasheet

Modifying a Table

• • Set Table Field Properties
• • Use the Input Mask Wizard
• • Modify a Table in Design View
• • Import Data to a New Table
• • Use the Office Clipboard to Copy and Paste Data

Database Tools

• • Create a backup copy of a database
• • Use Microsoft Backup to create a backup set
• • Restore a database
• • Compact and repair a database

Database Design

• • Understanding the theory of Normal Forms; De-normalisation
• • Naming Conventions
• • Importing and Linking Data
• • Import data from different sources
• • Create a link to data stored in a spreadsheet
• • Create a link to tables in another Access database

Access Performance Issues

• • Indexes, Data Validation & Table Level Validation
• • Relationships and Referential Integrity
• • Field Types
• • Referential Integrity Options; Join Types
• • Using Lookups for Referential Integrity
• • Multi-Table Datasheet View

Building and Modifying Forms

• • Advanced Forms Features; The Form Worksurface
• • Creating a Calculated Control
• • Adding a Graphic to a Form
• • Multi-Table Forms
• • Using the Subform Control; Switchboard Forms

Advanced Queries

• • Filtering Query Results
• • Parameter Queries & Summary Queries
• • Formatting Query Output
• • Query Join Types; Self Joins and Aliases; Cross Joins

Action Queries

• • Planning an Action Query
• • Make Table, Append, Delete & Update Queries

Producing Reports

• • Applying Sorting and Grouping to Reports
• • Performing Calculations on Reports
• • Adding a Graphic to a Report
• • Using the Subreport Control

Queries

• • Creating & Modifying Simple Select Queries
• • Restricting Records Returned by a Query
• • The Query Wizard
• • Multi-Table Select Queries; Calculated Fields and
• Query Properties
• • The Expression Builder

Reports

• • Creating, Printing & Modifying Reports
• • Using Report Wizards & AutoReports
• • Report Controls & Control Layout
• • Create a Label Report
• • Add Move Resize and Format Controls
• • Use report sections (header, footer and detail)
• • Add a calculated control to a report
• • Save a table, query or form as a web page; hyperlinks
• • Modifying Section Properties
• • Using the Chart Wizard

Relationships and Referential Integrity

• • Many-to-Many Relationships
• • Setting Cascade Update and Delete Options

Customising Menus and Toolbars

• • Creating Custom Menus and Toolbars
• • Customising Menus and Toolbars

Macros and Command Buttons

• • Creating a Macro
• • Macro Examples
• • Designing Application Menus
• • Creating a Menu Form
• • Setting Startup Defaults

Hyperlinks and Internet Publishing

• • Using Hyperlinks and Publishing on the Internet
• • Using Hyperlinks in Tables and Forms
• • Creating a Data Access Page
• • Publishing Data on the Internet

Database Management Tools

• • Database Management; Setting a Database Password
• • Encrypting and Decrypting a Database
• • Compacting a Database
• • Repairing a Database
• • Replicating a Database
• • Using Add-ins

Multi-User Databases

• • Shared Databases
• • Setting Default Locking Properties
• • Creating Groups and Users
• • Setting User Permissions
• • Assigning Ownership