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