Independent Films Database
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.
For the purpose of grading the project you are required to perform the following tasks:
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.
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
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.
In Design view, in the tblCustomers table, reposition the ID field as the first field in the table.
Modify the appropriate Field Properties to ensure that data in the FirstName, LastName, and E-mail fields are required for new and existing records.
Create a multiple-field index. Name it CustomerName and include the LastName and FirstName fields, sorted in Ascending order.
Change the data type for the E-mail field to Hyperlink.