Microsoft Access 2002 Foundation course outline

Microsoft Access 2002 Foundation
Training Course Outline

1-day course

This course includes the following topics:

1). INTRODUCTION TO MICROSOFT ACCESS 2002

WHAT IS ACCESS?
Access 2002
Content
Delivery

CREATING FILES
About Access 2002 Files
Creating a new database file

OPENING AND CLOSING A DATABASE FILE
Opening a database file
Closing a database file

ACCESS 2002 INTERFACE

ACCESS 2002 WORKSPACE
Using the Menu bar
Using the Database toolbar
Using the Task Pane
Using the Status bar
Using the Office Assistant
Customizing the toolbars

2). THE DATABASE TOOLBAR

USING THE DATABASE TOOLBAR
Using the New button
Using the Open button
Using the Save button
Using the Search button
Using the Print button
Using the Print Preview button
Using the Spelling button
Using the Cut button
Using the Copy button
Using the Paste button
Using the Undo button
Using the OfficeLinks button
Using the Analyse button
Using the Code button
Using the Microsoft Script Editor button
Using the Properties button
Using the Relationships button
Using the New Object: <Object Type> button
Using the Microsoft Access Help button

3). THE TASK PANE

USING THE OPEN A FILE AREA OF THE NEW FILE TASK PANE
Opening the New File task pane
Viewing and opening recent files

USING THE NEW AREA OF THE NEW FILE TASK PANE
Using the Blank Database option
Using the Blank Data Access Page option
Using the Project (Existing Data) option
Using the Project (New Data) option

USING THE NEW FROM EXISTING FILE AREA OF THE NEW FILE TASK PANE
Using the Choose File option

USING THE NEW FROM TEMPLATE AREA OF THE NEW FILE TASK PANE
Using the General Templates option
Using the Templates On Microsoft.com option

USING THE CLIPBOARD TASK PANE
About the Office Clipboard feature
Opening the Clipboard task pane
Using the Office Clipboard feature

USING THE SEARCH TASK PANES
About the Search feature
Opening the Search task pane
Using the Search feature

4). THE DATABASE WINDOW

THE DATABASE MENU BAR
Using the Database Menu Bar
Using the Open button
Using the Design button
Using the New button
Using the Delete button
Using the Icon buttons
Using the List button
Using the Details button

THE DATABASE WINDOW TOOLBAR
About the Groups feature
Using Groups in the Toolbar
Using the Favorites button
Using the Tables button
Using the Queries button
Using the Forms button
Using the Reports button
Using the Pages button
Using the Macros button
Using the Modules button

5). TABLES

CREATE A TABLE
About creating a table in Design view
Creating a Table in Design View
About using the Table Wizard to create a table
Using the Table Wizard to create a table

WORKING WITH TABLES
About changing a table design
Changing a table design
Adding records
Finding Records
Editing records
About filtering records
Filtering records
About sorting records
Sorting records

6). QUERIES

CREATE A QUERY
About queries
About creating a new query in Design view
Requirements for a query in Design view
Creating a new query in Design view
About creating a new query using a wizard
Creating a numerical query using the wizard
Creating a non-numerical query using the wizard
Saving queries
Opening an existing query’s result window
Open an existing query in Design view
Refining the results of a query
About adding calculations to a query in Design view
Adding calculations in Design view

7). FORMS

USING AND CREATING FORMS
Using Forms
Creating forms with the wizard
Creating a simple form from scratch in Design view
Modifying a form in Design view
Using a form to locate information
Using a form to organize information effectively

DISPLAYING AND LINKING IMAGES
About inserting images
Inserting the same background image for all records
Inserting an image that does not change from record to record
Inserting an image that is particular just to one record
Replacing an image

8). REPORTS

CREATING AND USING REPORTS
Using Reports
Creating a report using AutoReport
Creating a report using a wizard
Creating a report from scratch in Design view
About totals or averages in a report
Creating a report with totals or averages

SAVING, MAINTAINING, AND PRINTING REPORTS
Saving a report
Setting report properties
Previewing a report (before you print it)
Printing a report

For further details, or to book a course, please contact us:
email: training@ictwizard.com
telephone: 01382 453447

Our Access courses include:

Microsoft Access 2007 Foundation

Microsoft Access 2007 Intermediate

Microsoft Access 2007 Advanced

Microsoft Access 2003 Foundation

Microsoft Access 2003 Intermediate

Microsoft Access 2003 Advanced

Access VBA

ICT Wizard courses: