Building a database

  • Thread starter Thread starter no hair via AccessMonster.com
  • Start date Start date
N

no hair via AccessMonster.com

I am fairly new to building databases. I am trying to build a database
based on a
Dispatch manifest which includes the following info:
SHIPPER
CONSIGNEE
LOAD#
BILL#
Pieces Weight
Hot By
Call in Time
Time In
Driver
POD
POD Time

I also have a rate sheet which includes

Rate Per Hundred Weight
Min 100 500 1000 2000 5000

Area A $15.00 $3.60 $3.50 $3.40 $3.30 $2.80
Area B $18.00 $4.65 $4.55 $4.45 $4.20 $4.15
Area C $20.00 $5.05 $4.87 $4.70 $4.35 $3.80
Area D $22.00 $5.40 $5.20 $5.00 $4.60 $4.05



CLE GAS MTH
MAX MAX Max

$81.00 $81.00 $81.00
$108.00 $108.00 $108.00
$221.00 $221.00 $176.00
$221.00 $221.00 $221.00



TO/FROM
Area A Area B Area C Area D
Cleveland Charlotte Belmont Albemarle
Salisbury Concord Gastonia Bessemer City
Statesville Harrisbug Iron Station Kings Mountain
Hickory Lenoir Rock Hill
Mooresville Lincolnton York
Monroe
Morganton
Mt Holly
Pineville




TO/FROM
Area A Area B Area C Area D
Belmont Bessemer City Albemarle Connelly Springs
Gastonia Charlotte Cherryville Lenoir
Lowell Concord Cleveland Matthews
Mt. Holly Dallas Hickory Monroe
Harrisburg Mooresville Morganton
Iron Station Rock Hill
Kings Mountain Salisbury
Lincolnton Shelby
Pineville Statesville
Stanley York



Expedited Or Special Pickup Charge

Area A $15.00 Plus Regular Rate
Area B $20.00
Area C $25.00
Area D $40.00


Standard Rate Mileage

1.30/PER MILE

I would like to create a invoice from the dispatch manifest and rate sheet
and driver reports from the dispatch manifest info to see what they have done
for the week.

I know I have to create tables which one should be tables and which ones
should be queries.

Can someone please help it will be greatly appreciated.

No hair after this project is complete.
 
you need to start by analyzing your business process to identify the
entities (tables) and their characteristics (fields) that you need to track
to support the process. there is no "shortcut" way to do this, and you can't
just jump in and start building the db without doing the analysis first -
well, you can, but you'll have a mess on your hands.

you need to read up on data modeling and normalization, to learn how to
analyze your process and define your tables/relationships. one good text is
Database Design for Mere Mortals by Michael Hernandez. you can also find
links on normalization at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html
beginning with the Database Design 101 and Starting Out links.

once you've defined and built the tables/relationships, you'll be able to
figure out what forms you need, to enter data, and whether you need to base
each form on a table directly, or on a query.

hth
 
thanx tina
you need to start by analyzing your business process to identify the
entities (tables) and their characteristics (fields) that you need to track
to support the process. there is no "shortcut" way to do this, and you can't
just jump in and start building the db without doing the analysis first -
well, you can, but you'll have a mess on your hands.

you need to read up on data modeling and normalization, to learn how to
analyze your process and define your tables/relationships. one good text is
Database Design for Mere Mortals by Michael Hernandez. you can also find
links on normalization at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html
beginning with the Database Design 101 and Starting Out links.

once you've defined and built the tables/relationships, you'll be able to
figure out what forms you need, to enter data, and whether you need to base
each form on a table directly, or on a query.

hth
I am fairly new to building databases. I am trying to build a database
based on a
Click to expand...
[quoted text clipped - 75 lines]
No hair after this project is complete.
Click to expand...
Click to expand...
 
you're welcome :)


no hair via AccessMonster.com said:
thanx tina
you need to start by analyzing your business process to identify the
entities (tables) and their characteristics (fields) that you need to track
to support the process. there is no "shortcut" way to do this, and you can't
just jump in and start building the db without doing the analysis first -
well, you can, but you'll have a mess on your hands.

you need to read up on data modeling and normalization, to learn how to
analyze your process and define your tables/relationships. one good text is
Database Design for Mere Mortals by Michael Hernandez. you can also find
links on normalization at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html
beginning with the Database Design 101 and Starting Out links.

once you've defined and built the tables/relationships, you'll be able to
figure out what forms you need, to enter data, and whether you need to base
each form on a table directly, or on a query.

hth
I am fairly new to building databases. I am trying to build a database
based on a
Click to expand...
[quoted text clipped - 75 lines]
No hair after this project is complete.
Click to expand...
Click to expand...
Click to expand...
 
Nope!

Trolling.

BTW, I see that you are not even an Access MVP. What is your standing to
make your comment?
 
Nope!

Trolling.

BTW, I see that you are not even an Access MVP. What is your standing to
make your comment?
Click to expand...

In agreement with a lot of the rest of us.

John W. Vinson[MVP]
 
Apparently you still have NOT learned... (and I am afraid you never will).
You are just a stubborn idiot.

I *am* considering to start the 'hunt' on all your posts again.
Tell us if that is what you want.
There was NO support for you, remember? ('To all')

Just keep in mind that you can't go on with your add's like you did before,
not now, not in 2 weeks, not in two month's, not in two years .....

Arno R
 
I was not aware that you had to be an Access MVP to comment in these
newsgroups.

These newsgroups are provided by Microsoft to allow users to discuss
Microsoft products. Though there is an occassion Microsoft presence,
Microsoft expects that these newsgroups are self moderated. As a member of
this community, I was just reminding you that these newsgroups were provided
so that users can obtain free help not a means for you to solicit business.
When you post any of your "call me" messages, you need to indicate that
unlike other offers of help, your help comes at a price.

John... Visio MVP
 
I wonder what it is you don't understand about not using these groups as a
forum for soliciting business.
 
Back
Top