Dale Rainwater Consulting
Microsoft Access 97

Home Services Experience Certifications Skills Training About Us Contact Information Site Map

 

Description

Microsoft Access 97 is a relational database management program included with Microsoft Office 97.  The Microsoft Access 97 Microsoft Office Specialist certificate validates a consultant's skills in using Microsoft Access 97.  As a qualitative assessment of a consultant's abilities, the Microsoft Office Specialist program offers clients' confidence while choosing a consultant.

The Microsoft Office Specialist Access 97 exam contents and objectives are provided below.  In addition to meeting the Microsoft Office Specialist Access 97 certification requirements, Dale Rainwater holds a Microsoft Office Specialist certification in Microsoft Access 2002 and Microsoft Access 2000.  

The Access 97 Microsoft Office Specialist exam evaluates a candidates skills using an Access 97 database's tables, forms, queries, reports, and other objects.

Dale Rainwater Consulting offers computing services in New York City, NY and Northwest Arkansas.

Exam Contents / Objectives

Microsoft Access 97

 
Creating a Database
bulletPlan a database
bulletCreate a table
bulletEnter data into a table
bulletModify data in a table
bulletEnter data into a form
bulletNavigate through a table
bulletDelete data from a table
Using Forms
bulletCreate a simple form
bulletModify a form
bulletCreate controls on a form
bulletModify controls
bulletAdd a record using a form
bulletShow related records on a form
Modifying a Database
bulletOpen a database
bulletModify field properties
bulletModify field layout
bulletModify the presentation of a database
Viewing Information
bulletPresent information in a chart
bulletView information in a form
bulletView multiple records
bulletSwitch between views
Organizing Information
bulletSort data on single fields
bulletSort data on multiple fields
Locating Information
bulletFind a specific record
bulletCreate a simple query
bulletCreate a query with multiple criteria
bulletAdd filters (selection and form)
bulletRemove filters
Refining Results of a Query
bulletAdd fields to a query
bulletRemove fields from a query
bulletSort a query
bulletJoin tables in a query
bulletRemove joins in a query
bulletSave a query
Analyzing Data
bulletBuild summary queries
bulletCalculate fields
bulletSet cross-tab queries
Creating Sub Forms
bulletIdentify appropriate use for sub forms
bulletAdd a record with a main form
bulletAdd records with sub forms
bulletMerge two tables into a form
Building a Relational Database
bulletIdentify relationships
bulletRelate tables
Integrating Information from Other Applications
bulletImport data
bulletLink data
bulletAdd pictures to records
Utilizing Web Capability
bulletCreate hyperlinks
bulletBuild order forms for Internet use
Maintaining Data Integrity
bulletIdentify criteria for data integrity
bulletValidate text
bulletSet required properties
bulletSet validation rules
bulletSet look up fields
bulletUse expressions in calculated controls
Building a Form for Other Users
bulletTitle a form
bulletModify form design
bulletImprove accuracy in forms
bulletEnhance design of a form
Producing Reports
bulletCreate a report
bulletModify a report
bulletLabel a report
bulletCustomize headers and footers
bulletMake a calculation on a report
bulletGroup data in a report
bulletSort data in a report
bulletAdd custom pages
Printing
bulletPrint a report
bulletPrint a form
bulletPrint the result of a query

 

Home ] Services ] Experience ] Certifications ] Skills ] Training ] About Us ] Contact Information ] Site Map ]