Project #4
Database Project
- Project 4 Instructions Actions | Print and follow these instructions to complete this project
- You can build the database example I have outlined in these Instructions
OR you can build your own database.
If you build your own databaseThe database must contain at least 3 tables (with at least 5 fields and 5 records in each table)
You may not use a template for this project
CISC 310 – Intro to Computer Information Science – Databases
Page 1 of 3
Last Modified 4/21/2021
Project 4 – 25 points
Unit 10 | Databases – Create Database Tables
Before completing this project, please review this week’s instruction module, and read Unit 10 – Computer
Concepts 2016. For this project, students will create a new database, with at least 3 tables and multiple records.
Project Instructions and Requirements
Using Microsoft Access, create a New Database. Do not use a template for this
assignment. Create at least three tables. Students can create the database as shown in this
handout.
OR
Students can choose to create a custom database project. Create your own database for
music, small business inventory, etc. Then, enter your own data into the database.
The project must include at least 3 tables, include at least 5 fields for each table, and
include at least 5 records in each table.
Filename: project4 – upload the database file to Canvas by due date
Extension for the file will be created by the program (Access)
Database Software Application – Using Access
Create the Donors Table (Table 1)
Create a new table named DONORS. Use Design view and create the fields
*PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN
*PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN
CISC 310 – Intro to Computer Information Science – Databases
Page 2 of 3
Last Modified 4/21/2021
Add 5 records to table | INCLUDE ONE RECORD WITH YOUR FIRST AND LAST NAME
Create the Donations Table (Table 2)
Create a new table named DONATIONS, go to Design view and create the fields
*PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN
Add at least 5 records to the table
Create the Events Table (Table 3)
Create a new table named EVENTS, go to Design view and create the fields
*PROVIDE A DESCRIPTION FOR EACH FIELD – AS SHOWN
CISC 310 – Intro to Computer Information Science – Databases
Page 3 of 3
Last Modified 4/21/2021
Add 5 records to each table | USE CURRENT DATE FOR DATE FIELD
Before submitting the assignment
• View each table to assure all data in each column can be seen
• Resize any column that you cannot see all information each record
o Hover over line between columns (at top)
o With the mouse showing double-sided arrow, click/drag to resize the
column so all data is visible
Upload the Project 4 database file to Canvas by the due date.