Introduction to the Access 2010 templates

Web database templates

Five Web database templates are included with Access 2010. The term "Web database" means that the database is designed to be published to a SharePoint server that is running Access Services. However, you can also use a Web-compatible database as standard client database, so they are appropriate for any situation.

• Assets Web Database    Keep track of assets, including specific asset details and owners. Categorize and record the condition of assets, when they were acquired, where they are located, and more.

• Charitable Contributions Web Database    If you work for an organization that accepts charitable contributions, use this template to track fundraising efforts. You can track multiple campaigns and report on the contributions received during each one. Track contributors, campaign-related events, and pending tasks.

• Contacts Web Database    Manage information about the people that you or your teams work with, such as customers and partners. Track name and address information, phone numbers, e-mail addresses, and even attach pictures, documents, or other files.

• Issues Web Database    Create a database to manage a set of issues, such as maintenance tasks that need to be performed. Assign, prioritize, and follow the progress of an issue from start to finish.

• Projects Web Database    Track a variety of projects and their associated tasks. Assign tasks to people and monitor the percentage of completion.

For information about creating, publishing, and using Web databases, see the article Build a database to share on the Web.

Client database templates

Seven client database templates are included with Access 2010. They are not designed to be published to Access Services, but can still be shared by placing them in a shared network folder or document library.

• Events    Track upcoming meetings, deadlines, and other important events. Record a title, location, start time, end time, and description, and also attach an image.

• Faculty    Manage important information about faculty members, such as telephone numbers, addresses, emergency contact information, and employment data

• Marketing Projects    Manage the details of a marketing project and schedule and monitor project deliverables.

• Northwind    Create an order tracking system that manages customers, employees, order details, and inventory.

  Note: The Northwind template contains sample data that you will need to remove before using the database.

• Sales Pipeline    Monitor the progress of prospective sales within a small group of sales professionals.

• Students    Manage information about your students, including emergency contacts, medical information, and information about their guardians.

• Tasks    Track a group of work items that you or your team needs to complete.

Top of Page

Create a database by using a template that is included with Access 2010

1. Start Access 2010.

2. On the New tab of Microsoft Office Backstage view, click Sample Templates.

3. Under Available Templates, click the template that you want to use.

4. In the File Name box, type a file name.

5. Optionally, click the folder icon next to the File Name box to browse to a location where you want to create the database. If you don't indicate a specific location, Access creates the database in the default location that is displayed below the File Name box.

6. Click Create.

Access creates the database and opens it for use.

Create a database by using a template from Office.com

If you are connected to the Internet, you can browse or search for templates on Office.com from within Microsoft Office Backstage view. Use the following procedure:

1. Start Access 2010.

2. On the New tab of Backstage view, do one of the following:

   • Browse for a template    Under Office.com Templates, click the category of template that you are interested in (for example, Business).

   • Search for a template    In the Search Office.com for templates box, type one or more search terms, and then click the arrow button to search.

3. When you find a template that you want to try, click it to select it.

4. In the File Name box, type a file name.

5. Optionally, click the folder icon next to the File Name box to browse to a location where you want to create the database. If you don't indicate a specific location, Access creates the database in the default location that is displayed below the File Name box.

6. Click Download.

Get started using your new database

Depending on the template that you used, you might need to do one or more of the following to get started with the new database:

• If Access displays a Login dialog box with an empty list of users, use the following procedure to get started:

  1. Click New User.

  2. Fill in the User Details form.

  3. Click Save & Close.

  4. Select the user name you just entered, and then click Login.

• If Access displays an empty datasheet, you can begin typing data directly into that datasheet, or click other buttons and tabs to explore the database.

• If Access displays a Getting Started page, you can click links on that page to learn more about the database, or click other buttons and tabs to explore the database.

• If Access displays a Security Warning message in the message bar, and you trust the source of the template, click Enable Content. If the database requires a login, you will need to log in again.

Top of Page