Computer Applications Lesson Plans: Microsoft Access Curriculum Blog Feature
Sarah Layton

By: Sarah Layton on September 17th, 2014

Print/Save as PDF

Computer Applications Lesson Plans: Microsoft Access Curriculum

Computer Applications | Microsoft Access | Microsoft Office

Do you give Microsoft Access its fair share of attention in your computer applications class?

I have to admit that I'm a bit of a database junkie! When done well, they are such amazing tools for all sorts of things in your professional and personal life.

So don't sweep Access under the carpet if it's not an application you are comfortable with. Give some of these ideas a try, and you'll soon embrace the database, too!

Here's where to find some good computer applications lesson plans that highlight Microsoft Access.

Microsoft Access Lesson Plans: Online Curriculum Services

The best software as a service options will provide you with engaging, interactive, and up-to-date curriculum. The content is designed to teach students basic and intermediate Microsoft Office skills. After content is presented, students can take quizzes. Later, module tests verify their achievement in the content areas.

And not only is the curriculum provided, the best programs will include a grade book. The grade book helps you gauge how well your students are learning and understanding the content. You can reset quizzes and test and allow students to take them over as needed.

The best part, both you and your students can access the program anytime, anywhere.

In our own Business&ITCenter21, students will learn the fundamentals of  basic database theory and gain practical experience with Microsoft Access. The module includes hands-on lessons where students will create databases, tables, forms, queries, and reports. Students will also use several methods for entering, maintaining, finding, and browsing data.

They'll begin with the Introduction to Microsoft Access unit where students will take a tour of Microsoft Access and be introduced to databases, tables, records and fields. They'll learn about data integrity and the difference between a database and a database management system. Students will use Microsoft Access to open and save databases, use data sheets and form views, and search and update records. They'll do that in these lessons:

Lesson 1- Microsoft Access Tour

  • Define Database, Table, Record & Field
  • Understand Why Data Integrity is Important
  • Difference between Databases and Database Management Systems
  • Use Microsoft Access Views

Lesson 2- Getting Started in Microsoft Access

  • Add, Update & Delete Records
  • Use the Data Sheet & Form Views
  • Search for a Record
  • Open & Save Databases

Then they'll move on to the Database Tables unit. In this unit, students will learn how to create their own Microsoft Access database tables and forms. In Access they'll learn how to use data sheet views, add fields to a form, and arrange controls on a form. Additionally, students will be taught about data types and primary keys. To achieve that, they'll do this:

Lesson 1- Create a Table

  • Create an empty database
  • Create a Table
  • Use the Data Sheet View
  • Describe Data Types & Primary Keys

Lesson 2- Create a Form

  • Create a blank form
  • Add fields to a form
  • Arrange controls on a form
  • Show & Hide the Navigation Pane

Finally, in the Queries and Reports unit, students will learn how to search, sort and filter database tables in Microsoft Access. They will learn about table relationships and understand primary and foreign keys. Students will then create queries between tables, used the Query Wizard and filter query results in Access. Finally, students will use Access to create a report based on a query.

Lesson 1- Searching & Filtering

  • Sort Tables in Ascending and Descending Order
  • Filter Tables and Reset Filters
  • Search for records in a table

Lesson 2- Queries & Relationships

  • Understand Table Relationships
  • Understand Primary & Foreign Keys
  • Create a relationship between tables
  • Create a query using the Query Wizard
  • Filter query results

Lesson 3- Reports

  • Create a summary query
  • Create a report, using the report wizard
  • Print Preview
  • Format reports

Microsoft Access Lesson Plans: Microsoft

Another option is Microsoft’s own Microsoft IT Academy Program. Here you’ll find customizable lesson plans. You will also find all sorts of valuable information and content for developing and refining your own computer applications lesson plans for Microsoft Access. You can also check out Microsoft in Education for some great ideas.

Microsoft Access Lesson Plans: Online Communities and Blogs

Yet another way, join online communities, follow some blogs online, or dig around on Pinterest. If you’re not sure how to get started, try a “top 20 blog” list or something similar, such as Scholastic’s list.

Do you have some great ideas about where to find computer applications lesson plans for Microsoft Access? Please comment and share with other teachers here on our blog!

The best resource?

Use a combination of all these resources in developing your lesson plans. It’s likely that not one single source will get you what you need, for example, read this post, Teach Microsoft Access Exercises Like a Pro!

Do you want to try the Microsoft Access lessons described above? Sign up for a free trial of Business&ITCenter21 to get started:

Get Business&ITCenter21 >


About Sarah Layton

Sarah has been with AES since 1998, first serving as a curriculum developer, and now as a customer support analyst and content creator. She is committed to helping instructors gain experience and confidence using our solutions and to providing excellent customer care.