Includes multiple versions for Office 2019 | 2016 | 2013
Microsoft Access introduction to database lesson plans integrate computers into curriculum. Students follow the detailed, illustrated instructions in TechnoMission to learn how to construct a simple database. They begin with by exploring a database about space exploration. Then they plan and construct a database on a topic of their choice. A table is created and field properties are adjusted. Next they design a form and finally they generate a simple report.
INTRODUCTION TO DATABASE LESSON PLANS: Students use Microsoft Office Access to organize and construct a unique database. They filter records to find data. Then they build a table and adjust field properties, make a form, and generate a report, becoming confident database creators.
READYMADE STEP-BY-STEP INSTRUCTIONS: Student Workbook in PDF format encourages independent progress and differentiated instruction. Learners can work at an individual pace. Pictures illustrate and model examples. Sample Space Exploration database of 55 missions allows students to compare viewing options, practice filtering techniques, and add a record of themselves in a space suit!
ADVOCATE STEM, CTE, AND ICT LEARNING: Promote essential technology skills for career readiness. Advance computer proficiencies to develop a groundwork in the technical skills future employers will be seeking.
FOSTER STRONG SOFT SKILLS: Cultivate vital interpersonal traits and behaviors – communication, initiative, creativity, responsibility, problem solving, logical thinking, and more. Planning sheets, checklists, and challenging extension activities advance these key life skills.
Assignment 1 Space Exploration
Preview a timeline about the history of space exploration.
Assignment 2 What is a Database?
Define the meaning of terminology (e.g. table, form, record, field).
Assignment 3 About Microsoft Access
Identify parts of a database window.
Assignment 4 Look at a Table and a Form in a Database
Compare viewing options in a database.
Assignment 5 Filter Records in a Database
Apply techniques to find information in a database.
Assignment 6 Take Digital Photos
Capture a portrait of a person using a digital camera.
Assignment 7 Suit Up
Superimpose a person’s head into a space suit image to make an astronaut.
Assignment 8 Add a Record into a Database
Use a form to add an astronaut.
Assignment 9 View Astronaut Records
Display records in a database to locate specific astronauts.
Assignment 10 Cyberspace Mission Planning Sheet
Select a topic. Plan the content of a database.
Assignment 11 Blast Off on a Cyberspace Mission
Research information about a topic.
Assignment 12 Build a Table
Construct a table in datasheet view. Set field properties.
Assignment 13 Create a Form
Build a data entry form. Use Design View to edit the appearance.
Assignment 14 Add Records using the Form
Organize research information into database fields.
Assignment 15 Create a Report
Generate a summary of the records in a database.
Introduction to Database Extension Activities
- About Space Missions: Practice filtering records.
- Sort and Find Records: Learn advanced skills.
- Blast Off! Review photo editing skills.
- Make a Mission Patch: Design your own patch.
- The Moon, Mars, and Beyond: Try Internet searches.
- My Family: Create a family database.
Use TechnoMission with unlimited users at your site. A site is a physical location such as classroom, school, learning center, daycare, library, or home. If you teach at multiple sites, you will need to purchase one set for each location. Access everything you need from TechnoHub, and transfer the files to all devices at your site. View the PDF teacher guides and workbooks digitally or print as many as you need. Files CANNOT be posted in public domain.
Introduction to Database Project using Microsoft Access Lesson Plans
Integrate technology into a problem solving and data management unit. Or choose a topic related to a language arts, science, social studies, geography, or history for a cross-curricular project.
View, find, sort, filter, and add records in a database
Superimpose two images using digital tools
Plan and organize the topic of a database
Use search engines to research information
Build a new database
Create a table and set field properties to store data
Design a data entry form
Organize categorical data in a database form
Produce a report that groups and sorts records
Revise the content and layout of a database object
Write a Review
I have been using this project for a few years now and love it! In fact, I love it so much that I just updated to a newer version so I could keep using it with our recent software update! The lessons and structure of the project are so well done- easy to follow, supported with text and graphics, sequenced and paced perfectly. TechnoKids lessons are a teacher's dream come true! And their customer service is the best I have ever worked with of any vendor I use. I truly can't say enough positive things about this company and their materials!
My students loved this project. Teaching database concepts is always a challenge, but this program made it understandable to the students and they loved working at their own pace.
I really enjoyed TechnoMission. The students really felt part of the curriculum being able to pick their own topic.
Mission is great being that learning Access can be difficult. Some students said yesterday that they think Access is easier, maybe due to the fact we are using Mission space exploration to teach it!
I loved TechnoMission and so did the kids. It was great.
I absolutely LOVE IT! It is saving my life! The kids really enjoy the activities and I don't have to reinvent the wheel.