Course 50533A Learn Microsoft Office Access 2010 Step by Step, Level 2

Part 2 Relational Database Techniques

Learn Microsoft Access 2010 Step by Step, Level 2

Maintain Data Integrity

Restricting the Type of Data

Restricting the Amount of Data

Restricting the Format of Data

Sidebar: Creating Custom Formats

Restricting Data by Using Validation Rules

Sidebar: Simple Validation Tests

Restricting Data to Values in Lists

Sidebar: Multicolumn Lookup Lists

Restricting Data to Values in Other Tables

Sidebar: Multivalued Fields

Key Points

Create Custom Forms

Modifying Forms Created by Using a Wizard

Adding Controls

Adding Subforms

Sidebar: Different Types of Forms

Using E-Mail Forms to Collect Data

Key Points

Create Queries

Creating Queries by Using a Wizard

Creating Queries Manually

Using Queries to Summarize Data

Using Queries to Perform Calculations

Using Queries to Update Records

Using Queries to Delete Records

Key Points

Create Custom Reports

Creating Reports Manually

Modifying Report Content

Sidebar: Adding Hyperlinks, Charts, and Buttons

Adding Subreports

Sidebar: Layouts

Key Points

Programme scope, delivery arrangements and suitability are confirmed during enquiry.