Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print PageAccess 2007 Foundation
Description:
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2007 relational database application.
- Cost: Price on application
- Duration: 1 Day
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Participants should have completed an Introduction to Windows 2000/XP/Vista or possess equivalent knowledge before starting this course.
Starting Out :
What is Microsoft Access?
What’s New in Access 2007?
Basic Terminology
Opening Microsoft Access
Interface Overview
Closing 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
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
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
Overview of the Help Screen
Online Help vs. Offline Help
Searching for Help
Using the Quick AccessToolbar :
About the Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
Adding Buttons
Removing Buttons
Customizing the Toolbar
Basics of Ribbons :
About Ribbons
Opening Dialogue Boxes from the Ribbon
About the Office Menu
Opening Dialogue Boxes from the Ribbon
About the Office Menu
The Home Ribbon :
Views
Clipboard
Font
Rich Text
Records
Sort and Filter
Find
Clipboard
Font
Rich Text
Records
Sort and Filter
Find
Create Ribbon :
Tables
Forms
Reports
Other
Forms
Reports
Other
External Data Ribbon :
Import
Export
Collect and Data
SharePoint Lists
Export
Collect and Data
SharePoint Lists
Database Tools Ribbon :
Macro
Show/Hide
Analyze
Move Data
Database Tools
Show/Hide
Analyze
Move Data
Database Tools
First Steps :
Planning a Database
Creating a Database from a Template
Creating a Blank Database
Using Database Objects
Setting Navigation Options
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
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
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
Selecting Data
Cutting, Copying, and Pasting
Using the Format Painter
Using Undo and Redo
Checking your Spelling
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
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
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
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
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
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
Using the Print Menu
Using Print Preview
Using the Print Preview Ribbon
Printing vs. Exporting