New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
Yup it sure does!
Thx
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
Your 1st post has helped me a lot, thanks.
I so know what you mean by the 1st post...same thing here...my pc doesn't work...um ok...I'd hate to do that same thing and look like the total n00b I'd...
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
DC,
Glad I could be of help.
Before posting in those forums, make sure you think through completely what you need the database to do today, and in the future so that you can get the design...
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
You will need to add 3 tables.
First table call it phoneNumbers with fields (phoneID int, phoneNumber varchar or long)
The two other tables will be "bridge" tables:
siteFaxNumbers (siteID,...
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
Yes, a brand table would be helpful for your requirement. It can have two fields brandid(number datatype) and brandname(string) which will have values like HP, Dell, IBM and so on.
Each component...
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
I've uploaded a zip'd copy of my access file...please check it out and comment.
Thanks!
MS Access has a template for Asset Inventory...I looked at it, but it's more convoluted then what I...
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
Weird issue...In my Site Table (table for where each of our offices are) I want to track their phone numbers
We have several lines for each location...Main # then the roll-over phone numbers, and...
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
I wonder if I need a "Brand" table.
I have Dell Desktops, Servers, Printers, Servers.
So the same brand will be on several tables
TblDesktop, Brand
TblLaptop, Brand
TblServer, Brand
So...
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
Sometimes I think I have or am trying to make too many tables...but you make sense to break it up. Thanks...I've got more to ponder:nod:
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
:bump:
Please see the now attached file in the op.
Thanks.
-dc
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
Few suggestions for your question.
A database contains few tables which in turn(typically) have a primary key. For you, the service tag will be primary key for all components(desktop, laptop,...
New MS Access Dbase from Scratch...ERD Help Needed Access File Attached
Expired
Thread created 11-05-2010 by DC
0 Score
11 Replies
1,192 Views
Some,
Thanks for the reply.
In previous semesters, I've taken PSQL and then later on Access2K7.
Problem is that I've forgotten a bit of it as our main estimating "program" is a macro that runs...