Microsoft Office

Access

Click the link above to get the templete links on Access Team Blog.

Here are some of the new tweaks:

Some of the modifications include:

* Updated color schemes,
* New getting started screen,
* Video’s to demonstrate how to use the database and modify the database,
* Improved some of the database functionality to make it easier to use and more consistent, and
* Expanded the Students database to make it easier to track meta data about guardians relationships with a many-to-many junction table.

For example, here is one of the templete know-how:

the Task Management Database template.

Prepare the database for use
When you first open the database, Access displays the Getting Started page. To prevent this page from displaying the next time you open the database, clear the Show Getting Started when this database is opened check box.
Close the Getting Started page to begin using the database.

To make sure all the database content is enabled, use the following procedure:
In the Message Bar, click Options.
In the Microsoft Office Security Options dialog box, click Enable this content, and then click OK.
For more information about enabling database content, see the article Decide whether to trust a database.
Collect data through e-mail
You can collect task information from e-mail users by sending them a data entry form in an e-mail message. When users return the completed form, the data can be processed and stored in your task list.

On the Task List form, click Collect Data.
Follow the instructions in the Collect data through e-mail messages wizard to collect data from the specified e-mail recipients.
Search for a task or contact
The Quick Search box lets you quickly find a task on the Task List form, or a contact on the Contact List form.

Type the text you want to search for in the Quick Search box, and then press ENTER or click Go.
Access filters the list to show only those records that contain the text you searched for. To return to the full list, click Show All Records.
Filter the Task List
On the Task List form, you can filter the list of tasks, and save your favorite filters for future use.

Apply filters by right-clicking the form and selecting the filters you want.
Click Save Filter.
On the Filter Details form, enter a filter name and description, and then click Close.
Use the Filter Favorites box to apply a saved filter, or click (Clear Filter) to remove the filter.
Show or hide columns
On the Task List form and the Contact List form, some fields (columns) are hidden by default. Click above to read more!