Questions from Microsoft Excel and Access for Accounting


Q: Note: You must have completed Case 2 in the previous chapter

Note: You must have completed Case 2 in the previous chapter in order to continue working on this case. In Chapter 9 you created a database for the Wine Depot consisting of a Wine Products table, a Wi...

See Answer

Q: In Chapter 9 you created a database for the Snick’s Board Shop

In Chapter 9 you created a database for the Snick’s Board Shop consisting of a Products table, a Category table, and a Manufacturer table. You also created an initial query, form, an...

See Answer

Q: In Chapter 9, you created a database for Rosey’s Roses consisting

In Chapter 9, you created a database for Rosey’s Roses consisting of a Product table, a Type table, and a Grower table. You also created an initial query, form, and report. You have now been asked to...

See Answer

Q: In the last chapter you added and modified some tables for Kelly’s

In the last chapter you added and modified some tables for Kelly’s Boutique. She would now like you to create, run, and print some select, parameter, and action queries. Make the fol...

See Answer

Q: What SUP Partial Year Sum of the Year’s Digits Depreciation for Asset

What SUP Partial Year Sum of the Year’s Digits Depreciation for Asset 1004 Create a new worksheet to calculate depreciation for a table purchased on August 1, 2017, for $95,000. It has an estimated sa...

See Answer

Q: In the last chapter you modified some tables for the Wine Depot

In the last chapter you modified some tables for the Wine Depot. Now Barbara would like you to help her create some queries to extract some information from the database. Make the following changes fo...

See Answer

Q: You must have completed Case 3 in the previous chapter in order

You must have completed Case 3 in the previous chapter in order to continue working on this case. In the last chapter you modified some tables for the Snick’s Board Shop. Now Caitlin would like you to...

See Answer

Q: Note: You must have completed Case 4 in the previous chapter

Note: You must have completed Case 4 in the previous chapter in order to continue working on this case. In the last chapter, you modified some tables for Rosey’s Roses. Now the compa...

See Answer

Q: You must have completed Case 1 in the previous chapter in order

You must have completed Case 1 in the previous chapter in order to continue working on this case. In the last chapter you added and modified some queries for Kelly’s Boutique. She wo...

See Answer

Q: Note: You must have completed Case 2 in the previous chapter

Note: You must have completed Case 2 in the previous chapter in order to continue working on this case. In the last chapter you modified some queries for the Wine Depot. Now Barbara would like you to...

See Answer