Add an Attachment field named ProductFiles to the end of the tblProduct table, using a Caption property setting of Product Files. Use the Simple Query Wizard to create a query named qryInvoiceValue that displays all fields from the tblInvoice table for the Transmitted field, display only the version of the field that uses the Value property, and change its Caption property setting to Transmitted. Save the table, and then add the following values to the field in the table datasheet: for record 4-Email and USPS, for record 8-Courier, and for record 12-Fax and USPS. Add a multivalued field to the end of the tblInvoice table, defining permitted values of Courier, Email, Fax, and USPS, and naming the field Transmitted. Run the query, save the query as qryProductSubqueryInvoice, and then close the query.6. Paste the SQL code that you copied in the previous step from qryProductSubquery, and add code that uses the existing code as a subquery and selects all fields from the tblInvoice table where the SupplierID is in the tblInvoice table. (Hint: Do not show the Weight field.) Switch to SQL view, copy the SQL code, and save the qryProductSubquery query.5. Create a query named qryProductSubquery that selects the SupplierID field from the tblProduct table for all products that weigh 50 pounds or more. Apply the filter, save the filter as a query named qryStateSuppliesFilter, clear all filters, and then close the table.4. Use Filter By Form with the tblSupplier table to select all records in which the state is FL or SC and the category is Supplies. Open the tblProduct table datasheet, use an AutoFilter to filter records using the TempControlled field for values of Yes and Sterile field for values of Yes, and then save and close the table.3. Open the Product database you worked with in the previous three modules.2. To meet this request, complete the following steps:1. from previous module), Support_AC_12_Ads.accdb, Support_AC_12_Autoclave_Specification_Sheet.pdf, and Support_AC_12_Autoclave.xlsxDonna asks you to complete your work with the user interface for the Product database. By New Perspectives Microsoft Office 365 & Access 2019 Comprehensive (1st Edition) Edit edition Solutions for Chapter 12.2 Problem 1RA: Data Files needed for the Review Assignments: Product.accdb (cont.
0 kommentar(er)
