Computer Applications Lesson Plans: Microsoft Access Curriculum
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: