What is a good help book/manual?

[Cherri]

Hi,
I am a frequent user of Access and have designed the existing db my company
currently is using. HOWEVER, it is corrupt and very challenging to keep up
with our growing needs and requirements of management. Our IT department is
way to busy to figure out how to make it better soooooooooo...

I need a help manual to guide me thru repairing or basically starting over.
Probably starting over. But I am challenged in that I am an middle aged dog
having a hard time getting past my old incorrect ways.

Does anyone know of a good, user friendly book that can be purchased and
where I can get it?

I need to be able to do things like have customer names with loads of data
applied to that customer and have subsidiaries to those customers with loads
of data for each of those subs and be able to change the parent to someone
else when the existing customer is adopted by a new parent. And keep track
of the data applied to the old customer name....wew That is just the
beginning.

What I would really like to do is hire someone to come in and sit with me
for about 3 months! But reality is that that would be expensive.

Any help is appreciated.
Cherri

 

[strive4peace]

Hi Cherri,

here are 2 of many good books:

Access Developer's Handbook -- Litwin, Getz -- great book
http://www.developershandbook.com/

"Building Microsoft Access Applications" - John Viescas -- anything
written by him is good
http://www.viescas.com/Info/books.htm

I am in the process of developing a Contact database that is almost done
and plan to share it ... might be good for you to get some ideas from.
Email me and I will send it when it is done.

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Aaron Kempf]

move to Access Data Projects

anyone using MDB should be fired

 

[John W. Vinson]

Does anyone know of a good, user friendly book that can be purchased and
where I can get it?

There are lots of books on Access. Learning styles differ, as do backgrounds
and needs - so what might be an ideal book for one person might be a doorstop
for someone else!

If you have a good bookshop with a large technical shelf nearby, it might be
worthwhile to go there. Get a cup of coffee or tea, and pull a stack of Access
books off the shelf (don't spill on them <g>). Leaf through the books; see if
the style is comfortable. Use the Index to look up the answer to some basic
questions - say, "The Not In List Event" or "Normalization".

As Crystal says, the Developers Handbook is terrific - but it's an advanced
book and in no sense a tutorial. John Viescas' _Access <version> Inside Out_
is worth a close look; Running Access is another. If you can find a copy grab
Rebecca Riordan's _Designing Relational Database Systems_ - it's not
specifically about Access but it's a wonderful book on table design.

And... check the references at

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson [MVP]

 

[Aaron Kempf]

I reccomend learning SQL Server

SQL Server is 100 times more relevent than MS Access

I mean.. do you really want to be labelled as 'that Access guy' and get
stuck making $12/hour?

 

[Aaron Kempf]

CORRECTION!

Learn SQL Server, JET Is depecrated and has no future