Business-Management

Professor Information

Available Classes

Grade Points

Registration Information

.

Assignment 1: Create a database and name it with your name (lastname_firstname). Create tables (tblstudents, etc.) for each set of information in the database. Add appropriate fields to each of the tables and name them with fldname_of_the_field and give each field the appropriate data type. Do not add or delete any attributes from those listed above. Create relationships. Add data listed above to appropriate tables. Create 2 queries. First list all professors’ name and department. Name this query qry1_project. Second list all Classes worth four or more credits; include class #, name, and credits. Name this query qry2_select. (tables and relationships 90 points queries 30 points)

Assignment 2: Create a query that shows the address of the professor that teaches each class (include the class number and name along with the street address and name of the professor). Name this query qryjoin_professor_address. Create a query that shows the name and student number of students that took classes from professors that live in Chicago. Name this query qryjoin_student_professor_chicago. Create a query that calculates the quality points earned for each student for each class they took (credits times points for the grade). Name this query qryquality_points. Create a form to input new professors. Name this form frmprofessors. Create another form to input new classes. Link this form to the professor form so that new classes will have the current professor’s number in the “taught by” field. Create command buttons (command buttons – this is covered in the forms videos) to: 1) open class form from professor form, 2) close professor and class forms, and 3) go to new record on the class form. Name the second form frmclass_input. . (Queries 90 points forms 30 points).

Extra credit: Determine which is the easiest class and hardest class – based on average grade. (20 points)

Grading: Both parts are worth 120 points so they are weighted equally toward your grade for the Access assignment. You should create one database. You can turn in the db when you have finished the requirements for assignment 1 under the first assignment. Work on the material for the second assignment (do not delete the queries from the first) and then turn in the whole database under assignment 2. This means that the database you turn in for assignment 2 will have all the items for assignment 1 in addition to those items required for the second assignment. YOU MUST TURN IN A DB THAT HAS AT LEAST THE SOLUTION TO PART I UNDER THE PART I ASSIGNMENT. You can turn in the completed db under both assignments, but I need a db under part I or the Learning Management System will not allow me to grade you.