View ECDL/ICDL Site

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

• Microsoft Access 2002 Foundation Courseware materials
• Microsoft Access 2002 Intermediate Courseware materials
• Microsoft Access 2002 Advanced Courseware materials
• Microsoft Excel 2002 Foundation Courseware materials
• Microsoft Excel 2002 Intermediate Courseware materials
• Microsoft Excel 2002 Advanced Courseware materials
• Microsoft FrontPage 2002 Foundation Courseware materials
• Microsoft FrontPage 2002 Intermediate Courseware materials
• Microsoft Outlook 2002 Foundation Courseware materials
• Microsoft PowerPoint 2002 Foundation Courseware materials
• Microsoft PowerPoint 2002 Intermediate Courseware materials
• Microsoft Project 2002 Foundation Courseware materials
• Microsoft Publisher 2002 Foundation Courseware materials
• Microsoft Publisher 2002 Intermediate Courseware materials
• Microsoft Visio 2002 Foundation Courseware materials
• Microsoft Word 2002 Foundation Courseware materials
• Microsoft Word 2002 Intermediate Courseware materials
• Microsoft Word 2002 Advanced Courseware materials