Final Project Topics Paper

Final Project Topics
Choose one of the following topics for your Project. Make sure to complete all requirements listed. You may need to do research outside the textbook to learn how to do something new or to compile the data needed for the Project. Do not do just the bare minimum. Get creative and really show off what you have learned. If you select a topic that includes a starting file, you can download this from Blackboard. This assignment is due by 11:59 p.m. (ET) on Friday of Module/Week 8.

1. Automobile Car Comparisons
You want to research various car models. Choose a category, such as a sedan. Use the Internet to research at least 40 new vehicles. Start a new workbook and save it as e04b2cars_LastnameFirstname. Create a source…show more content…
Open the file, click the File tab, click Save Database As, and then type a03b1vacation_LastnameFirstname. Click Save. Replace Your Name in the Customers table and the Branch table with your name. The bank’s employee handbook states that a manager can take two weeks of vacation each year for the first three years of service, and three weeks of vacation after three years of employment. The Branch table stores the start date of each manager. Create a query to determine how many years each manager has worked for the bank: (1) Add a new field to calculate the number of weeks of vacation each manager is eligible to take. (2) Use a nested IIf function to change the weeks of vacation to zero for any employee with a start date later than today. (3) Change the format of each field to the appropriate type, and then add appropriate captions for the calculated fields. (4) Save the query as Vacation. Create another query to summarize each customer’s account balances: (1) List the customer’s last name, first name, and a total of all account balances. (2) Format the query results, and then add appropriate captions. (3) Add the grand total of all accounts to the Datasheet view. (4) Save the query as Customer Balances. Close the query, and then close the database. Submit to…show more content…
Her insurance company asked her to provide an inventory report listing the values of the books she has in stock. Open a04b1books.xlsx. Click the File tab, click Save Database As, and then type a04b1books_LastnameFirstname. Click Save. Create three forms for Authors, Publishers, and Books. Delete any attached subforms. Next, create the inventory report that shows the inventory values for the books on hand. The database contains a query that you can use to create the report. Group the records by publisher name; alphabetize authors by last name and first name within groups. Name the report Bookstore Inventory. In Layout view, create a total value control for each publisher and create a grand total. Resize and reposition the total controls so they are visible and aligned with the correct column. Add Currency formatting where applicable, and then modify column headings as needed. Add your name to the Report using a text box or label. Preview the report and verify that all the columns are correct. Make the needed changes to ensure that the Report will fit on 1 page, with all fields visible. Save and close the report. Compact and Repair the database, and then close the database and close Access. Submit your file to