|
|
|
New to Access |
|---|
| message from =?Utf-8?B?RG9ubmll?= on 28 May 2004 |
Hey all.I am building a dispatch database project in Access, that will hold all of our customer records, their dispatch history, their HVAC equipment information, etc... Basically, it is going to be a large relational database with probably four or five tables. We know what we want it to do, its just up to me to get it designed and functional. My problem has been that I cannot find any good information on building the type of database that I want to build. The books that I have dont really go too in depth about designing forms that will be able to have sort of dynamic queries. For example, I want to have a field on one of the forms where you could enter a customers name, address, or phone number, and then do a search to retrieve that customers dispatch history and equipment information. I also need to find a way to e able to enter a dispatch into a form, and have that information go into that customers dispatch history, as well as display the dispatch on a schedule board for the technician that will be doing the service call. These are only a few of the problems that I have not been able to find info about. I know what we are trying to do is possible with Access. Can anyone point me to a good source of online information, tutorials, etc? Also, is there a really good sort of all in one "teach Yourself Access" book? Like a Sam's book? Thanks for your time. Donnie
|
| =?Utf-8?B?VGFzaGE=?= replied to =?Utf-8?B?RG9ubmll?= on 28 May 2004 |
This is going to sound really crazy but if you have a college near by check out the student book store in the computer science area. I had multiple database design classes with one of them being on nothing but MS Access. The book I had was geared to in depth MS Access design and was about 2 inches thick. I still use it as a reference. (I graduated college 2 yrs ago.)
Also have you looked at Access for Dummies.
|
| =?Utf-8?B?RG9ubmll?= replied to =?Utf-8?B?VGFzaGE=?= on 28 May 2004 |
I am using Access XP. I will look into those books, thanks for the tips. I have had some good Que books in the past, and I had forgot about them. I have tried the "Access For Dummies", it just doesnt really get into the things I need to do.
|
| John Vinson replied to =?Utf-8?B?RG9ubmll?= on 29 May 2004 |
It's actually quite a good book FOR WHAT IT TRIES TO DO - which (as I
read it) is primarily for people *using existing Access databases*. It
isn't really designed to help you design and build a new database.
As noted elsethread, there are several - I'd say many - good books
which do this. I'd suggest finding a good bookstore (at a university,
or my nearby Borders Books has a good tech section), pull a dozen
Access books off the shelf, and see which fit your background, your
learning style, and needs. Bear in mind that NO book is going to give
you your application worked out; the examples are just that, learning
tools for "how do I accomplish this kind of task".
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| Ron Hinds replied to =?Utf-8?B?RG9ubmll?= on 28 May 2004 |
Using Access 2002 by Roger Jennings - Que Publishing
http://www.quepublishing.com
"Donnie" <anonymous@discussions.microsoft.com> wrote in message
news:01A5DD72-7F38-46B5-8FB8-7405867EF3FE@microsoft.com...
hold all of our customer records, their dispatch history, their HVAC
equipment information, etc... Basically, it is going to be a large
relational database with probably four or five tables. We know what we want
it to do, its just up to me to get it designed and functional. My problem
has been that I cannot find any good information on building the type of
database that I want to build. The books that I have dont really go too in
depth about designing forms that will be able to have sort of dynamic
queries. For example, I want to have a field on one of the forms where you
could enter a customers name, address, or phone number, and then do a search
to retrieve that customers dispatch history and equipment information. I
also need to find a way to e able to enter a dispatch into a form, and have
that information go into that customers dispatch history, as well as display
the dispatch on a schedule board for the technician that will be doing the
service call. These are only a few of the problems that I have not been able
to find info about. I know what we are trying to do is possible with Access.
Can anyone point me to a good source of online information, tutorials, etc?
Also, is there a really good sort of all in one "teach Yourself Access"
book? Like a Sam's book? Thanks for your time. Donnie
|
|
