Creating a database in access 2002

[johncossiboom]

what is the best step by step procees to create a
database with forms to enter data and reports it will
probably be elaborate i need my references to be on line
or html files i can print



Thanks John

 

[John Vinson]

what is the best step by step procees to create a
database with forms to enter data and reports it will
probably be elaborate i need my references to be on line
or html files i can print



Thanks John

I'd suggest you purchase one of the many good books on the subject. I
like John Viescas' _Running Microsoft Access_ but there are many more.

 

[Guest]

-----Original Message-----


I'd suggest you purchase one of the many good books on the subject. I
like John Viescas' _Running Microsoft Access_ but there are many more.



.

Thank you Mr. Vinson for you reply but I am sorry I
cannot and do not have access to get any book
My mobility is very limited so is there any free online
service or documentation ?

Thanks again sir.


John

 

[Guest]

-----Original Message-----


Thank you Mr. Vinson for you reply but I am sorry I
cannot and do not have access to get any book
My mobility is very limited so is there any free online
service or documentation ?

Thanks again sir.


John



.
Thank you Mr. Vinson for you reply but I am sorry I

cannot and do not have access to get any book
My mobility is very limited so is there any free online
service or documentation ? Its more about money... Also
do I need Access 2002 devolpers edition?? How do I tell
what I have? Its Office Xp 2002 Professional with Front
Page....

Thanks again sir.

 

[John Vinson]

Thank you Mr. Vinson for you reply but I am sorry I
cannot and do not have access to get any book
My mobility is very limited so is there any free online
service or documentation ? Its more about money... Also
do I need Access 2002 devolpers edition?? How do I tell
what I have? Its Office Xp 2002 Professional with Front
Page....

I'm not sure if I posted this or not... but take a look at

http://www.educationonlineforcomputers.com/links/Free-Microsoft-Access-Training/

You will only need the Developers Edition (now known as Visual Studio
Developer Tools) if you want to create runtime versions for
distribution to people who do not have Access installed on their
computer. If you have XP Pro you have all you need to create an Access
database, reports, forms, queries, etc. for your own use or for the
use of anyone who has Access2002 installed on their computer.

 

[Guest]

-----Original Message-----

I'm not sure if I posted this or not... but take a look at
Microsoft-Access-Training/

You will only need the Developers Edition (now known as Visual Studio
Developer Tools) if you want to create runtime versions for
distribution to people who do not have Access installed on their
computer. If you have XP Pro you have all you need to create an Access
database, reports, forms, queries, etc. for your own use or for the
use of anyone who has Access2002 installed on their computer.


.
Thank you again Mr. Vinson...I have a few more questons

I have been studying relational database design for
access 2002 and its sinking in but I only have one table
and a bunch of fields I get no help from the table or
performance analyzer..I know i need to create a primary
key and break some of these fields into smaller
tables ...I am not sure how to....am I allowed to email
you my existing table that i have created and also a copy
of the 3 forms i have that i am creating from .... there
are alot of field on these 3 forms....

Hope to hear from you soon thanks again
John Cossiboom

 

[Guest]

-----Original Message-----

-----Original Message-----
use
or for the
I have been studying relational database design for
access 2002 and its sinking in but I only have one table
and a bunch of fields I get no help from the table or
performance analyzer..I know i need to create a primary
key and break some of these fields into smaller
tables ...I am not sure how to....am I allowed to email
you my existing table that i have created and also a copy
of the 3 forms i have that i am creating from .... there
are alot of field on these 3 forms....

Hope to hear from you soon thanks again
John Cossiboom
.
Thank you again Mr. Vinson...I have a few more questons

I have been studying relational database design for
access 2002 and its sinking in but I only have one table
and a bunch of fields I get no help from the table or
performance analyzer..I know i need to create a primary
key and break some of these fields into smaller
tables ...I am not sure how to....am I allowed to email
you my existing table that i have created and also a copy
of the 3 forms i have that i am creating from .... there
are alot of field on these 3 forms....

Hope to hear from you soon thanks again
John Cossiboom

 

[John Vinson]

Thank you again Mr. Vinson...I have a few more questons
I have been studying relational database design for
access 2002 and its sinking in but I only have one table
and a bunch of fields I get no help from the table or
performance analyzer..I know i need to create a primary
key and break some of these fields into smaller
tables ...I am not sure how to....am I allowed to email
you my existing table that i have created and also a copy
of the 3 forms i have that i am creating from .... there
are alot of field on these 3 forms....

Hope to hear from you soon thanks again
John Cossiboom

I'm sorry - I'm a self-employed consultant, volunteering (what's
become a bit too much of) my time on these newsgroups. I'd only be
able to whip your database into shape on a for-fee consulting basis.

Perhaps what you could do is to start a new thread in this newsgroup;
describe the nature of the data you are trying to manage and perhaps
the list of fields that you currently have (with explanations if the
fieldnames are not self-explanatory). Just to reemphasize: starting
your design with Forms IS A BAD APPROACH, and will pretty much
guarantee a non-normalized design! Design your table logic *first*,
and then design forms to mediate between that logical structure and
the visual needs of your users.

In a nutshell, each Table should contain the information for one type
of Entity - real-life person, thing, or event. If your current single
table contains (say) information about widgets, and experiments on
widgets, and results of those experiments you might have three tables:
widgets, experiments, and results.

 

[Guest]

-----Original Message-----


I'm sorry - I'm a self-employed consultant, volunteering (what's
become a bit too much of) my time on these newsgroups. I'd only be
able to whip your database into shape on a for-fee consulting basis.

Perhaps what you could do is to start a new thread in this newsgroup;
describe the nature of the data you are trying to manage and perhaps
the list of fields that you currently have (with explanations if the
fieldnames are not self-explanatory). Just to reemphasize: starting
your design with Forms IS A BAD APPROACH, and will pretty much
guarantee a non-normalized design! Design your table logic *first*,
and then design forms to mediate between that logical structure and
the visual needs of your users.

In a nutshell, each Table should contain the information for one type
of Entity - real-life person, thing, or event. If your current single
table contains (say) information about widgets, and experiments on
widgets, and results of those experiments you might have three tables:
widgets, experiments, and results.



.
Okay can you give me a email to email you my file and

get a quote and also just how much free advice I can
get...i posted a new string ....thanks again

John