Practical Evaluation
Microsoft Access 97 - Module 3

MAC97ACCP3P

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 97

Knowledge evaluated


 

1 - 2 hours
 
 

  1. The Form Wizard
    Creating 'AutoForms'
    Saving a Form
    The 'Form Wizard'
    The 'New Form' Dialog Box
    Using the 'Form Wizard'

  2. Formatting Controls - 1
    Opening a Form
    Forms in 'Design' View
    Controls - Overview
    Control Elements
    Resizing and Moving Controls
    Modifiying the Properties of an Object

  3. Formatting Controls - 2
    Moving Controls
    Selecting Controls
    Enlarging Controls
    Moving Selected Controls
    Viewing a Form
    Formatting a Form
    Creating a New Control

  4. Entering Data in Form View
    Creating a Record
    Adding Data to the 'Category Name' Field
    Adding Data to the 'Description' Field
    Inserting and Printing an Image
    Adding a New Record to a Table
    Modifying Entries
    Deleting a Record
    Previewing and Printing

  5. Creating Reports with the Wizard
    Creating an Instant Report
    Selecting Tables for Reports
    Using the Report Wizard
    Grouping Fields
    Sorting Records Alphabetically
    Report Layouts
    Report Styles
    Previewing a Report


  1. Modifying and Printing a Report
    Modifying a Report in 'Design' View
    Previewing a Report
    Removing Controls in a Report
    Control Properties
    Modifying the Font
    Moving Controls in a Report
    Viewing the Modifications
    Printing a Report

  2. Creating and Modifying Charts
    Creating a New Report with the Chart Wizard
    Selecting Chart Fields
    Viewing the Layout for Chart Data
    Naming a Chart
    Saving a New Report
    Modifying a Chart
    Resizing Chart Objects
    Saving Modifications

  3. Creating and Modifying a Macro
    Creating a Macro
    The 'Open Form' Action
    The 'SendKeys' Action
    Saving a Macro
    Running a Macro
    Modifying a Macro
    The 'RunCommand' Action
    Saving Modifications

  4. Running Macros in a Form
    Creating a Command Button
    Choosing an Action
    Displaying Text on a Button
    Naming and Resizing a Button
    Using the Command Button
    Copying and Pasting a Command Button
    Modifying Button Properties
    Saving/Using the Command Button

  5. Access 97 and the Internet
    Creating a Hyperlink Field
    The 'Web' Toolbar
    Inserting a Hyperlink
    Opening the Web Site through its Link
    Adding a Web Site to the 'Favorites' Folder
    Using the 'Publish to the Web' Wizard
    Creating an HTML File

 

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.