Project #4

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.