Setting Up A Database

[Guest]

I'm just starting out with Access.

I would like to set-up a database that has 5 fields - Name, Priority,
Status, Topic, and Notes.

The Name will be no more than 6 characters. Priority will be 1,2,or 3.
Status will be Open or Closed. Topic will be no longer than 20 characters.
Notes I would like to be able to have unlimited characters.

I would like to have a simple "input" screen.

Can someone walk me through the steps to do this ?

Thank you in advance.

 

[Guest]

Create a table in design mode. Add fields, naming them with the five names.
Make them the following data types and sizes:

Field Name Data Type Field Size
Name Text 6
Priority Number Integer
Status Yes/No
Topic Text 20
Notes Memo

You set the field size in ther bottom pane of the table designer. Also, When
you have the name field selected, select Edit, Primary Key. This sets this
field as the primary key, meaning you cannot have duplicate value here in
your table.

Save the table.

Go to the Forms pane in the database window and double-click "Create Form by
Using Wizard. This wizard will step you through the process. You'll have to
play with different settings to get it to look and behave the way you want.
Once it's done, it will save a form object to the form pane. From here, you
can open it to use it or make design changes.

Barry

 

[tina]

Barry's direction is good, but recommend you don't use the word "Name" as a
field name, as it's an Access reserved word. you can add a prefix or suffix
to "Name", and use that, for instance "SubjectName".

hth