Programs: Microsoft Access 2000®

Microsoft Access 2000®

Microsoft Access is one of the major applications in the Microsoft Office.  It is used to create and manage a database so that the user can add, edit, and delete records, run reports and queries, filter records, and allows for the use of multiple tables.  Many businesses use Access because it is a great database to store many different records and is very easy to use once you establish a basic knowledge of the program.

 

 Chapter 1 Objectives

  • Become more familiar with the vocabulary used in Access.

  • You will learn about both the Datasheet and Design View.

  • You will learn the primary functions of MS Access.

  • Be knowledgeable of the basics of forms, queries, and reports.

  • Be able to make basic additions, edits, and deletions of records.

  • Understand the concept of data validation.

  • Have an understanding of filters and sorting.

  • Be able to filter by selection or by form.

  • Learn to sort ascending and descending.

  • Learn what a relational database is.

  • Learn when and why to use a relational database.

  • Become comfortable with using and creating a relational database.

  • Learn to use the referential integrity tool.

 

Chapter 1 Lessons and Resources

 

Lesson

Description

Link

Lesson 1

Introduction to the basics of Microsoft Access

Walkthrough

Lesson 2 Forms, Queries, Reports, and learning how to use the Find, Replace, Undo, and Delete Commands Walkthrough
Lesson 3 Learn how to apply Filters and Sorts Walkthrough
Lesson 4 Relational Databases and Referential Integrity  Walkthrough
Lesson Exercises Practice the skills you have developed by doing these exercises each containing a step to step guide on how to do the exercise Exercises
Project This Project is designed to test your knowledge on all the aspects of Microsoft Access you have learned in the lessons Final Project
Glossary Here is a list of terms along with definitions from Chapter 1 for use as a personal resource Glossary
Exam Think you've mastered Microsoft Access Chapter 1?  It's exam time!!! Exam
Quiz Some more practice to master Microsoft Access Chapter 1! Mulitple Choice Questions
Useful Websites Supplementary links to websites associated with Microsoft Access that may further help to hone your skills with the program Useful Websites
PowerPoint Presentation A PowerPoint Presentation covering all of the Microsoft Access Chapter 1 objectives PowerPoint Presentation
College Books List One of the Microsoft Access examples to follow  College Books List
Personal Database Another Microsoft Access example to follow  Personal Database

Back to Programs

Programs: Microsoft Access 2000®