Grader $-$ Instructions

Access $2016$ Project

Access Assignment $-$ Using the Hotel Database for Advanced Querying

Project Description:

The area of Painted Paradise Resort & Spa that generates the most revenue is the hotel. Guests may charge anything from the resort to their room. Thus, the hotel staff must track all of these charges, such as those from the spa, golf, gift shop, restaurants, movies, personal trainers, and sessions with golf professionals. These services are eligible for a discount. You have been asked to create a new table and create queries that will help management with decision making.

Steps to Perform:

$\backslash$table$[[$Step$,$Instructions,$\backslash$table$[[$Points$],[$Possible$]]],[1,\backslash$table$[[$Open the Access file, AccessAssignment.accdb. Save your file as$],[$AccessAssignment$\_$LastFirst, using your last and first name. If necessary, enable the$],[$content$.]],0],[2,\backslash$table$[[\backslash$table$[[$Create a new table with the following attributes:$],[$Field Name $,$ Data Type$],[$PmtID $,$ AutoNumber$],[$GuestID Number$],[$ReservationID Number$],[$PmtAmount Currency$],[$PmtDate $,$ Date$/$Time$],[$PmtMethod $,$ Short Text$],[$AuthNumber $,$ Short Text$]]],[$Enter the following descriptions for each field:$],[$PmtID: The payment ID automatically assigned to each transaction $($primary key$)],[$GuestID: An alphanumeric code unique to every guest matching a guest in the$],[$tblGuests $($foreign key$)],[$ReservationID: An alphanumeric code unique to every reservation and matches a$],[$reservation in tblReservations $($foreign key$)],[$PmtAmount: The amount the guest paid$],[$PmtDate: The date the guest made the payment$],[$PmtMethod: How the customer paid $($Cash$,$ Check, MasterCard, Visa, American$],[$Express$,$ Discover$)],[$AuthNumber: The authorization number if paid by credit or debit card. Authorization$],[$numbers can begin with the number zero.$],[$Save the new table as tblPayments.$]],11]]$