# Anyone Who Can Hack This Asap For \$20

Write my research paper
IS 312 Homework 3: Access Queries [10+1 points]
Assigned 2/11 for Mon and 2/12 for TR; Due 2/18 and 2/19 respectively• All the problems will use the “Restaurants-2018” Access database.
• All answers must be typed, 12-point font (or equivalent) to facilitate my remarks and corrections (2-point penalty for violation).
• Solutions must be assembled in the right order (2-point penalty for out of order).
• All questions must print out design view and datasheet view, with design view before datasheet view. [Design view can only be obtained through screen print]
o Order of assembly: Q1 design, Q1 data; then Q2 design, Q2 data, etc.Problem 1 (3 points). Create query with AND and OR.Create a query to display restaurant ID, city, state, annual sales, and square footage, for
those restaurants in California with sales not more than \$400,000,
or
those restaurants in the cities of Miami or Orlando, with sales not less than half a million. [Watch out this part – “cities of Miami or Orlando”]Problem 2 (4 points). Total query. Create a total query with grouping, interpret the outcome of the query.Create a total query –
grouped by city,
count the restaurant ID,
sum on square footage,
min on date opened.
*** interpret the outcome of the query, in bullet form (so you will have three bullet points).Problem 3 (4 points). Create a query with calculated fields.Create a query with calculated fields –
1) Year_In_Biz, which is defined as the years a restaurant is in business, rounded to 1 decimal place;
2) Sale_Per_SqFt, which is annual sales divided by square footage, rounded to 0 decimal place.
3) Conditions: Year_In_Biz at least 18, AND Sale_Per_SqFt at least \$350/ft
This is property of essayprince.net. We are the first stop for all students Buying research papers online. Our paper writing service is second to none. Come and Buy research papers online here, TODAY

Don't use plagiarized sources. Get Your Custom Essay on
Anyone Who Can Hack This Asap For \$20
Just from \$8/Page
Pages (550 words)
Approximate price: -
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Try it now!

## Calculate the price of your order

Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.