ACCESS Assignment Due on April 30, 2014 (at 5:00 PM) Victoria owns an Antique shop in Never Never Land Mall. In addition to selling antiques,...
Access questions.. please solve the "accdb" file using "docx" instruction. Thank you.
ACCESS AssignmentDue on April 30, 2014 (at 5:00 PM) Victoria owns an Antique shop in Never Never Land Mall. In addition toselling antiques, Victoria provides restoration classes offered to customersand Mall shoppers. Victoria has already developed a database with a numberof entities and now she is trying to query the database to answer somequestions and extract the information she needs. Open the database NeverNeverLand.accdb from the Access AssignmentFolder on Canvas. Familiarize yourself with the database and answer thefollowing questions:a. (1 pt) Victoria needs to identify those students who have signed up forclasses with high unpaid fees. Create a query that helps her identifystudents with unpaid fees greater than $ 40. Save the query asqryUnpaid_GT_40. b. (1) Victoria wants to identify dealers who carry military memorabilia.Create this query. Name it as qryNoMeomorabilia. c. (1 pts) Victoria expects the cost of classes to increase by 20 percent fornext year’s enrollment. Create a query which reflects the 20 percentincrease in cost. Name it qryEnrollment+20% d. ( 1 pts) Create a relationship diagram among the different tables save itas Relationship. e. (1 pt) Create a list that includes the ID numbers, last names, first names,and phone numbers for customers in Cleveland and Knoxville. Save it asqryCleveland_and_Knoxville. f. (1 pt) Create a list that includes all green booths which are rented formore than $250. Save it as qryGrrenBooth>250. g. (1) Create a list of all the February classes sorted by date and by time. Besure to include information the reader is interested in such as name of theclass, the date and time, and the class fee. Save it as qryFebClasses. h. (1) When Victoria reviews the list for February classes, she thinks thatthe dates would be more meaningful if they spelled out the day of theweek, using a format such as “Saturday, February 5, 2013.” Victoria asksyou to modify the class list to display this format. Save this asqryFeb_Long_Date i. (2 pts) Victoria has requested an easy way to browse customer data alongwith the classes in which customers have enrolled. She wants to also usethis form to quickly mark the record when the customer has paid for aparticular class. Create the requested form for Victoria. As you build theform, consider the design, arrangement of fields, and the generalattractiveness of the form. Select the layout and style that provides thebest “look” for this application. Save this as frmEnroll.
Show more
