Questions from Microsoft Excel and Access for Accounting

Q: a. Create and print a select query that lists the product

a. Create and print a select query that lists the product name, unit cost, supplier name, and supplier contact name for any unit cost between $100 and $400, sorted in descending order by unit cost. Sa...

Q: a. Create and print a select query that lists the product

a. Create and print a select query that lists the product name unit price, unit cost, and unit gross profit for all products. Sorted in descending order by unit gross profit price. (Hint: You’ll need...

Q: a. Create and print a select query that calculates the total

a. Create and print a select query that calculates the total sales value of all Flatwater SUPs in inventory. (Hint: You’ll need to use your completed query from assignment 5b as the source for this qu...

Q: a. Create and run an update query that increases the unit

a. Create and run an update query that increases the unit price for all products by 6 percent. Save this query as Ch 11 Assignment 7a. Create and print an additional query listing the product name and...

Q: Using the Ch12-02 file, modify the Buyers form for

Using the Ch12-02 file, modify the Buyers form for What SUP so that it looks like Figure 12.40. Save this form as Ch 12 Assignment 1, and print record 1 using this form. Figure 12.40:

Q: Modify the Products form by changing the Category ID text box control

Modify the Products form by changing the Category ID text box control to a list box control that lists the choices as A, B, C, D, E, or F. Save the form as Ch 12 Assignment 2. Print the newly created...

Q: Modify the Product form (not the Ch 12 Assignment 2 form

Modify the Product form (not the Ch 12 Assignment 2 form you just created) by changing the Category ID text box control to a combo box control that lists choices of A, B, C, D, E, or F. Save the form...

Q: Sales-people earn a 10 percent commission on the price of

Sales-people earn a 10 percent commission on the price of each sale. Create a new unbound calculated control to compute the possible commission on each product. Modify the Products form (not the Ch 12...

Q: Add a new field (Taxable) to the Product Table.

Add a new field (Taxable) to the Product Table. Make the field a Yes/ No data type. Add this new field to the Products form (not the Ch 12 Assignment 4 form you just created) to the right of the Reord...

Q: Modify the Products form (not the Ch 12 Assignment 5 form

Modify the Products form (not the Ch 12 Assignment 5 form you just created) by changing the Category ID text box control to a special combo box control, listing the choices of Category-ID and Category...