Creating a database in access 2002

  • Thread starter Thread starter Anon
  • Start date Start date
A

Anon

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
 
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.
 
-----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
 
-----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.
 
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.
 
>-----Original Message-----
>On Tue, 3 Feb 2004 11:08:39 -0800,




Front

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.

> John W. Vinson[MVP]
> Come for live chats every Tuesday and Thursday

>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
 
>-----Original Message-----

Visual Studio

on their

create an Access
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
>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
 
>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

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.
 
>-----Original Message-----
>On Mon, 9 Feb 2004 08:14:54 -0800,
>
>>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

I'm sorry - I'm a self-employed consultant, volunteering (what's
>become a bit too much of) my time on these newsgroups.[/QUOTE]
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.

> John W. Vinson[MVP]
> Come for live chats every Tuesday and Thursday

>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
 
Back
Top