Chapter 1 - Planning and Designing Databases
Chapter 2 - Working with Access
Chapter 3 - Working with Records
Chapter 4 - Working with Tables
Chapter 5 - Working with Forms
ViaLab Exercises
Chapter 1 - Planning and Designing Databases
 Why use a Database?
Steps for Planning
Planning a Database
Determining Table Structure
Determining Table Relationships
Chapter 2 - Working with Access
Overview of Access Window
Selecting an Object
Creating a Database
Creating a Blank Database
Chapter 3 - Working with Records
Navigating Tables and Records
Using a Switchboard
Entering Records using a Data Sheet
Using a Form
Finding a Record
Apply and Remove Filters
Sorting Records
Deleting Records from a Table
Chapter 4 - Working with Tables
Using the Table Wizard
Switching between Object Views
Using Multiple Data Types
Modifying Field Properties
Input Mask Wizard
Lookup Wizard
Setting Primary Keys
Chapter 5 - Working with Forms
Using the Form Wizard
Form Views and Sections
Using Controls
Formatting Properties
Inserting Graphics
ViaLab Exercises
Open a New Database
Sorting a Table
Setting Primary Keys
Create a Form
Editing Controls
|
|
