PART 1: PARAMETER QUERYTo identify the number of employees
PART 1: PARAMETER QUERY<br/>To identify the number of employees at
the New Book Sales Corporation, you view the records in the Sales Department table. You decide to add a parameter query where you can enter a title for a group of employees and have all employees in that group displayed in the query results.
-Open the New Book Sales file attached to this document and save the database as New Book Sales Database.
-Cr3ate parameter query for the Sales Department table. adding the Employee ID, Last Name, First Name, and Title fields to the query grid. Since each field in the table will be included in the query, think of a quick way to put each field in the query grid.
-Enter a prompt in the Title field that will prompt the user to enter a title for a group of employees.
-Sort the query in ascending order by the Last Name field, and then add another sort in ascending order to the First Name field.
-Save the query as Qry-Employees by Title.
-Run the parameter query using Sales Rep as the criterion. Adjust the column widths if necessary.
-Save and close the query and the database file and submit to your assignment folder.
PART 2: EMBEDDED MACRO
You have a form that displays purchases made for individual customers. You want to add an embedded macro in the form that will open a second form to display the customer information.
-Open the Pet Supplies file attached to this document. Save the database as Pet Supplies Database.
-Create an embedded macro in the Individual Customer Purchases Form that opens the Customers Form.
-Use the Customer number field as the field that links the two forms in the macro.
-Save the Individual Customer Purchases Form.
-View the Individual Customer Purchases Form in the Form View for customer number 10, and then click on the macro button to test it.
-Close the Customers Form.
-Close the individual Customer Purchases form.
-Save and close the database.
–
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
