Database Terminology
What is a Table?
What is a Record?
What is a Form?
What is a Report?
What is a Query?
Lesson 1.2
Meeting Access
Starting Access
The Microsoft Access
Environment
Working with Toolbars
Working with the Task Pane
Lesson 1.3
Creating A Database
Plan Your Database
Creating a New Database Using
the Wizard
The Database Window
The Relationship Window
Understanding the Join Lines
Practice
Exercise
Lesson 1.4
Creating Tables
About Referential Integrity
Viewing Tables and Entering
Data
Viewing Table Properties
Lesson 1.5
Creating Forms
Previewing a Form's Design
Previewing Reports
Previewing a Report's Design
SECTION 2:
Tables
Lesson 2.1
Table Basics
Table Structures
Primary Key Field
Changing Field Properties
Lesson 2.2
Creating A Table
Creating a Table Using the
Wizard
Creating a Table Using
NewObject:Table
Creating a Table in Design
View
About Table and Field Names
Lesson 2.3
Working With a Table
Editing a Table
Changing Table and Field Names
Deleting Fields
Lesson 2.4
Finishing A Table
Saving a Table
Editing a Table in Design View
Changing a Table Structure
Entering Table Data
Importing Data from Excel
SECTION 3:
Forms
Lesson 3.1
Creating a Form
Creating a Form Using
NewObject
Creating a Form Using the
Wizard
Creating a Form in Design View
Lesson 3.2
Modifying a Form
Designate the Record Source
Place the Fields
Move and Place Controls
Delete Controls
Lesson 3.3
Using Controls
Use the Toolbox
Format Controls
Changing Formatting Using the
Format Painter
Using the Navigation Bar to Move Through Your Form
Viewing Your Work
SECTION 4:
Reports and Queries
Lesson 4.1
Creating a Report
Create a Report Using
NewObject:Report
Create a Report Using the
Wizard
Create a Report in Design View
Grouping and Sorting
Lesson 4.2
Using
Bound Controls
Unbound Controls
Option Buttons
Toolbox
Control Properties
Lesson 4.3
Finishing a Report
Report Sections
Add a Report Header or Footer
Sort and Group
Previewing Your Report
Lesson 4.4
Queries
Working with Queries
Manipulate Tables in the Query
Window
c"section4/lesson4.4c.htm">-->Arrange the Design Window
About the Design Grid
Multi-Table Queries
About Calculated Fields
