Module 8: Database Applications with Access
Understand the principles of database construction, navigate the Access window, and build the three core objects: a table, a form, and a report.
What You'll Learn
- Explain how a database differs from a spreadsheet and when each is appropriate
- Describe the features of the Access window and its four object types
- Design a table with appropriate data types and a stable primary key
- Create basic database objects: tables, forms, and reports
Real-World Scenario
The patient contact list at Lakeside Medical Associates is a spreadsheet with one row per appointment, so a patient who has visited eleven times has her address stored eleven times. She moves, four rows get updated, and the practice now holds two addresses with no way to tell which is current. Your supervisor asks you to rebuild it properly — which means understanding why a database stores each fact exactly once.
Lessons
Complete each lesson in order. Watch the video, review the notes, and finish the challenge.
Basic Principles of Database Construction
Understand what a database is, why a spreadsheet stops being adequate, and the design rules that keep data trustworthy.
The Access Window and Database Objects
Navigate the Access interface and learn what each of the four object types is for.
Creating Tables, Forms, and Reports
Build the three core objects of a working database: a table with proper data types, a form for entry, and a report for output.