I know nothing about Access

F

Frederic Elias

Hello,

I know almost nothing about Access.
However, i have been put in charge of designing a ratter complex database,
which will need to have at least the following features:
- merging data from the database into dedicated word templates (mail merge),
from within Access on the click of a button

Is all of this done easily with MS Access XP?

Actually, a pretty big database designed in Foxpro already exists, and my
job is to replace it with a more up-to-date version thereof (the version we
have is all bugged-up and is unpredictable at times). During the transfer
process from the old to the new database system, i'm going to have to import
the old data files (DBF files) and convert them in "Access" format. Is that
done easily, or are annoying problems very likely to occur?

Also, can anyone recommend a comprehensive and educational (rather than a
reference) book on Access ?

Thanks
Fred.
 
G

GVaught

What I would start doing is reading up on these topics.
Normalization
Relationships
Referential Integrity
Data Integrity

These are essential for developing any database regardless of importing
table or creating them from scratch.

Depending on the version of FoxPro you were using depends on how much of a
problem you may have. The tables should import rather easily. The part that
may/will be lost and have to be regained is indexing and setting of primary
keys and relationships. It also may be necessary to normalize the imported
tables.

I used a book called the Access Bible. It was quite comprehensive and it ran
you through creating a Vet database, which seemed to cover the basics to the
expert. Regardless of the database used, this should give you great
education and understanding of Access.
 
R

Ron Hinds

Frederic Elias said:
Hello,

I know almost nothing about Access.
However, i have been put in charge of designing a ratter complex database,
which will need to have at least the following features:
- merging data from the database into dedicated word templates (mail merge),
from within Access on the click of a button

Is all of this done easily with MS Access XP?

Actually, a pretty big database designed in Foxpro already exists, and my
job is to replace it with a more up-to-date version thereof (the version we
have is all bugged-up and is unpredictable at times). During the transfer
process from the old to the new database system, i'm going to have to import
the old data files (DBF files) and convert them in "Access" format. Is that
done easily, or are annoying problems very likely to occur?

I had to do this once and I found a FoxPro to Access converter on the
internet. It worked quite well (using Visual FoxPro). Do a Google search. If
you can't find it I still have it and will send it to you. eMail me at ron -
at - garageiq - dot - com (replace " - at - " with "@" and " - dot - " with
".")
Also, can anyone recommend a comprehensive and educational (rather than a
reference) book on Access ?

From Que Publishing: Using Microsoft Access 2002 by Roger Jennings
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top