The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
Use the names assigned at the end of each problem to name your files.
Using the downloaded DB you are to:
1) Create a report of all customers that have outstanding rentals. Save as rptOutstanding
2) Create query that tells me the top 7% of movies in stock. They must appear in descending sequence. Save as qryTop7
3) Tell me how many customers live in each city in the DB. This is to be structured as a report grouped by city with a footer section presenting the count. This is to appear professional in nature with your own formatting. Access canned formatting will cost you points.. Save this as rptCityCount
4) Identify which genre movie is the most popular in inventory. Be sure that it is genre readily identifiable by forcint the most popular genre to appear at the top of the list. Save as qryGenre
5) Create a form that will permit me to naviagte through the records without using the record navigation buttons at the bottom of the form. Looking for on form buttons here....
Sign in or Register to see more