Skip to main content

Access Junkie - MVP Alumnus

Access Inside Out Books
Access 2010 FAQ
Access 2007 Training
Access 2007 FAQ
Access 2007 KB Articles
Technical Articles
MSDN Articles
Contact Us
About Us
Member Login
Access 2010 FAQ


Where are the Table Templates that were available in Access 2007?


In Access 2007, you could use five Table Templates included with the product to get a jump start on creating some common table structures - Contacts, Tasks, Issues, Events, and Assets.


In Access 2010, Microsoft removed those Table Templates and replaced them with a new feature called Application Parts.


To build a table using one of the Application Parts, close the table that Access 2010 created when you opened the database (Table1), click the Create tab on the ribbon, and then click the Application Parts button in the Templates group. Access displays a list of 10 form types under the Blank Forms category and five Application Parts under the Quick Start category, as shown in the screenshot below. Microsoft also uses the term Models to refer to this one-click object creation feature.



The five Application Parts under Quick Start, which represent some of the more common types of table structures and objects found in databases, are as follows:


- Comments Use this Application Part when you need a table to track various comments. Clicking this option creates one table with a comment date and comment fields.


- Contacts Use this Application Part when you need to track your personal or business contacts. Clicking this option not only creates a Contacts table, but it also creates a query, three forms, and four reports to work with that Contacts table. With one click, you are well on your way to creating a functional application to track your contacts. Key fields in the Contacts table include the contact’s company, job title, and phone numbers.


- Issues Use this Application Part for recording various personal or business issues. Clicking this option creates an Issues table as well as two forms to work with that table. Some key fields in the Issues table include the title of the issue and the issue status.


- Tasks Use this Application Part for keeping track of various tasks and projects needing completion. Clicking this option creates a Tasks table as well as two forms to work with that table. Key fields in the Tasks table include start and due dates for the task and percentage complete.


- Users  Use this Application Part for maintaining a list of users for your database. Clicking this option creates a Users table as well as two forms to work with that table. Key fields in the Users table include the e-mail, full name, and login information.



See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out



Back to FAQ main page