You will essentially complete Problem #1 at the end of Plug-in T-6 ("WasteNot Recycling"), with some specified additions/modifications.  You will also attempt some operations on the database you will create in this assignment, make some observations, & then report these observations in an accompanying document file submission. 

As soon as you have opened a new database file in Access in order to create this assignment, you must save and name this file: "SU_Lastname_Firstname" where Lastname is your last name and Firstname is your first name.

After completing parts 1 through 3 of this assignment, you should also:

• Add two additional customer records, one with your name and one with a friend's name to the "Customer" table.

• Add an additional 14 records to the "Customer Record" table. These records should indicate service dates in January and February of 2007. They should also be related to existing customers in the "Customer" table (including the customer record for Jay and Jenny).

When you create the relationship between the 2 tables (i.e. part 4 of this problem), please be sure to check the checkbox for "Enforce Referential Integrity" as well as the checkboxes for "Cascade Update Related Fields" and "Cascade Delete Related records".  If you do not check these boxes as specified you may come up with radically different answers to the questions.

You will now make some observations based on the following questions:

1. What happens when you try to enter a record into the "Customer Record" table for which there is no corresponding record in the "Customer" table?

2. What happens when you try to delete a record from the "Customer" table for which there is at least one corresponding record in the "Customer Records" table?

3. What happens when you try to change the value of "Customer ID" in the "Customer" table for which there IS at least one corresponding record in the "Customer Records" table?

 

T6-1*Plug-In T6Basic Skills and Tools Using Access 2013PLUG-INT6Access 2013Basic Skills and Tools Using1.±Describe the primary functions using Microsoft Access.2.±Describe the steps for creating a new database file using Access.3.±Describe the steps for creating and modifying a table and fields using Access.4.±Describe the steps for creating relationships between tables using Access.Introduction to AccessMicrosoft Access 2013is a powerful database program that allows you to enterand organize large amounts of data. Because Access allows you to relate tablesand databases to one another, it is often referred to as arelational database.Plug-In T5, “Designing Database Applications,” explains relational databases and theirstructures in detail.This plug-in introduces the basics of creating a database using Microsoft Access.It is designed to show you the essentials, along with a few added-value features, toget you off to a good start using the program.In brief, a relational database is a group of tables related to one another by com-mon fields. Atable(or datasheet) looks similar to a spreadsheet. Eachrowin thetable contains all the data for a singlerecord.Eachcolumnin the table represents aspecific data value called afield.All records in a relational database have the samefields. For example, a table calledEMPLOYEEmight include fields forEmployeeID, Last Name, First Name, Address, City, State,andZip.Another table calledTIMESHEETmight have fields forTime Sheet Number, Employee ID, Week, Hours Worked,andRate of Pay.The two tables are related by theEmployee IDfield, so thedatabase can generate reports combining information from the two tables.Figure T6.1displays this relationship.Access comes with templates for common database categories, including projectplanning, employee time sheets, expense reporting, and inventory management.LEARNING OUTCOMESbal76744_plugint06_002-018.inddT6-22/22/0811:27:03 AM