Do the following Tasks

1) Create a spreadsheet that includes a list of the students

a) Import the data from the spreadsheet to the table student, you need to create a query (Week8-del-students) to Delete the existing records

b) Link the spreadsheet. Create a report from the linked spreadsheet.

2) You are going to create the following queries

list the content of each table using condition (criteria) of your choice, you MUST explain each condition

 

You are going to add your name as student too,

Try to use criteria (condition) for the following (explain each condition)

 

Create at least one update query  

Create at least one insert query

Create at least one delete query

 

Create a query and use it in a report to show the schedule of courses

Create a query and use it in a report to the list of students per class

Create a query and use it in a report to list the courses per instructor

 

3) Create a form with a custom navigation buttons (command button) to open each form and report.

 My name is Matthew Bowen when it asks for my name

APlusGrades

Not Rated (0)

Status NEW Posted 16 Jul 2017 08:07 AM My Price 11.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer