Access 2003 Courseware Materials for IT Trainers
Foundation Level Training Materials
Courseware Training Manual
INTRODUCTION TO MICROSOFT ACCESS 2003
- Creating a new database file
- Opening and closing a database file
- Understanding new Access 2003 security features
- Understanding Access 2003 Security Levels
- Closing a database file
ACCESS 2003 INTERFACE
- Using the menu bar
- Using the Database toolbar
- Using the task pane
- Using the Status bar
- Using the Office Assistant
- Customising the toolbars
THE DATABASE TOOLBAR
- Using the Database Toolbar
- Using the New button
- Using the Open button
- Using the Save button
- Using the File 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 Office Access Help button
THE TASK PANE
- Viewing and opening recent files
- Opening the New File task pane
- Data Access Page option
- Using the Project using existing data option
- Using the Project using new data option
- Using the From existing file option
- Using the Template area of the New File Task Pane
- Using the Templates option
- Using the Templates On Office Online option
- Using the Clipboard Task Pane
- Opening the Clipboard task pane
- Using the Office Clipboard feature
- Using the File Search Task Pane
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
- 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
TABLES
- Creating a Table
- Creating a Table in Design View
- Using the Table Wizard to create a table
- Using the property updates feature
- Working with Tables
- Changing a table design
- Adding records
- Finding Records
- Editing records
- Filtering records
- Sorting records
QUERIES
- Requirements for a query in Design view
- Creating a new query in Design view
- Creating a numerical query using the wizard
- Creating a non-numerical query using the wizard
- Saving queries
- Opening an existing query’s result window
- Opening an existing query in Design view
- Refining the results of a query
- Adding calculations in Design view
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 organise information effectively
- Displaying and Linking Images
- Inserting the same background image for all records
- Inserting an image which does not change from record to record
- Inserting an image which is particular just to one record
- Replacing an image
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
- 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