Access Assignment

Business Finance

Data has a way of accumulating in various formats, files, and locations, which makes it hard to actually get any use out of it. In this assignment, datais in a spreadsheet; therefore, import theclient and financial spreadsheets located in the above resources folder into an Access database. Using the data, do the following: Modify the client and financial tables using Design view, create a relationship that enforces referential integrity, create a Client form and insert the following values: B260 as client number, insert your contact information data into the name, street, city, state, and zip fields, enter 1, 200.00 in the current due field and 27 in the business analyst field. Next, create a query for the Client table to display all clients that have a current due amount > 1,000.00. Finally, create a report using the query results.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *