Microsoft Courses > Microsoft Access 2000 Level 1 Training Course

Students will learn the basic skills necessary to begin using Access 2000. They will design and create databases, tables, queries, forms, and reports.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Access 2000: Level 2, the next course in this series, teaches students how to enhance their database designs by using the principles of normalisation and table relationships. Students also learn how to query multiple tables for data that is used in customised 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, teaches students to create custom applications.

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 a Windows environment. No prior knowledge of databases or Access is assumed.

Topics covered on the 2 day Microsoft Access 2000 Level 1 course

Lesson 1: Overview of Access 2000

Introduction to database concepts and terminology

An introduction to Access 2000

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 organise 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

   (excl.VAT)