COURSE DESCRIPTION FOR
MICROSOFT ACCESS - INTRODUCTION
This class description basically covers all versions of Access.
To request the class description and system requirements for your version
of Access,
send e-mail to the Office Wiz
This class is a must for any self-employed or business person. Learn to
create, maintain and manage databases. Databases help you track inventory,
personnel and other business resources. Discover how to design and create
a database as well as tables, queries and forms. You will also see how to
produce polished reports. The class is instructor-led with hands-on activities.
Learn to:
- Understand database concepts and terminology.
- Design and create tables.
- Enter and manipulate data in tables.
- Use 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.
LENGTH
Approximately eight hours. Recommend two four hour sessions.
PREREQUISITES
No knowledge of Access is required, however, you must have
a good understanding of basic Microsoft Windows, file management and personal
computers.
SPECIFIC CLASS CONTENT
Lesson 1: Overview of Access
Introduction to database concepts and terminology
An introduction to Access
Database planning and design
Lesson 2: Creating tables
Examining a table
Creating a table with the Table Wizard
Creating a table in Design View
Types of primary keys
Lesson 3: Working with tables
Adding records
Modifying the table design
Finding and editing records
Deleting, adding, and copying records and values
Filtering and sorting records
Lesson 4: Using select queries
Selecting fields and sorting records
Refining the results of a query
Using queries to perform calculations
Joining tables in a query
Lesson 5: Creating and using forms
Creating a form
Modifying the form design
Using a form to locate and organize information
Multiple-table forms
Lesson 6: Creating and using reports
Creating a report
Creating a report that contains totals
Lesson 7: Creating and maintaining a database
Creating a database
Managing a database and its objects
Database maintenance
NECESSARY SOFTWARE AND HARDWARE
- A 486/66-compatible PC that meets minimum hardware requirements
for Windows 95 or later or Windows NT 4.0 or later. A Pentium 90 MHz processor
with 32 MB RAM or better is recommended. The minimum memory requirement
is 16 MB RAM.
- Windows 95, 98 or Windows NT 4.0 with Service Pack 3
(or higher) installed.
- Microsoft mouse or compatible pointing device.
- A printer (optional). You must have an installed printer
driver to use Print Preview.
WHAT'S NEXT?
- Access - Level 2. Enhance
database designs by using the principles of normalization and table relationships.
Also learn how to query multiple tables for data that is used in customized
forms and reports.
- Access - Advanced. Create
advanced queries, work with macros, and design forms and reports.
- Mini Power Sessions:
--Analyze Your Product And Sales Data Using Access
--Create And Normalize A Database From Excel Using Access
--Customize Your Reports Using Access
--Manage, Plan And Analyze Your Inventory Using Access
--Produce Letters, Lists And Catalogues Using Access And Word
| 