Outcomes addressed in this activity:
Unit Outcomes:
Report on objects in the Microsoft Access database.
Construct tables in Microsoft Access.
Course Outcome:
IT163-2: Create relational databases with multiple entities and relationships.
GEL-1.02: Demonstrate college-level communication through the composition of original materials in Standard English.
Purpose
This assignment introduces you to the Microsoft Access database application. Using what you learned in your reading about relational databases and gathering database requirements, you will write a paper in which you demonstrate your understanding of the components of the Microsoft Access relational database system. You will also apply what you learned to translate your physical model into an actual Access database.
Assignment Instructions
This assignment will consist of two parts.
PART 1:
Before you begin developing the actual database, you need to do a bit of research. Database administrators today continually research customer’s needs when designing and developing a database. This activity will help prepare you to conduct this type of research.
You will compose an essay that fulfills the following requirements:
Define the terms database, table, record, field, and value and describe the hierarchy that exists between these terms.
Demonstrate knowledge of a relational database. Your goal is to demonstrate to your professor that you understand what a relational database is.
Describe the six database objects available in Microsoft Access
Describe the five-step design method discussed in your reading.
The paper must be written in your own words. You are encouraged to read the assigned readings first to gain valuable insight for your paper.
PART 2:
You must have the Microsoft Access database system installed for this part.
Using your physical model, create a database in Microsoft Access. Each entity in your diagram represents a table object in your database.
Start by creating a new, blank database.
Reference: Alexander, M., & Kusleika, D. (2019). Access 2019 bible. Wiley.
Chapter 2: “Getting Started with Access / How to Create a Blank Database”
Create the tables in your database. Use the table names, field names, primary key information and data types from your physical model to design your tables.
Sample Solution
