How to make customer information table with Access database?

Before establishing the database, it is necessary to carry out necessary analysis, establish the relationship model between tables and so on. However, it is not difficult to give a simple example. For example, when you say "save, sell and save", you should at least have a "product information table" (used to record all the product information of the company, such as name, code, quantity, unit price, etc.).

1. "Salesperson Information Table" (used to record the information of the company's salespeople, such as name, code, age, gender, etc. )

2. "Customer Information Table" (used to record the information of customers who have dealings with the company, such as customer company name, company code, contact name, contact telephone number, transaction times, transaction amount, etc. )

3. Sales status table (used to record sales status, such as sales record code, sales personnel code, sales product code, sales product quantity, unit price, sales time, customer company code, etc.). )