|
SEO
training seminars, Perth, WA
|
Microsoft Access XP 2002 Course
Foundation Level Courseware Training Materials
Training Course Outline
 1. INTRODUCTION TO MICROSOFT ACCESS 2002
- Access 2002
- Content
- Delivery
- About Access 2002 Files
- Creating a new database file
- Opening a database file
- Closing a database file
- 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 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 Analyze 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
- Opening the New File task pane
- Viewing and opening recent files
- 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 Choose File option
- Using the General Templates option
- Using the Templates On Microsoft.com option
- About the Office Clipboard feature
- Opening the Clipboard task pane
- Using the Office Clipboard feature
- 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
- 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
- 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
- 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 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
- 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
- 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 a report
- Setting report properties
- Previewing a report (before you print it)
- Printing a report
Other Microsoft Office 2002 Courseware materials
|
|
Customisable
Courseware