This 1-day Microsoft Access 2002 Foundation training course is delivered
onsite and off-site in
Aberdeen,
London,
Edinburgh,
Manchester,
Dundee,
Glasgow,
Stirling,
Birmingham and at locations across the UK.
This course includes the following topics:
1).
INTRODUCTION TO MICROSOFT ACCESS 2002
WHAT IS
ACCESS?
Access 2002
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
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
