PLEASE, Only serious people respond. I will pay you through the scriptlance account ONLY. If that is not good for you, please do not bid on this project!!! Also, I will pay you your BID price. Do not bid a price, do the work, and then haggle or hassle me for a larger fee. The project is listed IN FULL, so please bid for an acceptable amout for you. This project needs to be done in 20 hours.
Below is the project. Please use the attached database as your data. The deliverable is an Access database with working data entry forms and reports.
Reports should display two or more child rows for each parent row. For example, a report that shows course instructors are approved to teach would display each instructor with 2 or more courses that instructor is approved to teach. If you need to add data you may do so.
Create a report using the wizard or based on an SQL query that that shows Courses that instructors are approved to teach.
Create a report using the wizard or based on an SQL query that shows student information and what their major is.
Create a report using the wizard or based on an SQL query that that shows student information by zip code. Zip codes shall be in increasing order.
Create a report using the wizard or based on an SQL query that that shows the Course Name and the students in each. Sort Course Number in increasing order.
Create a report using the wizard or based on an SQL query that that shows status for each student. The student should be in alphabetical order by last name, then first name.
The text and tutorials provides the knowledge needed to create a sample data entry form. Each system has its own characteristics with respect to data input. The form should be created in Access, and should be representative of one of the major entities in the database. Appropriate design elements such as the source documents, the need for forms/subforms and GUI control options should be considered.
*Create a form that is based on an SQL Query.
*Create a form using the wizard.
*Create a form of your own design using a master detail relationship.
********The deliverable is an ACCESS database with working data entry forms and reports.
Thank you to everyone for your consideration!