| MICROSOFT ACCESS 2007 INTRODUCTION – 1 DAY COURSE
Module 1: Getting Started in Microsoft Access 2007
Basic Terminology
Opening Microsoft Access
Interface Overview
Closing Microsoft Access
Using the Getting Started Window
Overview of the Window
Navigating Through the Window
Creating a Database from a Template
Creating a Blank Database
Getting Help
Module 2: The New Interface in Microsoft Access 2007
Using the Quick Access Toolbar
About the Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
About Ribbons
Opening Dialog Boxes from the Ribbon
About the Office Button
Module 3: Creating a Database in Microsoft Access 2007
Planning a Database
Creating a Database from a Template
Creating a Blank Database
Using Database Objects
Setting Navigation Options
Creating a Table
Entering Data into a Table
Formatting a Table
Formatting Text
Using the Zoom Box
Selecting Data
Cutting, Copying, and Pasting
Adding Records
Editing Records
Deleting Records
E-Mailing Records
Printing Records
Using the Format Painter
Using Undo and Redo
Checking your Spelling
Module 4: Sorting and Filtering Data in Microsoft Access 2007
Using Find and Replace
Sort Ascending or Descending
Using Selection Sort
Using Advanced Sort
Module 5: Creating Forms in Microsoft Access 2007
What is a Form?
Creating a Form with the Wizard
Using Design View to Modify Your Form
Using Forms
Module 6: Creating Queries in Microsoft Access 2007
What is a Query?
Creating a Query with the Wizard
Using Design View to Modify a Query
Using Queries
Module 7: Reports in Microsoft Access 2007
What is a Report?
Creating a Report with the Wizard
Using Design View to Modify a Report
Using Reports
Module 8: Viewing Data in Microsoft Access 2007
Using the View Menu
Using the View Icons
Using the Tabs
Closing Individual Tabs
Module 9: Printing a Database Object in Microsoft Access 2007
Using the Quick Print Icon
Using the Print Menu
Using Print Preview
Using the Print Preview Ribbon
Printing vs. Exporting |