2 - day course
Print this page
Course Code: D1N1Ben
Who should attend?
This course is intended for new users of Access 2000 - 2003.
Prerequisites
Windows 95, Windows 98, Windows NT 4.0, or Windows 2000
Course Objectives
Upon completion of the course, participants will be able to accomplish the following:
  • Identify the components of a database, and work with those components
  • Open a table, find information stored there, and enter data
  • Create a table design from a template, and customize it
  • Enter data into tables, and ensure its accuracy by using input masks and input validation formulas
  • Create relationships between tables to ensure data accuracy and to deploy referential integrity
  • Create forms for entering data into tables, and change the design elements that have been placed on those forms
  • Create several query types, edit and run queries, and use action and calculation queries
  • Create several report types, enhance reports, and print and preview reports
  • Import and export data to and from various sources, including Word and Excel
  • Preview and print database objects, and change the page setup options
Course Content  
    The Basics
    Database Concepts ; Getting Started ; Creating a Database ; Converting Access Files ; Working with Objects ;
    Table Data
    Table Concepts ; Viewing Data in a Table ; Changing the Datasheet Appearance ; Entering and Editing Data ; Applying Filters ;
    Table Design
    The Table Wizard ; Changing the Table Design ; Creating a Table in Design View ;
    Data Entry
    Data Entry Concepts ; Data Formats ; Input Masks ; Input Validation ; Adding Records ;
    Relationships
    Relationships Between Tables ; Creating a Relationship ; Referential Integrity ; Removing a Relationship ; Printing Relationships ;
    Creating and Using Forms
    Creating a Form Using AutoForm ; Creating a Form Using the Form Wizard ; Creating a Form in Design View ; Opening a Form ; Changing a Form Design ; Adding Controls ; Placing Controls ; Multiple-Choice Controls ; Error Checking ;
    Queries
    Using the Query Wizard ; Creating a Query in Design View ; Selecting and Sorting in a Query ; Calculations ; Action Queries ; Parameter Queries ;
    Reports
    Creating Reports ; Using the Report Wizard ; Previewing Reports ; Creating Reports in Design View ; Changing Report Design ; Control Operations ; Control Attributes ;
    Importing and Exporting Data
    Importing and Exporting ; Importing a Text File ; Importing Data from an Access Database ; Exporting Data ; Exporting Data Using Office Links ; Troubleshooting Importing and Exporting Problems ;
    Printing
    Printing Objects ; Page Setup Options ;