Lesson 1 - Exploring Access
Working with Access
Starting Access
Using the Interface
Opening an Existing Database
Using Menu Commands
Displaying and Hiding Toolbars
Moving and Resizing Toolbars
Changing Menu and Toolbar Options
Using Database Objects
Using the Database Window
Opening a Database Object
Using the Task Pane
Using the Options Dialog Box
Exiting Access
Lesson 2 - Creating Tables
Creating a New Database
Designing Tables
Creating a Table in Design View
Using Design View
Adding Field Names
Assigning Data Types
Adding a Field Description
Setting a Primary Key
Saving a New Table
Using the Table Wizard
Using the Database Wizard
Workshop Information Page |
Lesson 3 - Working with Tables
Using Datasheet View
Navigating Fields in Tables
Adding Records
Moving through Records
Selecting Records
Editing Records
Saving Records
Deleting Records
Lesson 4 - Editing Tables
Changing Row Height
Changing Column Width
Changing a Font Attribute
Changing a Cell Effect
Selecting a Column
Moving a Column
Hiding a Column
Unhiding a Column
Freezing a Column |
