Project #59348 - Database

Before I give the assignment to you I need to know you understand the assignment completely. Message me first for questions about the assignment. The data I want you to use is attached in a DOC file. Here are the deliverables. The first spreadsheet needs to be done in Microsoft Excel. The rest must be done in Access. (i.e. the queries are done in Access as well). 1.) I will need the spreadsheet that you used to create the list of students. 2.) I need the Week8-del-students query used to import the data from the spreadsheet to the table student. This query should delete existing records. 3.)Make sure the spreadsheet is linked and provide the report from the linked spreadsheet. 4.)Create the following query and you must explain each condition: One update query. 5.)Create the following query and you must explain each condition: One insert query. 6.)Create the following query and you must explain each condition: One delete query. 7.) You must create a query and use it in a report to show the schedule of courses. 8.) You must create a query and use it in a report to list the students per class. 9.) You must create a query and use it in a report to list the courses per instructor. 10.) You must create a form with custom navigation buttons (command buttone to open each form and report. 11.) Each object you create must start with Week8-.... Here is the original project listing: Instructions: 1) You must upload the database name in this format INFO261_WK8_{yourlastname}.accdb. 2) Make sure that you review Chapter 8 from the text book. 3) I encourage you to search the Internet for additional information. 4) The name of each Object should start with Week8-. Assignment: 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.

Subject Computer
Due By (Pacific Time) 02/27/2015 02:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy