Microsoft® Office 2010 Access® Tips

Tips on How to Use Microsoft Office 2010 beta Access

Access 2010 now includes new improvements over previous versions. Microsoft has spent plenty of person-years developing Microsoft Access 2010 and we've summarized a few of the best improvements below. Apart from the features listed below, Access 2010 offers many useful improvements that are not individually worth calling out, but will make things a lot easier. With, ready made database templates you can design your own database faster than before. You can apply professional designs and themes to it and navigate through the database easily with the drag and drop facility. Now, you can also access your data virtually from anywhere and can integrate your access content on web making it live.

Microsoft Office Access 2010 Tips what’s New in Access 2010

Publishing Access Databases to SharePoint
Macros
Backstage View
Data Type Gallery

While you are running a business and want to keep records of all business terms like employee details, employee salary, business records then you would need efficient database management software that will provide all tools and features to create and manage database. Microsoft Access 2010 gives you the options of creating lots of databases that consist of this collection of records and parts.

1. Publishing Access Databases to SharePoint

It is a big improvement over Access 2000/2003 Data Access Pages in terms of its use. The new feature is limited to SharePoint, something that will be a downside for anyone hoping to publish Access forms to the public Internet easily. But for any local internet application that requires the scalability of SharePoint, and some nice web forms, Access 2010 is an excellent leap forward.

In details, you can now take the tables from a MicrosoftAccess database and move it up to SharePoint , and create end-user forms in Access that will show up in SharePoint as a special site. The MicrosoftAccess 2010 web forms have a similar look and feel to normal SharePoint pages, but you need to design your own web forms in Microsoft Access 2010 separately from any client forms you wish to display to users, when they view your database using Access on their own machine.

2. Macros

Microsoft Access 2010 Data Macros are macros that are triggered when a new record is added, changed, or deleted in a table. What makes a Data Macro different than a normal macro, or VB procedure, is that it is tied to the table itself. A normal macro (now called a UI Macros) can only be called from a form event, another UI Macro, a report event, or VB code. Data Macros are stored with the table itself, so you will not see a separate macro object like you do for UI Macros in previous versions of Access.

3. Backstage View

The new "backstage view" in Office 2010 application is Microsoft second generation of the "Office Icon" menu, and certainly a better improved version. Rather than the limited drop down menu in Access 2007, Access 2010's backstage view gives you visibility to the different settings and configuration options available, as well as better textual help to guide you through making the changes.

4. Data Type Gallery

A new ribbon feature is a data type drop down visible in the Table views. When you select the dropdown, you will easily be able to choose from a set of plain-English data types that you might want to insert as a field into your table. This is a much better way to help users add new fields than the traditionally complex choices for data types (numeric - double, numeric - integer, etc).

iYogi’s Annual Unlimited Subscription Plan

iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 will provide the best issue resolution and customer satisfaction.