Access 2000: Level 1
Course Specifications
Course number: 076400
Course length: 1 day
Software: Access 2000 9.0
Certification: Microsoft Office Specialist
Course Description
Access 2000: Level
1 is a hands-on instruction book that
will introduce you to the basics of Access 2000. You will learn how to create
and use database objects, including tables, queries, forms, and reports.
Target Student: 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 fairly comfortable working in the Windows environment. No prior
knowledge of databases or Access is assumed.
Prerequisites: We designed Access 2000: Level 1 for the student
who needs to learn the basics about Access 2000. Although no prior knowledge
of databases or Access is assumed, you should be familiar with personal computers
and comfortable working in a Windows environment. To ensure your success with
this course, we recommend that you first take the following Element K Content
courses or have equivalent knowledge:
- Windows 95: Introduction
- Windows 98: Introduction
- Windows 98: Making the
Transition
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model
with structured hands-on activities.
Benefits: Students will learn how to create and use database objects,
including tables, queries, forms, and reports.
What's Next: Access 2000: Level 1 is
the first course in this series. Access 2000: Level
2, the next course in this series, teaches students how to enhance
their database designs by using the principles of normalization and table
relationships. Students also learn how to query multiple tables for data that
is used in customized forms and reports. Students who want to learn advanced
features can take the third course in this series, Access
2000: Advanced. In that course, students learn to create advanced
queries, create more efficient forms and reports, and work with macros. The
final course in this series, Access 2000: Introduction
to Application Design, teaches students to create custom applications.
Certification
Access 2000: Level 1 is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.
Hardware/Software Requirements
You will need:
- A Pentium 75 PC with 16 MB of RAM. (We recommend a Pentium
133 or faster with 32 MB or more.)
- 600 MB of free hard-disk space. For optimal performance, we
recommend an additional 100 MB of free hard-disk space for user graphics and
temporary image caches.
- Either a local CD-ROM drive or access to a networked CD-ROM
drive for installation purposes
- A 3.5"-disk drive.
- A two-button mouse, an IntelliMouse, or compatible pointing
device.
- VGA or higher-resolution monitor; Super VGA recommended. (The
EGA display adapter is not supported.)
- An installed printer driver. (Printers are not required; however,
each PC must have an installed printer driver to use Print Preview.)
- An Internet connection with access to the World Wide Web.
The connection is necessary to complete some tasks and Web Tips throughout
the book. (Note: Internet access may require payment of a separate fee to
a service provider.)
- Microsoft Windows 95 (or later) operating system, Microsoft
Windows NT Workstation operating system version 4.0 with Service Pack 3 (or
later) installed. If you are running Windows NT, make sure that you have at
least 4 MB of free Registry space.
- A custom installation of Microsoft Office 2000 Premium Edition—see
the following section, “Class Requirements,” for additional instructions.
Performance-Based Objectives
- Understand database concepts and terminology in Access 2000.
- 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.
Course Content
- Lesson 1: Overview of Access 2000
- Topic 1A: Introduction to Database Concepts and Terminology
- Topic 1B: Introduction to Access 2000
- 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: Modifying a Table Using Design View
- Topic 3B: Finding and Editing Records
- Topic 3C: Filtering and Sorting Records
- Lesson 4: Creating and Using Select Queries
- Topic 4A: Creating a Select Query to View Specific
Fields
- Topic 4B: Specifying Criteria in a Query to View Specific
Records
- 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 with the Form Wizard
- 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 with the Report Wizard
- Topic 6B: Creating a Report that Contains Totals
- Lesson 7: Creating and Maintaining a Database
- Topic 7A: Creating a Database
- Topic 7B: Managing a Database and Its Objects
- Topic 7C: Database Maintenance