Question: The purpose of this case is to reinforce database concepts that we have acquired through in-class exercises, using Microsoft Access. When you finish Parts 1

The purpose of this case is to reinforce database concepts that we have acquired through in-class exercises, using Microsoft Access. When you finish Parts 1 and 2 of this project you should feel comfortable with Access and the basic concepts of a relational database. Hopefully, this exercise will give you the confidence to build your own relational database for information that is relevant to you! This project will guide you through the process of building a database invoice system. This process includes the following:1. Create five relational tables.2. Establish relationships among the tables. 3. Populate the three master file tables.4. Create an invoice form for sales transactions.5. Use the invoice form to input sales data and thereby populate the two transaction file tables.6. Use the invoice form to display and print invoices. Typographical Conventions

Bold indicates text that you type. Bold is also used to indicate a menu item or check box that needs to be selected. For example, to cut and paste a text passage, you should highlight the text, select Edit Cut from the menu bar, then move your curser to the location for the paste and select Edit Paste.Double question marks (??) mean that you need to figure out for yourself the appropriate entry or action. ". . . etc." is used when a similar process or set of steps has been previously explained. When you see ". . . etc," you should follow the processes described previously for other entries and actions that are similar. For field names in the Access tables, ALLUPPERCASE letters are used for primary keys and MixedCase for nonkey fields.

How can i do this project??

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!