Database

Using the Application

Database Concepts

Understand What a Database Is
Understand How a Database is Organised
Understand What a Primary Key Is
Understand What an Index Is
Understand the Purpose of Relating Tables in a Database

First Steps with Databases

Open (and Close) a Database Application
Open and Log Onto an Existing Database
Create a New Database
Save a Database to a Location on a Drive
Use Available Help Functions
Close a Database

Adjust Settings

Change Between View Modes in a Table, Form and Report
Display and Hide Built-In Toolbars

Tables

Main Operations

Create, Save and Close a Table and Specify Fields with Their Data Types
Add, Delete Records in a Table
Add a Field to an Existing Table
Add, Modify and Delete Data in a Record
Use the Undo Command
Navigate Within a Table to Other Records
Delete a Table

Define Keys

Define a Primary Key
Index a Field With, Without Duplicates Allowed

Table Design/Layout

Change Field Formats Attributes
Understand Consequences of Changing Field Size Attributes in a Table
Create a Simple Validation Rule
Change the Width of Columns in a Table
Move a Column Within a Table

Table Relationships

Create One-to-One, One-to-Many Relationships Between Tables
Delete Relationships Between Tables Apply Rule(s) to Relationships

Forms

Working With Forms

Open a Form
Create, Save and Close a Form
Use a Form to Enter, Modify, Delete Records
Navigate Within a Form
Add, Modify Text in Headers, Footers in a Form
Delete a Form

Retrieving Information

Main Operations

Use the Search Command
Apply and Remove a Filter to a Table, Form

Queries

Create, Save and Close a Single Table Enquiry
Add Criteria to a Query
Edit a Query by Adding, Removing Criteria
Edit a Query by Adding, Removing, Moving,
Hiding and Unhiding Fields
Run a Query
Delete a Query
Create, Save and Close a Two-Table Enquiry

Sort Records

Sort Data in a Table, Form and Query Output

Reports

Working with Reports

Create, Save and Close a Report Based on a Table, Query
Change Arrangement of Data Fields and Headings Within a Report Layout
Group Data Under a Specific Heading (field) in a Report
Present Specific Fields in a Grouped Report
Add, Modify Text in Headers and Footers in a Report
Delete a Report

Prepare Outputs

Prepare to Print

Preview a Table, Form, Report
Change Report Orientation and Paper Size

Print Options

Print a Page, Selected Record(s), Complete Table
Print All Records Using Form Layout, Specific Pages Using Form Layout
Print the Results of a Query
Print Specific Page(s) in a Report, Entire Report