How to Create Tables Using Application Parts in Microsoft Access

Microsoft Access allows you to create tables, forms, queries and reports that are essential for your database. You can use different features to easily create your own database even if you are new to the Access. In this tutorial, we will guide you how to create tables in Access. Tables in Access are the foundation for your database and your record entries.


Step # 1 – Creating a table

Application parts are pre-created database templates. It not only includes tables but also a combination of forms and reports.
Application parts that you create can be used for future reference as well. In order to create tables in Access, go to the “create” tab in the ribbon area. From there, click on the Application parts” button and select the “contacts” option.

making a table

Step # 2 – Deleting unwanted objects

As you select the contacts option from the application parts button, a list of tables, queries, forms and reports will appear. As these objects are predefined, we will not use all of them. In this tutorial, we will be focusing on table. We will start by deleting the objects that we do not require. To delete all the unwanted items at once, click on one item and then while holding the shift key down, click on the last item. Once selected, press the delete key on your keyboard.

getting rid of the unwanted objects

Step # 3 – Selecting the data type

Now that you have deleted the items, it is time to rename the table. To rename the table, right click on the table and select the rename option. Rename this table to “Customers”. Now open the table by double clicking on it. Place your cursor in the ID field and then go to the “fields” tab. Move to the “data type” drop down menu and select “text”. If the ID field is auto number, it will never give you an accurate count of the records in your table because if you delete a record that number does not get used again. The “text” data type allows you to enter the data you want and lets you mix numbers and text at the same time.

choosing the data type

Step # 4 – Making a template

To use this table in the future as well, go to the backstage view by clicking on the file tab. Over there, move down and click on the “save database as” Click on template and then click on the “save as” button. In this manner, you can use this table in Access in the future as well.

Selecting the current table as template

Step # 5 – Renaming the template

As soon as you click on the “save as” button, a form will appear. Fill out the details and tick the “application part” check box. When you check the box, the “primary table” drop down menu becomes accessible. From the menu, select “customer table” and then click “OK”. A dialogue box will appear telling you that the template has been saved.

Naming the template

Step # 6 – Viewing the template

Lastly to check whether your template has been saved or not, go to the create tab and click on the application parts button. There, you will be able to see the template that you just created.

Locating the saved template