Dear freelancer
THIS IS URGENT: I need this completed within 12 hours
I need help learning how to do a few specific things in MS Access 2007. So I preferably want a simple video-clip showing the steps (or an intiutive step by step guide).
Prerequisite: From within Access download the sample database Northwind and understand the basics in it.
Task 1:
- build these SQL queries and execute them in Access:
a) Sum of all sales in 2006
b) Number of sales in 2006
Task 2:
Use Access's built in Report Generator to produce these two reports:
- Produce a report showing all sales in 2006 sorted by size of orders
- Produce a report of all customers and their orders/purchases sorted by largest customers
Happy bidding