You will be using the database that I have attached. (Note:Lab 5 SQL )The text

You will be using the database that I have attached. (Note:Lab 5 SQL )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.1. Create a report using the wizard or based on an SQL query that that shows Courses that instructors are approved to teach.2. Create a report using the wizard or based on an SQL query that shows student information and what their major is.3. 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. 4. 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.5. 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.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. 1. Create a form that is based on an SQL Query.2. Create a form using the wizard.3. Create a form of your own design using a master detail relationship.

The post You will be using the database that I have attached. (Note:Lab 5 SQL )The text appeared first on Lion Essays.