Microsoft Access 2007 Introduction

Access 2007 Database Concepts

- What is a database?
- What is a relational database?
- What is a table?
- What is a record (row)?
- What is a field (column)?
- What is data?
- Data types

A First Look At Access 2007

- Opening Access 2007
- Exploring the Access 2007 window
- The Ribbon (Toolbar)
- Ribbon tabs
- Groups & Dialog Box Launcher
- Navigating - Quick keys (shortcut keys)
- Navigating - Pointer keys & quick keys
- Navigating - Mouse wheel
- Contextual tabs
- Minimising the Ribbon
- Quick Access Toolbar
- The Office Button
- Microsoft Access Help

Opening A Database & Security Issues In Access 2007

- Opening a database
- Security warnings
- Trusted Locations - Trust Centre
- Setting the default folder location within Access

Creating A Database & Using Views In Access 2007

- Creating a new database
- Creating a new blank database
- Saving a table
- Adding and renaming fields
- Using Datasheet View
- Using Design View
- Changing the view

Table Modification And Navigation In Access 2007

- Adding Fields - Design View
- Data Type - Overview
- Data Type - Descriptions
- Using the Attachment data type
- Adjusting column width
- Moving a column to rearrange the column order
- Adding records to a table
- Navigating through records within a table
- Closing a database
- Navigation Pane

Field Properties, Validation & Input Masks In Access 2007

- Field Properties
- Input Mask
- Validation Rules
- Field Properties - Guides Tables

Manipulating Records & Tables In Access 2007

- Closing an Object - Table
- Renaming an Object - Table
- Editing data within a record
- Deleting data within a record
- Using the Undo command
- Deleting a single record
- Deleting multiple records
- Save As - Database Object
- Deleting a table

Primary Keys And Indexing In Access 2007

- Defining a Primary Key
- Indexing
- Creating a single-field Index
- Creating a multiple-field Index
- Deleting multi-field indexes

Filtering & Sorting In Access 2007

- Text Filters
- Applying a single filter
- Clearing a single filter
- Creating multiple filters
- Clearing multiple filters
- Sorting

Relationships In Access 2007

- Table relationships
- One-to-many relationship
- Many-to-many relationship
- One-to-one relationships
- Creating relationships between tables
- Referential integrity
- Cascade options
- Cascade update related fields
- Cascade delete related records
- Enabling cascade options
- Deleting relationships