Microsoft Office Access 2007 helps information workers quickly track and report information with ease thanks to the new Microsoft Office Fluent user interface and interactive design capabilities that do not require deep database knowledge. Users can share information over the Web on Microsoft Office SharePoint Server 2007 lists where it can be audited and backed up. Here are the top 10 ways Office Access 2007 can help you.
Get better results faster with the new Office Fluent user interface.
Office Access 2007 provides a completely new experience with the results-oriented Office Fluent user interface, new navigation pane, and tabbed window views. Even with no database experience, any user can start tracking information and creating reports to make more informed decisions.
Get started quickly using prebuilt solutions.
With a rich library of prebuilt solutions, you can start tracking your information immediately. Forms and reports are already built for your convenience, but you can easily customize them to meet your business needs. Contacts, issue tracking, project tracking, and asset tracking are only few of the out-of-the-box solutions included in Office Access 2007.
Create multiple reports with different views of the same information.
Creating a report in Office Access 2007 is truly a “what you see is what you get” (WYSIWYG) experience. You can modify a report with real-time visual feedback and save various views for different audiences. The new grouping pane and filtering and sorting capabilities help you display the information so you can make more informed business decisions.
Create tables quickly without worrying about database complexity.
With automatic data type detection, table creation in Office Access 2007 is as easy as working with a Microsoft Office Excel table. Type your information and Office Access 2007 will recognize whether it is a date, currency, or another common data type. You can even paste an entire Excel table into Office Access 2007 to begin tracking the information with the power of a database.
Enjoy new field types for even richer scenarios.
Office Access 2007 enables new field types such as attachments and multivalue fields. You can now attach any document, image, or spreadsheet to any record in your application. With the multivalue field, you can now select more than one value (for example, assign a task to more than one person) in each cell.
Collect and update your information directly from the source.
With Office Access 2007, you can create forms using Microsoft Office InfoPath 2007 or HTML to gather information for your database. You can then send this form to your teammates via e-mail and use their responses to populate and update your Access table to eliminate the need to retype any information.
Share your information with Microsoft Windows SharePoint Services.
Share your Access information with the rest of your team using Windows SharePoint Services and Office Access 2007. With the power of both applications, your teammates can access and edit the data and view real-time reports directly through a Web interface.
Track Windows SharePoint Services lists with the rich client capabilities of Office Access 2007.
Use Office Access 2007 as your rich client interface to analyze and create reports from Windows SharePoint Services lists. You can even take the list offline, and then synchronize any changes when you reconnect to the network, making it easy for you to work with your data at any time.
Move data to Windows SharePoint Services for better manageability.
Make your data more transparent by moving it to Windows SharePoint Services. This way, you can routinely back up the data on the server, recover deleted data from the recycle bin, track revision history, and set access permissions, so you can better manage your information.
Access and use information from multiple sources.
With Office Access 2007, you can link tables to your database from other Access databases, Excel spreadsheets, Windows SharePoint Services sites, ODBC data sources, Microsoft SQL Server databases, and other data sources. You can then use these linked tables to easily create reports so you can base your decisions on a more comprehensive set of information.