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 - Microsoft Access Tutorial
From the course: Access 2007: Shortcuts
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
Creating a table using table templates1m 19s
-
Setting data types2m 15s
-
Understanding number field sizes3m 43s
-
Setting default field types2m 30s
-
Using validation rules2m 1s
-
Using flag fields2m 6s
-
Using an index1m 58s
-
Using a datasheet Totals row1m 47s
-
Filtering by selection1m 22s
-
Resizing columns and rows1m 50s
-
Removing gridlines and shading from tables1m 27s
-
Hiding and unhiding table fields1m 16s
-
Freezing fields when scrolling51s
-
Analyzing your table for redundant structure5m 14s
-
-
-
-
-
-
-
-
-