English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I'm creating a database for a beauty and esthetics business. What are some of the tables, forms and queries I should include? Any ideas?

2007-03-21 06:18:27 · 2 answers · asked by Ash 2 in Computers & Internet Programming & Design

2 answers

A product table for all the items you sell. It might include a description, your cost and sale price

A vendor table would tell you who you order which product from.

A customer table if you are going to track customers, and an employee table for employee information.

An invoice table to track what you've billed and what has been paid.

Forms would be data entry for the tables.

Queries are up to you, based on what you need to know from the data. An example would be show all invoices unpaid over 30 days.

2007-03-21 07:31:55 · answer #1 · answered by rod 6 · 0 0

would be costs, timetables for appoiments if you doing such a thing, profit, loss, etc.. wages. stock held, stock needed.
contacts.

2007-03-21 13:21:54 · answer #2 · answered by Paultech 7 · 0 0

fedest.com, questions and answers