| Theoretical Evaluation
Microsoft Access 97 - Module 1
MAC97ACCP1T |
 |
 |
|
  |
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
|
|
 |
|
-
What is a Database?
Opening a Database
Tables and Their Relationships
'Design' View
'Datasheet' View
Forms
Queries
Reports
Access Tools
-
Discovering the Access 97 Screen
Opening Access
Creating a Database
Closing Access
Opening Access in Windows
Minimizing/Maximizing/Closing Access
The Access Menu Bar
The Access Toolbar
The Access Status Bar
-
Creating a Table
Creating a Table in 'Design' View
Naming a Field
Selecting a Data Type for a Field
Adding a Description for a Field
Setting Up Additional Fields
The 'OLE Object' Data Type
Saving a Table
-
Data Entry
Opening a Table
Adding Data
Inserting an Object
Modifying the Table Structure
Returning to 'Datasheet' View
Returning to the 'Database' Window
-
Moving and Selecting Objects in a Table
Keyboard Navigation
Mouse Navigation
Selecting a Record
Selecting a Column
Selecting Cells
Selecting an Entire Table
The Record Navigator
|
-
Formatting Data
Changing Character Format Settings
Changing the Font Type and Style
Changing the Font Color
Modifying the Cell Format
Resizing Cells - Row Height
Resizing Cells - Column Width
Renaming a Column
Previewing and Printing a Table
-
Modifying Records
Cutting/Copying/Pasting Techniques
Deleting a Selection
Undoing an Action
Viewing/Modifying Cell Contents
Adding and Deleting Records
Adding Records
Deleting Records
-
Modifying Fields
Adding a Field
Creating a 'Yes/No' Type Field
A 'Yes/No' Field
Hiding Columns
Redisplaying Columns
Deleting Columns
Zooming In on a Field Name
-
Using Help in Access 97
The Help Menu
The 'Microsoft Access Help' Dialog Box
The Index Tab
Printing a Help Topic
The 'Find' Tab Menu
Conducting a Search with the Office Assistant
Obtaining Further Details in a 'Help' Window
|
 |
|
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.
|