Theoretical Evaluation
Microsoft Access 97 - Module 2

MAC97ACCP2T

This theoretical evaluation was designed to evaluate your knowledge of this application. You will be able to determine, through a series of multiple choice questions, if you understand the essential concepts required to master this application.
 

Basic Knowledge of Microsoft Access 97

Knowledge evaluated


 

15 minutes
 
 

  1. Spelling Corrector, Table Definitions
    The Spelling Corrector
    Correcting Spelling
    Printing a Table Definition
    The 'Documenter' Dialog Box
    Obtaining a Preview of a Definition
    The Page Matrix
    Printing a Table Definition

  2. Finding and Sorting Data
    Opening a Table
    Sorting Data
    Applying a Filter
    Replacing Data in a Field
    Deleting the Filter
    Finding Data in a Field
    Viewing the Modifications

  3. Creating Relationships Between Tables
    Setting a Primary Key
    Closing a Table
    Adding Tables to the 'Relationships' Window
    Moving Tables
    Types of Relationships
    Referential Integrity
    Deleting a Relationship

  4. Querying Access
    Creating a Query
    The Query 'Design' View Window
    Adding Fields to a Query
    Sorting Fields
    Running a Query
    Saving a Query
    Hiding/Showing a Field
    Removing a Field from a Query


  1. Using Expressions in Queries
    Opening a Query
    Including a Second Table in a Query
    Adding a Field to the Grid
    Running a New Query
    Adding Criteria
    Copying Criteria
    Using Wild Card Characters in a Query

  2. Structured Query Language
    The SELECT Statement and its Clauses
    Creating a New Query in SQL View
    Predicates in the SELECT Statement
    The WHERE Clause
    Sorting a Field Clause
    Other Clauses in the SELECT Statement
    Running and Comparing in Design View
    Saving a Query

  3. The Expression Builder
    Viewing a Report
    The 'Control Source' Property
    The Expression Builder
    The Expression Builder's 'Help' Button
    Building an Expression
    Validating an Expression
    Saving Modifications

 

Using any computer with Internet access, the learner enters his/her confidential ID and obtains a list of evaluations to which he/she is subscribed. Once an evaluation is selected, it begins with a series of multiple choice questions. At any time during the evaluation, the learner can obtain the definition of certain terms through the glossary. When the evaluation is complete, the result is immediately obtained.

 

• No installation required
• IBM PC compatible, Pentium 233 MHz minimum, 330 MHz and more strongly recommended.
• Video card that supports 800x600 or greater monitor resolution, and 16-bit color
• 32 MB RAM minimum, 96 MB and more strongly recommended.
• Microsoft compatible mouse
• Operating system: Windows 95, 98, 2000, NT 4.0, or more recent

• Netscape 4.7 or Internet Explorer 5.0 (or more recent)
• Internet connection: Modem 56 K minimum, high-speed connection is strongly recommended or network connection 10 Mbit minimum.

 

EDU-PERFORMANCE CANADA
7900 Taschereau Blvd. W.
Suite A-207
Brossard, Quebec J4X 1C2
Canada
Tel.: (450) 466-7275
Fax: (450) 466-4915
Toll free: 1-888-EDU-PERF
              1-888-338-7373
E-mail: info@eduperformance.com
Web site: www.eduperformance.com

EDU-PERFORMANCE EUROPE



International number: 1-450-466-7275
E-mail: infoepe@eduperformance.com
   

 

© 2006 Edu-Performance Canada Inc. All rights reserved. Duplication prohibited. All products and product names mentioned in this publication are trademarks or registered trademarks of their respective holders.