+
Your Office Series Vol 2 Independent Films Database

Your Office Series Vol 2 Independent Films Database

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/your-office-series-vol-2-independent-films-database/

Independent Films Database
 
Project Description:
Independent Films is a local company that sets up screenings of independent films for the public at various venues in the area. They have been using an Excel spreadsheet to keep track of ticket sales and now realize the amount of redundant data they have been storing with each transaction. Management has decided that an Access database would be a better option for them, and they need help normalizing the data.
 
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

Start Access. Open the downloaded Access file nameda03ws05_grader_a1.accdb. Save the file with the namea03ws05Films_LastFirst, replacing LastFirst with your name. Enable the content, if necessary.

0

2

Use the Table Analyzer Wizard to help separate and normalize the data contained in the tblPurchases table. Rename the tables in the Table Analyzer Wizard to the following.• Table1= tblTicketSales• Table2 = tblCustomers• Table3 = tblFilmScreenings

12

3

Continuing in the Wizard, move the CostofAdmission field from the tblFilmScreenings table to the tblTicketSales table after the Quantity field. In the tblFilmScreenings table, make ScreeningID the primary key. There are no typographical errors to correct in any of the tables. When prompted, do not create a query that looks like the original data.

10

4

In Design view, in the tblCustomers table, reposition the ID field as the first field in the table.

5

5

Modify the appropriate Field Properties to ensure that data in the FirstName, LastName, and E-mail fields are required for new and existing records.

10

6

Create a multiple-field index. Name it CustomerName and include the LastName and FirstName fields, sorted in Ascending order.

10

7

Change the data type for the E-mail field to Hyperlink.

7


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial