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

 

Project 2

More Project Practice

20 Extra Projects

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

Exam 2

Use this link to access 100 additional exam questions (yay!)

Exam2

Quiz

Some more practice to master Microsoft Access Chapter 1!

Multiple 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

Instructor Resources

Instructor's material including answers to the exam, exam2, multiple choice questions, and the 20 additional projects

Exam Answers 

 

Exam2 answers

 

Multiple Choice Answers 

 

20 additional projects solutions

Back to Programs


Programs: Microsoft Access 2000