• 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)
• Open MS Access, Select New, type Northwind on the search field, double
click to open Northwind
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)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 9 images
