What version of Access do you have?

Please list different objects or components available in the Northwind Database window. Describe two of them in simple words in terms of their functions.

In the table Shippers, how many shippers are there? Please list them.

In the table Orders, which field (i.e. column heading) is identical to the field in the table Employees? And table Customers? And table Shippers? Please list all you can find in the format of Orders.field1 = Employees.field2, etc.

Clarification: consider the identity in terms of contents but not the field names and allow combinations of fields in the same table; e.g., Orders.fieldnameX = Employees.fieldnameY + Employee.fieldnameZ.

Find the order with the most expensive freight, and list the Order ID and freight charges.

What are the seven options available in the form: Main Switchboard?

What is the dollar amount of products ordered by B's Beverages (CustomerID=BSBEV) during the 1st Quarter of 1997? What is the total dollar amount ordered by B's Beverages in 1997? (Hint: Find the relevant form first. Note: If your version does not go up to 1997, please do the same for 1995.)

How many orders have been shipped in 1997? Whats the total sales revenue in 1997? (Hint: Find the relevant form first. Note: If your version does not go up to 1997, please do the same for 1995.)