Need help with Table Design

N

nishkrish

Actually i very new to access and trying to learn going to different websites
and trying to get things done. Please help me.

Create database (this is for a telephone company)

i have 4 worksheets with almost same data in worksheets with 1 or 2
different fields in the last

1 current
2 completed
3 deleted
4 macd(make, change, add, and delete)

so i divided my data in different Tables

Customer Table

CustomerID(auto number)
Customer Number(txt) eg msg12345698
Customer Name(text)
Customer City(text)
Customer St(txt)

Employee Tbl
EmpID(auto no)
Emp Fs Name(txt)
Emp Ls Name(txt)

i still have other info. but dont know how to group to create different
Tables for them .

service type
Equipment type


remote worker branch- txt/ yes no
Number virtual tel.ph NOs. - number
site No. - number
Review board Approval - blank or yes no
Contract signed - date
Project Initation- Date
suborder- date
schedule testing- date
conduct v testing- date
checkout -date
acd -date
sch.test turn- date
plns switch- date
transport t- date
conduct company test turn- date
cported -date
maintenance acceptance - date
reason order days- text/ memo
order completed - date
order cancel -date
order disconnect- date

any help on this is greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top