Office : Ultimate Tips and Tricks

Simplify your database creation by adding common components across your databases or organization in just a few clicks. 1. Start with an open database. 2. On the Create tab, in the Templates group,…

Find database templates in Access 2010 you can use as a starting point or customize them to meet to your needs. 1. Click the File tab to open Backstage view. 2. On the New tab, click Sample templat…

With Access 2010 and SharePoint Server 2010, your data can have enhanced protection to help meet data compliance, along with backup and audit requirements, providing you increased accessibility and  …

Of course you want to be protected from potential threats to your computer and to your files. But why go through repeated security checks after you have confirmed that a file is trusted? After you co…

New data macros in Access 2010 enable you to store your macros in your tables, not the objects that use your tables. To add data macro to your table: 1. Start with an open table. 2. On the Table T…

New Macro Designer enhancements help you be more productive, reduce coding errors, and easily incorporate more complex logic to create robust applications and extend your database application. To cre…

Enhance your navigation controls, tabs, and buttons with new shape tools in Access 2010. To change color and shape effects: 1. Start with an open form. 2. On the Home tab, in the Views group, click…

Take advantage of familiar and appealing Office themes and apply them to your databases with high fidelity both on the Access client and the Web. To select a default Office theme: 1. Start with an …

Add data bars with gradient fills to your forms and reports and visually see how one value compares to the others or identify trends. 1. Start with an open form or report. 2. On the Home tab, in …

Switch between your fields to modify, add, or delete conditional formatting rules and now add up to 50 formatting conditions. To display the new Conditional Formatting Rules Manager: 1. Start with …

Use a Navigation Form and make your frequently used forms and reports more accessible and readily available when you need them. To create a Navigation Form: 1. Start with an open database. 2. On th…

Reuse shared images in your forms and reports through the Image Gallery and save valuable design time.  Start with an open form or report. On the Home tab, in the Views group, click View and then c…

Use Quick Start fields to add groups of related—and pre-formatted—fields to your table in just a few clicks. Save time and help ensure consistency when creating tables that use similar fields across …

File tab: Opens Backstage view. Click any Ribbon tab to return to the main view. Backstage tabs: Fast, easy, and organized access to tools and options that were previously spread across several loca…