This course is provided by Wintrac.
Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on
Desktop Application Software training,
E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview
Students will learn the basic skills necessary to begin using Access 97. Students learn how to create and use database objects, including tables, queries, forms, and reports.
Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with terms such as computer memory, data files, and program files. Students should also be familiar with the components that make up the PC, including input, output, and storage devices.
Students should also be familiar with Windows 95, and be fairly comfortable working in a Windows environment. No prior knowledge of databases or Access is assumed.
Prerequisites
To ensure students' success with this course, we recommend that they first take the following course or have equivalent knowledge.:
Performance-Based Objectives
- Understand database concepts and terminology in Access 97.
- Design and create tables.
- Enter and manipulate data in tables.
- Use Access queries to select and analyze information in a table.
- Create data forms for viewing and inputting data.
- Create reports that summarize and group data.
- Perform database maintenance procedures.
Delivery Method:
This course is designed for instructor-led, group paced classroom-delivery, providing students with structured hands-on activities.
Course duration
1 Day(s)
Course outline
Lesson 1: Overview of Access 97
- Topic 1A: Introduction to database concepts and terminology
- Topic 1B: An introduction to Access 97
- Topic 1C: Database planning and design
Lesson 2: Creating tables
- Topic 2A: Examining a table
- Topic 2B: Creating a table with the Table Wizard
- Topic 2C: Creating a table in Design View
- Topic 2D: Types of primary keys
Lesson 3: Working with tables
- Topic 3A: Adding records
- Topic 3B: Modifying the table design
- Topic 3C: Finding and editing records
- Topic 3D: Deleting, adding, and copying records and values
- Topic 3E: Filtering and sorting records
Lesson 4: Using select queries
- Topic 4A: Selecting fields and sorting records
- Topic 4B: Refining the results of a query
- Topic 4C: Using queries to perform calculations
- Topic 4D: Joining tables in a query
Lesson 5: Creating and using forms
- Topic 5A: Creating a form
- Topic 5B: Modifying the form design
- Topic 5C: Using a form to locate and organize information
- Topic 5D: Multiple-table forms
Lesson 6: Creating and using reports
- Topic 6A: Creating a report
- Topic 6B: Creating a report that contains totals
Lesson 7: Database maintenance
- Topic 7A: Creating a database
- Topic 7B: Copying objects
- Topic 7C: Using Windows Explorer
- Topic 7D: Compacting a database
Hardware/Software Requirements
You will need:
- 12 megabytes (MB) of Random Access Memory (RAM).
- 55 MB of available hard-disk space to install Access and to copy the data
files from the student data disk.
- An IBM-compatible PC with an 80486SX or higher processor.
- Microsoft Windows 95.
- Microsoft Office 97.
- A VGA or higher display adapter (the EGA display adapter is not supported).
- A two-button mouse or IntelliMouse.
- A floppy-disk drive.
- Printers are not required although you will need an installed printer driver.
