(Solved by Humans)-Access Assignment 5 is Tutorial 7, Case Problem 2, P. 438-439,

Question

Access Assignment 5 is Tutorial 7, Case Problem 2, P. 438-439, Steps 1, 3, 4 a.-g., 5 a.-e., 6 (see below for modified steps 1 and 6).

1.open tutoring database

3. create a query that displays, in order, the LastName and FirstName fields from the tblTutor table, the SessioType field from the tblContract table, the FirstNames and the LastName fields from the tblStudent table, and the NumSessions and Cost fields from the tblContract table. sort in ascending order by the first three fields in the query, and then save the query as qryTutorSessions.

4. Create a custome report based on the qryTutorSessions query.?

a. save the report as rptTutorSessions

b. the LastName field is a sort field, and the LastName field ?(from the tblStudent table) is sort field.

c. the SessionType field is a sort field, and the LastName field (from the tblStudent table) is a sort field.

d. hide duplicate values from the SessionType field.

e. use wide margins and set the grid width to 7 inches. size fields as shown and distribute horizontally using spacing to create a balanced look.

f. set the background color for the grouped header and its controls to background 2 in the theme colors.

g. use black font for all the controls, setting the lines thickness to 3pt

5. create a mailing label report according to the following instructions.

a. use the tblStudent table as the record source

b. use Avery C2160 labels, use a 12-point font size and use the other default font and color options

c. for the prototype label, place FirstName, a space, and LastName on the first line; address on the second line; and city, a comma and a space, state, a space, and zip on the third line.

d. sort the Zip and then by LastName, and then enter the report name rptStudentMailingLabels

e. Change the mailing label layout to snaking columns

6. make a backup copy of the database, compact and repair it, and then close the tutoring database.?

Step 1.? Copy the Tutoring database and name Last Name First Name A5 T7 C2, e.g., Adze Joe A5 T7 C2.

Step 6. ?Compact and repair, and close the database. Submit the database in the Access Assignment 5 link in Assignments in Blackboard by the due time/due date.

Note:? Make sure you name all database objects, i.e., queries, as directed in the steps.

Backup the database file on a different storage device after each work session.