Revising What's New in Access 2007

• New Features
• Database Templates
• Enhanced Datasheet Views
• Security Warnings and the Trust Centre

Modifying Fields

• Applying and Modifying Data Types
• Modifying Column Data Types
• Formatting Text Data Type
• Memo Data Type
• Formatting Hyperlink Data Type
• Formatting Date/Time
• Database Object Naming Conventions
• Converting Between Data Types
• Changing a Field to a Different Data Type

Lookup Fields

• Creating and Editing a Lookup Field or Column
• Creating a Lookup From Value in a Table or Query
• Creating a Lookup From Value You Type In

Validation Rules

• Creating Different Validation Rules

Input Masks

• Creating Different Input Masks in a Field

Default Values

• Applying Different Default Values into a Field

Mandatory Fields

• Setting Required Fields in a Database

Basics of Relationships

• Creating Valid Relationships
• Identifying a Related Table
• Creating Relationships
• Deleting Relationships
• Creating a Primary and Composite Key

Creating Relationships

• Creating a One-to-One
• Creating a One-to-Many
• Creating a Many-to-Many
• Modifying Relationships
• Creating Relationships Between Tables
• Enabling Cascade Options
• Deleting Relationships

Applying Inner and Outer Joints

• Applying an Inner Join
• Applying an Outer Join

Applying and Using Referential Integrity

• What is Referential Integrity?
• Setting Referential Integrity within Relationships

Applying Automatic Deletion of Related Records

• Cascade Options
• Cascade Update Related Fields
• Cascade Delete Related Records

Query Types

• Enabling the Content
• Creating and Using a Query to Update Data
• Populating Data in the Table
• Creating an Update Query
• Creating and Using Queried to Delete Data within a Table
• Creating an Update Query
• Creating and Using a Query to Delete Data within a Table
• Creating a Make-Table Query
• Creating an Append Query

Grouping Information in A Query

• Using Aggregate Functions
• Using Functions
• Using COUNT, SUM, AVG, MIN and MAX