Finding Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have started a project where i am modifying an existing database. I am
still learning how to go about this database.

1. I am trying to find a table that is not in the table category. In the
form it is related to this table and when i click to find more details, here
is the information that i get. "you invoked a query builder on the table"

2. what is the best way to learning a existing database.

Thanks a Bunch
 
Hi.
1. I am trying to find a table that is not in the table category.
Click to expand...

Then it's a query, which is based upon one or more tables.
In the
form it is related to this table and when i click to find more details
Click to expand...

Open the form in Design View, then open the Properties dialog window.
Select the "Data" tab, then check the Record Source property. This property
will contain the name of a table or query, which the current form is bound
to, or a SQL statement. However, if this property is blank, then the
current form isn't bound to a record source.
2. what is the best way to learning a existing database.
Click to expand...

The best way is to read the documentation and the code, and then experiment
with a copy of the database to determine how it works. If no documentation
came with the database you inherited, then you can create your own. Please
see the following Web page for former Access MVP Jeff Conrad's CSD Tools:

http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

Always work with a copy of the database, in case something goes wrong.
After documenting the copy of the database, you'll still need to read the
VBA code and comments (if any) and check any macros (if any), and then play
with the copy of the database to see how it works.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Back
Top