Microsoft Office Access 2007 Frequently Asked Questions

Find answers to frequently asked questions (FAQ) about Office Access 2007.

On This Page
OverviewOverview
Pricing and OrderingPricing and Ordering
Installation and CompatibilityInstallation and Compatibility

Overview

Q.What's new in Office Access 2007?
A.

Office Access 2007 has an improved interface and interactive design capabilities that enable you to quickly track and report information with ease. Office Access 2007 does not require deep database knowledge and allows you to easily start with predefined applications, modify them, and adapt them to your changing business needs. Information can be collected on forms by e-mail or imported from external applications. Sharing information with Microsoft Windows SharePoint Services technology lists allows data to be routinely audited and backed up while keeping Office Access 2007 as the user interface.

Q.Who is Office Access 2007 for?
A.

Office Access 2007 is for people who want to track information and make sense of the data using reports that provide multiple views. Office Access 2007 users benefit from:

Improvements in creating and editing tables, forms, and reports.

New design capabilities.

Easy copy and paste table functionality from Microsoft Office Excel 2007—especially helpful for project managers who often track projects in spreadsheets and need to report progress with multiple views.

New collaboration capabilities for collecting data and sharing it with teammates.

Q.Why should organizations or teams consider using Office Access 2007?
A.

Everyone has information that can benefit from the structure provided by a database. A database is a collection of information that is related to a particular subject or purpose, such as tracking customer orders or maintaining asset lists. Office Access 2007 enables you to:

Start, organize, and track complex information in a structured way with with no coding expertise and very limited database knowledge.

Collect information from others and share it more securely on the Internet.

Make sense out of complex information by quickly building detailed reports that display sorted, filtered, and grouped information in a way that allows more informed decision making.

Bring transparency to data by moving your files to Windows SharePoint Services technology where you can audit revision history, recover deleted information, set data access permissions, and routinely back it up.

Q.What are some of the typical ways teams and organizations might use Office Access 2007?
A.

Office Access 2007 can be used for everyday information tracking and reporting:

An office manager can track company assets (for example, furniture and computers) and report assets by employee, manufacturer, or other criteria.

An engineering manager can track issues (for example, software bugs) that arise during new product development. He can build custom reports that will indicate open issues by product, the engineer assigned to the issue, issue category, or other criteria.

A marketing manager can track a project's progress and budget and report to managers as needed.

Q.
A.

Pricing and Ordering

Q.How do I buy Office Access 2007?
A.

Purchasing options will be announced in the second half of 2006.

Q.How much does Office Access 2007 cost?
A.

Find pricing and licensing information on the 2007 Microsoft Office System Pricing page.

Q.Will Office Access 2007 be included with the 2007 Microsoft Office release?
A.

Yes. Find packaging information on the 2007 Microsoft Office Packaging page.

Q.How does Office Access 2007 fit in with other Microsoft Office system programs?
A.

The Microsoft Office system provides customers with a set of programs that they can choose from to best address their business needs. Office Access 2007 is a database management program for storing information and creating reports. Information can be collected with Microsoft Office InfoPath 2007 or imported from Office Excel 2007 or a Windows SharePoint Services list. Office InfoPath 2007 can be used as the interface to help gather information more effectively. Office Excel 2007, a spreadsheet program, can help you analyze numeric data. Use Microsoft Office PowerPoint 2007 to graphically present information.

Q.
A.

Installation and Compatibility

Q.What are the systems requirements for Office Access 2007?
A.

See the system requirements for Office Access 2007.

Q.How does Office Access 2007 work with existing servers and databases?
A.

Office Access 2007 builds on the rich data connectivity of the Jet database engine and will continue to be a great place to create impromptu reports over disparate data sources. Office Access 2007 is now using its own version of Jet (called Ace), which has been extended to provide improved connectivity to Windows SharePoint Services data. Office Access 2007 is the best tool for Microsoft Office system users who wish to extend the data tracked in a line-of-business (LOB) application or to combine data from several existing databases into a single report.

Q.
A.

For More Information

The information contained on this Web site relates to pre-release software products, and may be substantially modified before the commercial release. This information is provided for informational purposes only, and Microsoft makes no warranties, express or implied, with respect to this Web site or the information contained in it.

Top of pageTop of page