batabase

  • Thread starter Thread starter rkrick99
  • Start date Start date
R

rkrick99

I would like to set up a database. I am new to access so not to sure about
how to get this to work. I do a lot of computer repair work for freinds and
family. I would like to make a database to keep track of poeple, their
computers, and work i have done to each computer.
I been through some of the sample databases and like the report features. I
would like that when you look up a person it lists there computers and under
that it lists a work order of some kind so i can track time, problem, what i
did to fix it. I have an idea of what i want but when i tried to get it to
work it failed.
I not sure what to do or how to do it. I have a very basic knowledge so help
will need to so i can under stand it
 
Richard

I usually advise folks just starting out with Access that they will be
facing THREE learning curves, not one.

First, MS Access is a relational database, and works best when you feed it
well-normalized data. If "normalized" and "relational" are not familiar
terms, spend some time brushing up on them.

Second, MS Access is NOT a spreadsheet or a word processing application.
Those are more like bookcases ... and most folks have real world experience
moving numbers and words around, just like they have experience moving books
onto and off of bookcases. Access is like a powersaw -- you use it to BUILD
bookcases. There are tricks to learn in how Access does things.

Finally, the way Access presents itself to most users is via a graphical
user interface. If you don't have experience in designing user interfaces,
plan to spend more time here.

(There is a fourth learning curve, assumed ... you definitely benefit from
having experience developing applications. If you don't have this kind of
experience, plan to "learn on the job"!)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
rkrick99 said:
I would like to set up a database. I am new to access so not to sure about
how to get this to work. I do a lot of computer repair work for freinds and
family. I would like to make a database to keep track of poeple, their
computers, and work i have done to each computer.
I been through some of the sample databases and like the report features. I
would like that when you look up a person it lists there computers and under
that it lists a work order of some kind so i can track time, problem, what i
did to fix it. I have an idea of what i want but when i tried to get it to
work it failed.
I not sure what to do or how to do it. I have a very basic knowledge so help
will need to so i can under stand it
Click to expand...

You don't say which version but a google on Access (version number)
tutorial should get you a multitude of choices. should give you a
good start so you can come back here and ask specific questions.
Below is a link to an Access 2000 tutorial. Fundamentals are the
same but Access 2007's interface is quite different.

Just one example
http://www.google.com/search?hl=en&q=tutorial+Access+database



gls858
 
I do have an access 2000 book i have been working through. I has been some
what helpful. It goes through a sample database and helps you add and change
the data. It has the basics in it. This is what i am trying to do.
I setup a Contacts Table it has all your basic name address phone number ect.
I set up a Computer Table it has basic model serial numbers cpu memery
hrddive OS
I want to set up a third table For Work Orders so i can keep track of who
and what computers i have fixed.
Now the fun part, I like the templete Contact Management that comes with
Access
I would like to remove the Call Features in it and replace them with My two
other tables. I have tried to do this before to try to make it easier for me.
My problem is that with that templete when you look at the forms for
contacts there are two buttons at the bottom. I wanted to use them but there
are certain lines of code for the database that were i run into my problems.
I have no programing skills what so ever.
 
"Steve"

These newsgroups are not designed to be your personal "hunting" ground. Why
do you continue soliciting work here when so many people remind you that the
newsgroup etiquette precludes do that?

Folks offer free assistance here.

Do you have any free suggestions to offer this poster?

Jeff Boyce
Microsoft Office/Access MVP
 
Steve said:
Rather than go through the frustration, I can build the database for you
for a very modest fee. I provide help with Access, Excel and Word
applications for a very reasonable fee. If you would like my help, contact
me and I will be glad to give you a quote and you can decide from there.

Steve
Click to expand...


Instead of going through the frustration of learning Access, go through the
frustration of being ripped off.

These newsgroups are provided by Microsoft for FREE peer to peer support.
The type of help offered by steve is very questionablr.

John... Visio MVP
 
Ignoring the issue of your behavior in the free newsgroups?

Jeff

Steve said:
Your first response certainly offered no technical help to the OP! This
post of yours offered no help! How is the OP suppose to create his
"batabase" with what you gave him?

At least I gave him an option if he so desires. He can make the decision.
You don't need to make the decision for him!

Steve
Click to expand...
 
Back
Top