? STEP 1Download the Lab4Database.accdb data

? STEP 1Download the Lab4Database.accdb data

? STEP 1Download the Lab4Database.accdb database from Doc Sharing.Rename the Lab4FormsReports.accdb database with a name containing Lab4, your first initial, and your last name as the file name (e.g., Lab4JSmith.accdb).STEP 2Back to topRun Access 2010, either via Citrix or from Visio 2010 installed on your workstation.Open the database you renamed in Step 1.See the tutorials above for instructions on how to perform the following steps in Access 2010.STEP 3 ReportsCreate a report for each of the following requirements. Reports may be created using the wizard or an SQL query. Reports should follow the formatting guidelines given in the next step. Reports should be named as indicated below (e.g., Report1, Report2, etc.).Report1: Show Instructor information (InstructorID, FirstName, LastName) grouped by Approved CourseNo.Report2: Show student information (StudentID, FirstName, LastName, Status, Zip) grouped by Major.Report3: Show student information (StudentID, FirstName, LastName, Major) grouped by Zip code. Zip codes should be in increasing order.Report4: Show student information (FirstName, LastName) grouped by Course Number and Course Name. Course Number should be in in increasing order.Report5: Show student information (StudentID, FirstName, LastName, Address, Zip) grouped by Status. Students should be in alphabetical order by LastName and;then FirstName.STEP 4 Report FormatReports should display two or more child rows for each parent row. For example, Report1 should display each CourseNo with instructors who are approved to teach the course grouped under it. In this case, the parent row would be the Approved CourseNo with Instructor listed as child rows underneath each parent rowThere should be at least two child rows of data for each parent row. Add data to the tables in order to have reports show at least two child rows per parent.STEP 5 Back to topForm1: Create a form based on an SQL query.Create and run an SQL query that displays Student Information (StudentID, FirstName, LastName, Address, Zip).Save the query in the database named Form1Query.Create a form based on Form1Query. While Form1Query is selected, go to the Create menu and select Form to build the basic form.Select the form and switch between the views (Forms, Layout, and Design) to change the properties or the forms appearance as desired.Save the form in the database named Form1Query.STEP 6 Form2: Create a form using the Form Wizard.Invoke the Form Wizard as shown in the tutorials above.Using the Form Wizard, create a form showing instructor information (InstructorID, FirstName, LastName, OfficeNo).Switch between the views (Forms, Layout, and Design) to change the properties or the forms appearance as desired.Save the form in the database named Form2Wizard.STEP 7 Form3: Create a form using a master detail relationship. A master detail relationship is simply a 1:N relationship between two tables. Use subforms to format the form in a split data entry form as shown in Figure 1-9. You may use SQL queries or the wizard or both to create your form and subform.Create a master form showing student information (StudentID, FirstName, LastName, Address, Zip, Major, Status).Create a detail Subform showing StudentID, ClassID, and StudentGrade.For each student displayed, the students classes and grades should be displayed in the detail form.Switch between the views (Forms, Layout, and Design) to change the properties or the forms appearance.Save the form in the database named Form3MaterDetail.STEP 8 When you are done, save the file on your local hard drive and upload it to the Week 7 Course Project Dropbox. Your file should have the following filename format: Lab7FirstInitialLastName.accdb


Comments are closed.