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
 
 

  1. What is a Database?
    Opening a Database
    Tables and Their Relationships
    'Design' View
    'Datasheet' View
    Forms
    Queries
    Reports
    Access Tools

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

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

  4. Data Entry
    Opening a Table
    Adding Data
    Inserting an Object
    Modifying the Table Structure
    Returning to 'Datasheet' View
    Returning to the 'Database' Window

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


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

  2. Modifying Records
    Cutting/Copying/Pasting Techniques
    Deleting a Selection
    Undoing an Action
    Viewing/Modifying Cell Contents
    Adding and Deleting Records
    Adding Records
    Deleting Records

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

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