Any tips on working with a database that you did not create?

If you don't want to DIY or don't have the time, I can help you. I will
create a map of the tables showing all the tables, the name of each table,
the fields in each table and all the relationships between the table. For
each relationship, I will show the type of relationship. I will then provide
a written description of how the database works.

For every database I create I always do a map of the tables first. I then
keep the map of the tables at my right hand as I develop the database and
later any time I work on the database. You will be able to look at the map
of the and see what forms are needed for the database, what queries can be
created and what reports cane be created.

I provide help with Access applications for a reasonable fee. If you want
help with your database, contact me.

Steve



"KrispyData" wrote in message
...
What is the best way to understand the tables,queries, relationships,etc.
I
am new to Access and taking over an entire database.

These newsgroups are a "volunteer" effort, and the expectation is that you
can ask for and receive free ideas, without being subject to solicitation.

If someone uses these newsgroups to troll for work, ask yourself if you wish
to hire a person who doesn't respect and follow the guidelines laid out for
participation in these groups?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"KrispyData" wrote in message
...
What is the best way to understand the tables,queries, relationships,etc.
I
am new to Access and taking over an entire database.

"Steve" wrote in message
m...

I provide help with Access applications for a reasonable fee. If you want
help with your database, contact me.

Steve

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

A few gems gleaned from the Word New User newsgroup over the Christmas
holidays to show Stevie's "expertise" in Word.


Dec 17, 2008 7:47 pm

Word 2007 ..........
In older versions of Word you could highlght some text then go to Format -
Change Case and change the case of the hoghloghted text. Is this still
available in Word 2007? Where?
Thanks! Steve


Dec 22, 2008 8:22 pm

I am designing a series of paystubs for a client. I start in landscape and
draw a table then add columns and rows to setup labels and their
corresponding value. This all works fine. After a landscape version is
completed, I next need to design a portrait version. Rather than strating
from scratch, I'd like to be able to cut and paste from the landscape
version and design the portrait version.
Steve


Dec 24, 2008, 1:12 PM

How do you protect the document for filling in forms?
Steve


One of my favourites:
Dec 30, 2008 8:07 PM - a reply to stevie
(The original poster asked how to sort a list and stevie offered to create
the OP an Access database)

Steve wrote:
Yes, you are right but a database is the correct tool to use not a
spreadsheet.


Not at all. If it's just a simple list then a spreadsheet is perfectly
adequate...




John... Visio MVP

"Steve" schreef in bericht
m...

I provide help with Access applications for a reasonable fee. If you want
help with your database, contact me.

Steve

Please please please go get lost Steve...

OP, look at this...
http://home.tiscali.nl/arracom/whoissteve.html

Regards, Arno R

Tony Toews [MVP] wrote:
Philip Herlihy wrote:

What is the best way to understand the tables,queries, relationships,etc. I
am new to Access and taking over an entire database.
This can be an absolute disaster - cost me a job once.

Excellent reply. Blogged at
http://msmvps.com/blogs/access/archi...ships-etc.aspx

Tony

Thanks! An expert is someone who has already made most of the available
mistakes. My productivity in that direction is undiminished!

Phil

KrispyData wrote:
What is the best way to understand the tables,queries, relationships,etc. I
am new to Access and taking over an entire database.

Just spotted this, from Microsoft:
http://office.microsoft.com/training...RC011276151033

Phil, London

Bottom line is that it's usually harder to take over somebody else's work
than to create it yourself. So, combining that with being new is a rough
combination. If the old work is junk (for example, with a poor table
structure or no data definitions) then you might not have the ability to
identify it as junk or the confidence to tell everybody else that it is.

Philip Herlihy wrote:

Excellent reply. Blogged at
http://msmvps.com/blogs/access/archi...ships-etc.aspx

Tony

Thanks! An expert is someone who has already made most of the available
mistakes. My productivity in that direction is undiminished!

chuckle

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/