Creating an Access Table

1. Open Microsoft Office and select the Blank Database icon.

2. Access requires you to enter a name for your database before you begin setting it up. Type in a suitable name and press the Create button.

3. From the Database window select the Tables tab and press the New button

4. From the New Table dialogue box select Design View on press OK.

5. Enter your information into the Table Design view window. The Data Type column has a drop-down list for setting the type of data used. For general data just accept the default "Text". For numerical data use the drop-down list to select Number.

6. When you have finished, your Table should contain the names and types of all the fields you intend using. The "Description" field is optional. You should only enter a Description where is helps the user understand the nature of the data in the field. In most cases just leave the Description column blank.

7. When you have finished, save your database by either selecting the Save icon on the Tool Bar, or pressing the Close Box (the Cross) at the top-right of the window. You will be prompted to save the Table you have just created.

Well done. You have just created an Access Table! The next section will show you one way of entering data into your table using a Form.

|Previous Page | Menu | Next | Home Page |