| 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
|
|
 |
|
-
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
-
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
-
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
-
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
|
-
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
-
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
-
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.
|