From the course: Access 2007: Shortcuts

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating a table using table templates

Creating a table using table templates - Microsoft Access Tutorial

From the course: Access 2007: Shortcuts

Start my 1-month free trial

Creating a table using table templates

When you create a new table, you could build it from scratch or you could use Table Templates as a starting point. Table Templates are pre-created tables that I can further modify to suit my own needs. First, I am going to create a brand- new empty database by going to the Office button, choosing New. I'll give it the name, tabletemplates, and click Create. I am going to start by closing the table that opened up automatically. I will right-click on it, and choose Close. Now, go up to the Create ribbon and the second button says Table Templates. There are five readymade tables. I'll start by clicking on Contacts. Now I have an empty Contacts table with an example of any kind of field I would want. Other Table Templates include Task progress, Issue resolution, and Events. I can delete any unneeded fields from these tables, modify them, or add my own. But by starting the Table Templates, my database has been set up with correct data types and field sizes, saving me a lot of time and…

Contents