Practical Evaluation
Microsoft Access 2000 - Module 1

MAC00ACCP1P

This entirely interactive practical evaluation was designed to evaluate your knowledge of this application. You will be able to determine, through a series of practical exercises, if you understand the essential concepts required to master this application.
 

Basic Knowledge of Microsoft Access 2000

Knowledge evaluated


 

1 - 2 hours
 
 

  1. The Access 2000 Screen
    Opening Access 2000
    Creating a Database
    Closing Access
    Opening Access
    Minimizing/Maximizing/Closing the Access Window
    The Access Menu Bar
    The Access Toolbars
    The Access Status Bar

  2. Creating a Table Using Access 2000
    Opening Access 2000
    Opening a Database
    Creating a Table in 'Design' View
    Creating a Field
    Defining a Field's Data Type
    Modifying the Value Size of a Field
    Field Descriptions
    Saving a Table in 'Design' View
    Viewing a Table in 'Datasheet' View
    Closing a Table

  3. Entering Data and Adding Fields
    Opening an Existing Table
    The 'AutoNumber' Data Type
    Moving Between Fields
    Adding Data to Table Fields
    Modifying a Table Structure
    Adding a Field
    The 'Date/Time' Data Type
    The 'Data Type' Selection List
    Viewing Changes to a Table Structure
    Entering Data in 'Datasheet' View

  4. Using Help in Access 2000
    The 'What's This?' Function
    The Office Assistant
    Deactivating the 'Office Assistant'
    The 'Microsoft Access Help' Dialog Box
    Showing the 'Office Assistant'
    Selecting Another 'Office Assistant'

  5. Input Masks
    Defining an Input Mask
    Opening a Table in 'Design' View
    Defining an Input Mask - Selecting a Field
    Field Properties
    The Input Mask Wizard
    Selecting an Input Mask
    Modifying an Input Mask
    Saving the Changes Made to a Table
    Creating a Custom Input Mask


  1. Selecting Data and Moving Around in a Table
    The Keyboard to Move Around
    The Mouse to Move Around
    Selecting Records
    Selecting a Column
    Selecting Multiple Cells
    Selecting an Entire Table
    The 'Record Navigator'

  2. Formatting Data
    Changing the Appearance of a Table
    Selecting a Font Type
    Viewing Changes
    Making Characters Bold
    Changing the Size of Characters
    Changing Cell Format Options
    Changing the Height of Table Rows
    Changing the Width of Table Columns
    Renaming a Column
    Previewing a Table Before Printing It

  3. Modifying Records
    Copying Data
    Moving Data
    Deleting Data
    Undoing an Action
    Magnifying the Contents of a Field
    Adding/Deleting Records
    Copying Multiple Records
    Deleting Multiple Records

  4. Modifying and Adding Fields
    Adding a Column to a Table
    Creating a 'Yes/No' Type Field
    Using a 'Yes/No' Type Field
    Hiding Columns
    Selecting Multiple Fields
    Viewing Hidden Fields in Table 'Design' View
    Redisplaying Hidden Fields
    Deleting a Field
    Adjusting a Column's Width

  5. Printing a Table Definition
    Displaying the 'Documenter' Dialogue Box
    The 'Print Table Definition' Dialog Box
    Obtaining a 'Print Preview' of a Definition
    Previewing Multiple Pages at Once
    Printing a Document

 

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 a practical evaluation is selected, a list of subject titles is displayed. When a title is clicked, the evaluation begins. The learner can obtain the definition of certain terms through the glossary at any time.

 

• 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

• Sound card, speakers or headphones
• 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.

• * If you use Windows XP, Internet Explorer 6 will only work if Java 1.4.0 or higher has been installed. In fact, due to a conflict between Sun and Microsoft, Microsoft excluded the JVM from it's distribution of Windows XP for Internet Explorer. In order to download and install the JVM, please consult the following site : http://www.eduperformance.com/download/jre.exe

 

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.