Home > Microsoft Office > Access > Add Information - Access
Add Information - Access
How to add information in the form of a table to a database that you just created. This example uses a blank database as opposed to a database from a template. The process is the same, however the screenshots may be different. This works In Access 2016, 2013, and 2010.
Quick links to sections in this article:
Create Table
Step 1:
Open the newly created database in Access. Step 2:
Click the Home tab. Select the View dropdown list on the far left side of the ribbon.
Step 3:
Choose Design View.
 Step 4:
The table will appear in Design View. The Field Name is the heading of the column. Name your fields accordingly.
 Step 5:
Select the Data Type for each field, based on the type of data you will be entering in that field.
 Step 6:
Enter field descriptions if you would like.
 Step 7:
To view the table and begin adding data, select the Home tab and click the View dropdown list. Choose Datasheet View, which was the original view of this database.
 Step 8:
Click Yes to save the table.
 Step 9:
The table will open with the field names as the column headings. You can begin to enter data in the table.
Edit Table
Step 1:
Open your database containing your table in Access.
Step 2:
Adjust the width of the columns by placing your cursor between two field names on the table. Click and drag to the desired width.
 Step 3:
To edit a field name, right click on the heading and select Rename Field.
 Step 4:
To add a new field, go back into Design View and enter the field name, data type, and description.
| Author: karperc | Last Updated: 3/11/2020 10:25 AM | Page Views: 3074 |
helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=add_information
|