Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

These Microsoft Access exercises involve modifying existing files

/in /by

These Microsoft Access exercises involve modifying existing files
(New Book Sales.accdb and Pet Supplies.accdb). A copy of the files are included as an attachment to this assignment. You must (1) open the file, (2) save the file, (3) modify the file based on the instructions, (4) save your work, and (5) submit the completed files to your Assignments Folder in our CMST 303 LEO Classroom.
PARAMETER QUERY
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.
-Create a 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. 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, and the individual Customer Purchases form.
-Save and close the database and submit to your assignment folder.

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"