Data for Access

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

Guest

I want to build a simple database incorporating user contact details,
together with subjects of interest, etc. What is the best programme to do
this in, to enable the data to be retrieved as mailing labels, tables, etc.,
in Access?

All Access training refers to use of data, but doesn't explain where to
enter the data initially.

Sue - Age Concern
 
Hi Sue,
I want to build a simple database incorporating user contact details,
together with subjects of interest, etc. What is the best programme to do
this in, to enable the data to be retrieved as mailing labels, tables, etc.,
in Access?

All Access training refers to use of data, but doesn't explain where to
enter the data initially.
Click to expand...

Huh? You must be taking some rather unorthodox training courses, then.
Most Access classes state right up front that data in Access files
reside in separate storage containers called tables. It sounds like
you're unfamiliar with basic relational architecture. I suggest that you
get a hold of some good reference material and familiarize yourself with
how Access defines, sorts, manages, and displays the information in a
database. Some suggestions:

- Start at the very beginning. Most versions of Access have a decent
(not fantastic, but decent) reference source already included with the
software. Click on the Help toolbar command, select the Contents tab,
and start with the very first topic in the very first chapter,
"Databases: What They Are and How They Work."

- Among hard-copy references, my personal favorite is John Viescas'
"Running Microsoft Access xx." Clear, mostly jargon-free explanations
that can take you from the very beginning all the way up to advanced
programming.

- Another good place to start for newbies is the "...For Dummies"
series.

- The Microsoft Support pages have lots of online resources for Access.
Start at http://support.microsoft.com/kb/289533

Hope this helps,

LeAnne
 
hi,
You enter data initially one of two ways.
you can import it.
in the database window, click the table tab. click the new
button. click import table. usually people inter the data
in to excel or similar.
the other way is to creat a table and enter the data
directly into the table.
in the database window, click the table tab. click the new
button. click design view if you know what data you will
be storing. enter the field, set data types ect.
if you are not sure you might want to click on the table
wizard. lot of options there.
You can then create a form and bind it to the table then
enter data into the form.
hope this helps
 
Back
Top