can i start with a form

B

brady

I have already started my form first before my table...is there a way to make
a table out of this form to store the information? My problem is i can't add
a new record.
 
J

Jeff Boyce

Brady

Access is a relational database. The traditional way to start building a
database is to focus on the data ... and this means tables.

If you start with a form, you run the risk of trying to make a table fit the
form. This may or may not result in a good design for the table.

Before you proceed, shut off the computer and use paper/pencil to sketch out
your entities (things about which you wish to store data and query), and how
they relate to each other. Reading up on relational database design and
normalization will help.

If you only need a form and a way to store the data from that one form,
consider using Excel!

Good luck

Jeff Boyce
<Access MVP>
 
D

Douglas J. Steele

Forms do not store data: only tables do that. You'll have to create a table
and bind it to your form.
 
S

Santara

Brady,

When you create a database, the Tables are the most importpant part. The
tables are where you store your date. You create the tables first, then
create the FORM based on the tables.

If there is no table created, working backward is not possible. That is why
you can not add a new record; there is no place for the data to be stored.

You might want to learn a few fundamentals before you begin creating tables.

The following address will take you to a nice tutorial that starts with an
introduction to Access and moves forward from there:

http://www.functionx.com/access/

Good Luck!

Santara
 
Top