• Open MS Access, Select New, type Northwind on the search field, double click to open Northwind database. After the Northwind 2007 is launched as shown below please answer the following questions in...


• Open MS Access, Select New, type Northwind on the search field, double

click to open Northwind database.
After the Northwind 2007 is launched as shown below please answer the following

questions in a note pad file named “surname student#”.
Note: the Northwind sample database in an older version of MS Access is very

different from the one in MS Access 2007 or higher )
1. What version of Access do you have?
2. Choose Object Type on the Navigation Pane. Please list different objects or

components available in the Northwind Database window? Describe FIVE of them

in simple words in terms of their functions.3
3. In the TABLE Shippers, how many shippers are there? Please list them.
4. In TABLE Orders, which field (i.e. column heading) is identical to the field in
TABLE Employees? and TABLE Customers? and TABLE Shippers? Please list

all you can find in the format like

Orders.field1=Employees.field2, and etc. (Clarification: consider the identity in

terms of contents but not the field names, and allow combination of fields in the

same table, for example

Orders.fieldnameX= Employees.fieldnameY+ Employee.fieldnameZ)





Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here