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.
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 databaseStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started