Practical Evaluation
Microsoft Access 2000 - Module 3

MAC00ACCP3P

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 'Form Wizard'
    Creating an 'AutoForm'
    The 'Columnar' Form
    Saving a Form
    The 'Form Wizard'
    The 'New Form' Dialog Box
    Answering the Form Wizard's Questions
    Selecting the Fields for a Form
    Selecting a Layout
    Naming a Form

  2. Formatting Controls - 1
    Opening a Form in 'Form' View
    Sections on a Form
    Becoming Familiar with Controls
    Selecting a Control
    Moving Objects
    Resizing a Control
    Moving a Control
    Controls - Multiple Selection
    Modifying a Label
    Viewing a Form

  3. Formatting Controls - 2
    Adding a Title to a Form
    The 'Label' Tool
    Formatting a Form
    Adding a Control
    Creating a Combo Box
    The 'Combo Box Wizard'
    Modifying the Appearance of Labels/Text Boxes
    Modifying the Properties of an Object
    Viewing a Form

  4. Adding/Deleting Records on Forms
    Creating a Record
    Inserting Data into a Form
    The 'Combo Box'
    Adding a New Record to a Table
    Deleting a Record
    Displaying a Print Preview/Printing a Form


  1. Using the Wizard to Create Reports
    Creating an Instant Report
    Selecting Tables for Reports
    The 'Report Wizard'
    Adding Table Fields to a Report
    Grouping Fields
    Selecting a Sort Order for Records
    Defining the Report Layout
    Report Styles
    Viewing a Report

  2. Modifying and Printing Reports
    Opening a Report for Editing
    Previewing a Report
    Deleting Controls on a Report
    Formatting Report Text
    Moving Controls on a Report
    Viewing Changes to a Report
    Printing a Report

  3. Access 2000 and the Internet
    Creating a 'Hyperlink' Type Field
    The 'Web' Toolbar
    Inserting a Hyperlink
    Accessing a Web Site
    Adding an Internet Address to the 'Favorites' Folder

  4. 'Office on the Web' Help
    Accessing the Microsoft Access Web Site
    Access 2000 - FAQ
    The 'Downloads' Page
    The 'Assistance' Page
    Access Articles

 

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.