Computer and Business Skills training

Sign Up
888.815.0604
Home / Access / Working With Tables

Working With Tables in Microsoft Access



For instructor delivered training in Chicago and Los Angeles call us on 888.815.0604.



In this Article, we will learn how to:

  • Create a table
  • Use table views


Creating a Table



To create a table, click Create → Table:



Creating A New Table



A new table will then be created with the default ID field:



Default Table and ID Created



Press Ctrl + S to save this new table. When the Save As dialog appears, type “Expenses” as a table name and click OK:



Save As Dialog Box



The new table will now be saved within the database using the table name you selected.



Understanding Table Views



Now that you have created a table, you need to add fields to it. Access 2013 includes Design View to help you add fields easily. To apply Design View, click Home → View → Design View:



Add Fields Via Design View



In the first field, type “Expense ID:”



Type Name In First Field



Press Tab. This will advance the cursor to the Data Type combo box. Leave AutoNumber as the default data type. Press Tab once more to advance to the Description Field. Type “Unique ID for each expense claimed to the company.”



Use Tab Function to Edit Data



Use the methods detailed above to enter the following information into the table. Use Tab to move quickly between the fields:


Press Tab For Fast Cell Movement



When you are done, switch back to Datasheet View by clicking Home → View → Datasheet View:



Switch Back To Data View



A dialog will appear asking if you want to save the table. Click Yes:



Click Yes On Save Dialog Box



With Datasheet View applied, you can now see the new fields you entered using Design View:



Use Design View to See New Fields



Save your database.


Access student reviews

We teach thousands of students in MS Applications every year. Read a sample of testimonials at our MS Access training testimonial page.


Access courses

Why train with us?Need Group training quotation?Fresh Peet's Coffee brewed every day Book two levels of access training and save $100FREE Class Repeat with each courseBook 3 Level of access Training and save $150