RMD Business Access 2007 Foundation Syllabus
This course is designed for delegates who have little or no experience of
using Microsoft Access 2007.
If the course syllabus does not entirely match your requirements, please contact us
as we are able to customise it to your needs.
This course has a duration of 1 day.
Getting Started
Starting Out
What is Microsoft Access?
What's New in 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
The Trust Center
Warnings You May See when Opening a Database
Enabling Content
About Digital Signatures
About Trusted Locations
Opening the Trust Center
Assigning a Password to your Database
Getting Help
Opening the Help Screen
Overview of the Help Screen
Online Help vs. Offline Help
Searching for Help
The New Interface
The Quick Access Toolbar
About the Default Buttons
Adding Buttons
Removing Buttons
Customising the Toolbar
Basics of Ribbons
About Ribbons
Opening Dialogue Boxes from the Ribbon
About the Office Menu
The Home Ribbon
Views
Clipboard
Font
Rich Text
Records
Sort and Filter
Find
Create Ribbon
Tables
Forms
Reports
Other
External Data Ribbon
Import
Export
Collect and Data
SharePoint Lists
Database Tools Ribbon
Macro
Show/Hide
Analyze
Move Data
Database Tools
Creating a Database
First Steps
Planning a Database
Creating a Database from a Template
Creating a Blank Database
Using Database Objects
Setting Navigation Options
About Records
What is a Record?
Navigation Tips
Adding Records
Editing Records
Deleting Records
E-Mailing Records
Printing Records
Creating a Table
About Tables
Creating a Table
Entering Data into a Table
Formatting a Table
Formatting Text
Using the Zoom Box
Selecting Data
Cutting, Copying and Pasting
Using the Format Painter
Using Undo and Redo
Checking your Spelling
Doing More with your Database
Creating Forms
What is a Form?
Bound vs. Unbound Controls
Creating a Form with the Wizard
Using Design View to Modify Your Form
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
Using Design View to Modify a Report
Using Reports
Sorting and Filtering Data
Using Find and Replace
Sort Ascending or Descending
Toggling Filter
Using Selection Sort
Using Advanced Sort
Viewing Data
Using the View Menu
Using the View Icons
Using the Tabs
Closing Individual Tabs
Printing a Database Object
Using the Quick Print Icon
Using the Print Menu
Using Print Preview
Using the Print Preview Ribbon
Printing vs. Exporting
