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

 

Call Now Button