Question: 1-For cutomer table, there should be columns for: ID, first name, last name , Add, city, state and zipcode 2- For product table, there should

1-For cutomer table, there should be columns for: ID, first name, last name , Add, city, state and zipcode

2- For product table, there should columns for: Product ID, Description, price,

3-For Invoice, there should a form that has the Customer and product info info in it.

4- For Invoice Line Item, there should be Line ID, Order ID, Product ID, quantity, and Sales Total.

then Queries Ivoice and Sales and Report Invoice and Sales. in the last export the database.

For data just put anything it is not important to put some exact data. just there should be tables for customer, product, Invoice and Invoice Line Item, and for each of theses shouls a few columns and the data you can just pust anything you want. the main task is to build a database in Microsoft Access that i can submit. thanks

hi, I need a database made in Acees for the following Invoice : I will attach the picture of the assignment too. 1-For cutomer table, there should be columns for: ID, first name, last

there should be one table for each : customer, product, invoice, and invoice line item, and for customer there should be five columns for product there should be three to four columns, for invoice there should be four and for inoice line item there should four to five. then query invoice and sales and also Report invoice and sales as the instruction are written in the picture that i have attached here. and this is due due today, so i kindly request to finished it to for me please.

Category Tables: Create and populate Customer Product Invoice Invoice Line Item Salesperson support Queries Invoice Sales Report Invoice Sales Exported database

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 Databases Questions!