Database for the Burchard Museum Of Science and Discovery: Relationships between Tables and Queries within Database
Museum Volunteers
Project Description:
In this project, you will create a new table and share data with Excel in a database for the Burchard Museum of Science and Discovery. Additionally, you will establish relationships between tables, and then create queries within the database.
Instructions:
For the purpose of grading of the project you are required to perform the following tasks:
Step
Instructions
Points Possible
1
Start Access. Open the downloaded Access database named Exploring_a02_Grader_IR.accdb.
0
2
Create a new table, save the table using the name StartDates and switch to Design view. Add the field name VolunteerID using the default data type (Text). Add the field name StartDate and change the data type to Date/Time.
14
3
In the new table, set the field name VolunteerID as the primary key.
3
4
View the StartDates table in Datasheet view. Add the following records to the table:
VolunteerID StartDate
1020 9/24/2007
1021 6/30/2008
1022 11/3/2008
1023 3/16/2009
1024 2/15/2010
1025 12/6/2010
Close the table.
6
5
Begin to import the downloaded Exploring_a02_Birthdays.xlsx workbook as a new table in the current database. Click Next two times.
8
6
Set the VolunteerID as the primary key, and then click Next.
3
7
Import the table with the name Birthdays, click Finish, and then click Close.
4
8
Begin establishing relationships in the database by adding the Department Managers and Volunteers tables to the Relationships space.
4
9
Create a one-to-many relationship between the Department field in the Department Managers table and the Department Field in the Volunteers table, being sure to enforce referential integrity. Close the Relationships window, saving the changes.
10
10
Begin to create a query using the Simple Query Wizard. From the Volunteers table, add the following three fields to the
Project Description:
In this project, you will create a new table and share data with Excel in a database for the Burchard Museum of Science and Discovery. Additionally, you will establish relationships between tables, and then create queries within the database.
Instructions:
For the purpose of grading of the project you are required to perform the following tasks:
Step
Instructions
Points Possible
1
Start Access. Open the downloaded Access database named Exploring_a02_Grader_IR.accdb.
0
2
Create a new table, save the table using the name StartDates and switch to Design view. Add the field name VolunteerID using the default data type (Text). Add the field name StartDate and change the data type to Date/Time.
14
3
In the new table, set the field name VolunteerID as the primary key.
3
4
View the StartDates table in Datasheet view. Add the following records to the table:
VolunteerID StartDate
1020 9/24/2007
1021 6/30/2008
1022 11/3/2008
1023 3/16/2009
1024 2/15/2010
1025 12/6/2010
Close the table.
6
5
Begin to import the downloaded Exploring_a02_Birthdays.xlsx workbook as a new table in the current database. Click Next two times.
8
6
Set the VolunteerID as the primary key, and then click Next.
3
7
Import the table with the name Birthdays, click Finish, and then click Close.
4
8
Begin establishing relationships in the database by adding the Department Managers and Volunteers tables to the Relationships space.
4
9
Create a one-to-many relationship between the Department field in the Department Managers table and the Department Field in the Volunteers table, being sure to enforce referential integrity. Close the Relationships window, saving the changes.
10
10
Begin to create a query using the Simple Query Wizard. From the Volunteers table, add the following three fields to the