New User to Access

  • Thread starter Thread starter Srinivasulu B
  • Start date Start date
S

Srinivasulu B

I am new user to Access
I have been working with FoxPro from ver 1 onwards (say 1990)
My client wants to develop a database which contains name, address and
person will be in one more categories.
The job requires pulling out records and create another table matching the
conditions.
Now this table is to be used to prepare labels (for mailing)
If this has to be done in Fox Pro, I can do it in just 30 mts, (data entry
time not included, of course)
Can any one help me as how to go about it?
Should I do the job inFox Pro and keep imorting or start off in Access
itself
Srinivasulu B
 
Hi Srinivasulu,

If you can do this task in 30 minutes, using FoxPro, then you should be able
to do the same task in Access, in 15 minutes. Or maybe a bit more if it is
your first time using Access, but my point being that you likely understand
basic principles, such as proper database normalization, creating queries,
etc. There is a label wizard that you can use, once you have your tables
created.

Or, you can try downloading one of these templates
http://office.microsoft.com/en-us/templates/results.aspx?qu=template&sc=4&av=ZAC

I haven't looked yet, but perhaps the Personal Address Book database pretty
much has what you need.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Thank you very much for the moral support...Mr. Tom Wickerath
Srinivasulu B
=====================
 
Hi Srinivasulu,

If you have specific questions, please post back with enough detail. It
would be helpful to identify which version of Access that you are using.
Also, you should consider making sure that your version of Access is fully
patched. Use this KB article as a guide:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528

Within this article, follow the links that read:

Verify that the latest operating system service pack is installed
Verify that the latest Microsoft Jet service pack is installed
Verify that the latest service pack for your version of Office is
installed

Also, make sure that the latest MDAC (Microsoft Data Access Components)
files installed on all PCs:

http://www.microsoft.com/downloads/...FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c

Doing these things will help ensure that your time spent working with Access
is productive, so that you are not battling some problem that has already
been fixed with a service pack.

You might want to take a quick look at a Word document that I make
available, called "Access Links.doc":

http://home.comcast.net/~tutorme2/samples/accesslinks.zip

There are two hyperlinks shown in red font, on page 4, that are worth
following for setting up all PC's the first time. This will help you avoid
duplicate indexes, and ensure that you have Require Variable Declaration
enabled. Also recommend disabling the two Compile on Demand options.

Good luck with your project.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Oh!
I can't thank you enough...so much info ...in just one shot
Thanks a lot.
I will surely get back as and when I hit a blank wall
Srinivasulu
 
My client wants to develop a database which contains name, address and
person will be in one more categories.
The job requires pulling out records and create another table matching the
conditions.
Click to expand...

Do follow Tom's excellent advice and links.

One warning - in FoxPro it's routine to create a new table with a subset of
the data, for generating reports or labels.

This *can* also be done in Access, but it's almost never either necessary nor
the right way to do so!

You can instead create a Query (like a View) which selects data by matching on
conditions ("criteria" in Access jargon); your report (the labels) can be
based directly on this query. It's not necessary to create a new table.

John W. Vinson [MVP]
 
Thanks....John
Srinivasulu B
John W. Vinson said:
Do follow Tom's excellent advice and links.

One warning - in FoxPro it's routine to create a new table with a subset
of
the data, for generating reports or labels.

This *can* also be done in Access, but it's almost never either necessary
nor
the right way to do so!

You can instead create a Query (like a View) which selects data by
matching on
conditions ("criteria" in Access jargon); your report (the labels) can be
based directly on this query. It's not necessary to create a new table.

John W. Vinson [MVP]
Click to expand...
 
Back
Top