• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   User ECDL Training Courses

Access 97 Introduction (ECDL Module 5)

View course dates

Course Duration: 2 Days

Course Code: ECDLMI05

Course Description:

This course is designed for new users of Access 97, who have some PC and Windows experience, as well as people who may wish to prepare for the ECDL Module 5 Database test.

Prerequisites:

A knowledge of the Windows 95 environment is assumed. Delegates with no knowledge of Windows 95 should attend Windows 95 Introductory Level prior to this course.

Relevant Certifications:

European Computer Driving Licence® (ECDL)

This course includes the following modules:

Topics Covered

• Using the Office Assistant
• The Access 97 Environment
• Understanding the Database Concept
• The Access Screen Layout
• Using Menus and Toolbars
• Table Design
• Working with Tables
• Using the Table Wizard
• Switching Between Table Views
• Editing the Table Design
• Using the Undo Feature
• Entering and Editing Table Data
• Entering Data in the Datasheet
• Moving Around a Table
• Selecting Fields and Records
• Editing Table Data
• Using the AutoCorrect Feature
• Spell Checking Feature
• Changing the Table Appearance
• Searching For and Replacing Information
• Sorting and Filtering Data in a Table
• Importing Objects and Data into Tables
• Inserting an OLE Object
• Adding Records from Another Access Table
• Importing and Linking Data
• File Procedures
• Database File Operations
• Object File Operations
• Printing Database Objects
• Creating a Shortcut
• Queries
• Querying in Access 97
• Creating a Query
• Using Query Wizards
• Using Query Examples
• Calculated Fields
• Summary Calculations
• Using the Expression Builder
• Action Queries
• Joining Tables in Queries
• Forms
• Using, Creating and Viewing Forms
• Moving Around Form View
• Editing and Enhancing a Form
• Creating a Form with Multiple Pages or Tabs
• Using Filters
• Reports
• Using, Creating and Viewing Reports
• Editing and Enhancing Reports
• Creating Calculated Fields

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course