Starting Out:
• Basic Terminology
• Opening Microsoft Access
• Interface Overview
• Closing Microsoft Access
Using the Access Interface:
• UsingThe Access Menus
• Access Task Panes
• Using Toolbars
• Adding, Removing, and Moving Toolbars
• The Switchboard
• Using the Database Window
Getting Help:
• The Help Menu
• The Help Task Pane
• The Office Assistant
• Using the Type a Question Box
• Getting Help in a Dialog Box
• Using the Sample Databases
First Steps:
• Planning a Database
• Creating a Blank Database
• Database Objects
Records:
• What is a Record?
• Adding Records
• Editing Records
• Deleting Records
• Printing Records
Creating a Table:
• About Tables
• Creating a Table in Design View
• Creating a Table using the Wizard
• Entering Data into a Table
• Formatting a Table
Formatting Text:
• The Zoom Toolbar
• Selecting Data
• Cutting, Copying, and Pasting
• The Format Painter
• Undo and Redo
• Checking your Spelling
Formatting Controls:
• Changing the Colour of a Control
• Control Properties
• Aligning Controls
• Applying Special Effects
|
Creating Forms:
• What is a Form?
• Bound vs. Unbound Controls
• Creating a Form with the Wizard
• Creating a Form in Design View
• Using Forms
Creating Queries:
• What is a Query?
• Creating a Query with the Wizard
• Using Design View to Modify a Query
• Using Queries
Reports:
• What is a Report?
• Creating a Report with the Wizard
• Creating a Report in Design View
• Using Reports
Sorting and Filtering Data:
• Using Find and Replace
• Sort Ascending or Descending
• Using Filter by Form
• Using Filter by Selection
• Creating a Filter
Formatting a Datasheet:
• Adjusting Row Height and Column Width
• Rearranging Columns
• Freezing a Row or Column
• Hiding a Column
• Changing the Datasheet Font
Viewing Data:
• The View Menu
• The Window Menu
• Hiding and Unhiding Windows
• Arranging Windows
• Closing Individual Windows
Printing a Database Object:
• The Print Icon
• Print Preview
• Page Setup |