Guide to the Access 2007 user interface 2

Getting Started with Microsoft Office Access

When you start Office Access 2007 by clicking the Windows Start button or a desktop shortcut (but not when you click on a database), the Getting Started with Microsoft Office Access page appears. This page shows what you can do to get started in Office Access 2007.

For example, you can create a new blank database, create a database from a template, or open a recent database (if you have opened some databases before). You can also go directly to Microsoft Office Online to learn more about 2007 Microsoft Office system and Office Access 2007, or you can click the Microsoft Office Button and use the menu to open a existing database.

Open a new blank database

1. Start Access from the Start menu or from a shortcut.

   The Getting Started with Microsoft Office Access page appears.

2. On the Getting Started with Microsoft Office Access page, under New Blank Database, click Blank Database.
3. In the Blank Database pane, in the File Name box, type a file name or use the one that is provided for you.
4. Click Create.

   The new database is created, and a new table is opened in Datasheet view.

Office Access 2007 provides a number of templates with the product, and you can download more from Microsoft Office Online. What is a template? In the context of Office Access 2007, it is a predesigned database complete with professionally designed tables, forms, and reports. Templates give you a big head start when you create a new database.

Create a new database from a featured template

1. Start Access from the Start menu or from a shortcut.

   The Getting Started with Microsoft Office Access page appears.

2. On the Getting Started with Microsoft Office Access page, under Featured Online Templates, click a template.
3. In the File Name box, type a file name or use the one that is provided for you.
4. Optionally, check the Create and link your database to a Windows SharePoint Services site if you want to link to a Windows SharePoint Services site.
5. Click Create
   -or-
   Click Download

   Access creates the new database from the template and opens it.

You can download additional templates from Office Online directly from within the Office Access 2007 user interface.

Create a new database from a Microsoft Office Online Template

1. Start Access from the Start menu or from a shortcut.

   The Getting Started with Microsoft Office Access page appears.

2. On the Getting Started with Microsoft Office Access page, in the Template Categories pane, click a category and then, when the templates in that category appear, click a template.
3. In the File Name box, type a file name or use the one that is provided for you.
4. Click Download.

   Access automatically downloads the template, creates a new database based on that template, stores it in your documents folder (for example, the My Documents folder), and opens the database.

When you open (or create and open) a database, Access adds the file name and location of the database to an internal list of the most recently used documents. This list is displayed on the Getting Started with Microsoft Office Access page so that you can easily open your most recently used databases.

Open a recently used database

1. Start Access.
2. On the Getting Started with Microsoft Office Access page, under Open Recent Database, click the database that you want to open.

   Access opens the database.

Open a database by using the Microsoft Office Access button

1. Start Access.
2. Click the Microsoft Office Button , and then click the database that you want to open, if it appears in the right pane of the menu.
   -or-
   Click the Microsoft Office Button , and then click Open. When the Open dialog box appears, enter a file name, and then click Open.

The database opens.

Information From http://office.microsoft.com/en-us/access/HA100398921033.aspx