Microsoft Office 2010: The best new features in Access

[tweetmeme source=”LANSystems” only_single=false]If you have never used a relational database because you felt it was just too complicated, give a look at Access.  Access 2010 has simplified database functions and added ready-to-go templates to get you started. Information stored in spreadsheets and documents can be easier to understand and less time consuming to manage in a relational database model.  Not only can you save time, but you can make your data more meaningful and perform more meaningful analysis.  And if you are using a product that uses Access to store your data, you will be able to better understand the tables, reports and relationships.

Fast, easy database creation

Ready-to-go Templates – Use the available templates to create a marketing list or sales pipeline without being a database expert.  The templates are designed to give you the structure you need to get started and let you expand as you become more familiar with using Access.

Use modular components – These prebuilt components allow you to build the most common tasks into your database.  Go to Create – Application Parts after making your selection, the wizard will guide you through the setup and make your choices obvious.  There are on-demand help videos that explain how to use Access. The videos are surprisingly easy to follow with clear language and demos that take you through the screens step-by-step.

  Application Parts provide modular components for your Access databases 

Forms and reports with realistic, targeted analysis  

Conditional formatting – Use data bars to manage your rules and create professional reports that are understandable and informative. Rather than trying to “crowbar” your data into available formats, you can customize the presentation and make your data mean more to organization.  Stay focused at your sales and marketing meetings by using reports that everyone will recognize and appreciate.

Conditional formatting now supports data bars 

Office themes – Choose themes with fonts, colors and designs that match your other Microsoft Office products that demonstrate consistency and branding.

Backstage – The Microsoft Office Backstage view replaces the traditional file menu with an ergonomic approach that uses In and Out features for efficiency.  The improved Ribbon lets you access your favorite commands quickly and create custom tabs to personalize the way you work.

Developer quality without writing code

Expression Builder – Enhanced functionality with IntelliSense to greatly simplify formula and expression building. With these intuitive tools you will spend less time troubleshooting relationship errors and more time building a valuable database.

Make your databases available on the Internet with new Web databases 

Macro Designer – Add basic logic to your database, quickly and easily even if you are not familiar with databases. If you’re an experienced Access user, you’ll find the enhancements allow you to use the complex logic move efficiently than ever. Extend your database application with increased performance and confidence.

The revamped Macro Designer makes easier for you to add basic logic to your database

Work from anywhere

Online – Post your database online and then access, view, and edit them from the Web. Users without an Access client can open Web forms and reports via a browser and their changes are automatically synchronized.

You acn post your databases online and then access, view, and edit them from the Web

For organizations of all types and sizes, Access 2010 allows you to be more productive, flexible and cost-effective. You can combine tasks in Access that previously required several programs and labor intensive analysis to make better decisions for your business.

For more technical notes and information go to: www.lansystems.com/technotes.html 

If you have any questions or need help with the instructions, email me at: mary@lansystems.com.

Advertisements

Tags: , , ,

2 Responses to “Microsoft Office 2010: The best new features in Access”

  1. Keratin Hair Treatment Says:

    i use both open office and microsoft office and i would say that microsoft office is more responsive and user friendly -“-

    • lansystems Says:

      That’s good to hear. We support both Microsoft Office and Open Office, but find many users are more comfortable using and file sharing with Microsoft. The new features in 2010 make the produce much more functional and user-friendly

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: