How to Access Database Design

The core of all Access databases is the table. The information you enter into the table is stored in individual records. These records are shown as rows in your database table. Each column is a field and contains similar information, such as last names or addresses. Access reports, forms and queries are all optional ways to enhance the information stored in this table. All you need to do to design a simple Access database is create a table to store your information.

• 1

  Write down a list of the information you are going to need in your Access database. Examples include names, addresses, employee ID numbers and birthdays.

• 2

  Open the "Start" menu on your computer. Type "Access" into the box. Click the link to open Microsoft Access. Choose "Blank Database" from the "Available Templates." Enter a file name in the bottom-right corner. Choose your save location. Click "Create." Your database opens with an empty table.

• 3

  Click "View" on the top menu. Choose "Design View" from the list. A box appears prompting you to save your table. Enter a table name and click "OK."

• 4

  Type a name for each field in the "Field Names" box. These field names are the headers for the information you are going to store in this database, such as names, addresses and identification numbers.

• 5

  Choose a "Data Type" from the list of options. This number corresponds with the data that you store in the field. Data types include text, numbers, currency, hyperlinks and memo fields.

• 6

  Choose a primary key. This field should contain information that is unique to each record, such as a Social Security number, employee ID number or file number. Select the entire row by clicking the box to the left of the field name. Click the "Primary Key" button on the top ribbon.

• 7

  Click "File" on the top menu. Choose "Save" from the list of options. Click "View" on the top ribbon. Choose "Datasheet View" from the list of options. Start entering your information into your new database table.