Access 2007

Software Description

Microsoft Office Access 2007 provides a powerful set of tools that help you to quickly start tracking, reporting, and sharing information. You can rapidly create attractive and functional tracking applications by customizing one of several predefined templates, converting an existing database, or creating a new database, and you can do so without deep database knowledge. By using Office Access 2007, it is easy to adapt database applications and reports to changing business needs. The enhanced support for Microsoft Windows SharePoint Services 3.0 in Office Access 2007 helps you to share, manage, audit, and back up your data.

Start working immediately with the results-oriented features in Office Access 2007:

• Prebuilt solutions. The new Getting Started screen includes a variety of prebuilt database solutions. Use these applications right out of the box to track contacts, events, issues, assets, tasks, and more — or treat them like templates, and enhance and refine them to accommodate the kind of information you want to track or the way in which you want to track it. As other application templates become available from Microsoft Office Online, they will be advertised in the Getting Started screen.
• Office Fluent user interface. Office Access 2007 has been updated with a fresh look that makes it easier to create, modify, and work with tracking applications (Access database solutions). The Office Fluent user interface (UI) is context-sensitive and optimized for efficiency and discoverability. From the nearly 1,000 available commands, the Fluent UI displays only those relevant to the task you are performing at any given moment. In addition, the tabbed windows view and a new status bar, scroll bars, and title bar give applications built on Office Access 2007 a very modern look.
• Improved navigation. The new Navigation Pane provides a comprehensive view of tables, forms, queries, and reports. You can even create custom groups to organize and see all the forms and reports related to a single table.
• Quickly create tables. Office Access 2007 makes it easier to work directly within a datasheet to create and customize tables. Enter information into a data cell — just as you do in Microsoft Office Excel. When you enter a new value, Office Access 2007 automatically adds a new field and detects the data type (for example, date, number, or text). You can even paste Excel tables into a new datasheet, and Office Access 2007 will build all the fields and recognize the data types automatically.
• Import contact records from Microsoft Office Outlook 2007. Office Access 2007 makes it easy to exchange an individual Access contact record with Office Outlook 2007. You can import an Outlook contact record into Office Access 2007; you can also export a contact record from Office Access 2007 and save it as a contact in Office Outlook 2007.

Share tracked information with others
Office Access 2007 enables you to gather information easily and make it available to others with more security and flexibility.

• Collect data using Office Outlook 2007. Office Access 2007 simplifies the process of collecting information from others. It builds the data collection form automatically in Microsoft Office InfoPath 2007 or HTML in the body of the e-mail message. You can send that form to recipients, using e-mail addresses from your Outlook contacts or from Access itself. Office Outlook 2007 processes the incoming forms and saves the data in your Office Access 2007 data store — effectively updating the data in your tracking application immediately, without retyping.
• Web collaboration with Windows SharePoint Services. Web sites based on Windows SharePoint Services provide a place where your team can communicate, share documents, and work together on a project. With Office Access 2007, you can publish your Access files to libraries or move the application to Windows SharePoint Services, moving the data and front-end database to the server so that your team can interact with it easily through the browser. Forms and reports can be viewed, updated, or deleted directly on the Windows SharePoint Services site according to the established permission settings.
• Track Windows SharePoint Services lists with Office Access 2007. For a richer experience, you can track information on Windows SharePoint Services lists using the Office Access 2007 client on your computer.
• Work offline with Windows SharePoint Services lists. Using Office Access 2007, you can work with Windows SharePoint Services offline. If you are traveling, for example, you can maintain a local copy of a SharePoint list on your portable computer, where you can edit and query the list as though it were any other table in Office Access 2007. Forms and reports that use the SharePoint list are fully interactive — and Office Access 2007 can later synchronize the local list with the online list when you bring your portable computer back online.
• Integration with Windows SharePoint Services workflow. Office Access 2007 authors can use business logic created with the workflow support in Windows SharePoint Services to build collaborative workgroup applications. Use workflow to automatically assign tasks to other users, report on project status, and help ensure that tasks are completed on time. All Windows SharePoint Services tasks can be viewed inside Office Access 2007 or Office Outlook 2007 depending upon your work style.
• E-mail and RSS notifications. Users can subscribe to e-mail notifications when records are added, deleted, or changed. Additionally, Really Simple Syndication (RSS) subscriptions users can subscribe to list feeds in Office Outlook 2007.
• Mobile connectivity. Windows SharePoint Services lists can also be accessed through mobile phones, so remote users can stay current on changing business information.
• PDF and XPS support. With Office Access 2007, you can save a report as a Portable Document Format file (PDF) or in XML Paper Specification (XPS) format for printing, posting, and e-mail distribution. By saving your report as a PDF or XPS file, you capture report information in an easily distributed form that retains all your formatting characteristics yet does not require others to have Office Access 2007 to print or review your report.*

* You can save as a PDF or XPS file from a 2007 Microsoft Office system program only after you install an add-in.

Manage and audit sensitive information
Office Access 2007 makes it easier for you to meet your information management needs with improved data transparency in a manageable environment.

• Improved security. To make Office Access 2007 even safer and more consistent with other 2007 Office system programs, Office Access 2007 includes improved as well as new security features. Unified trust decisions are integrated with Office Trust Center. Trusted locations make it easy to trust all databases in security-enhanced folders. Conversely, you can load an Access application with code or macros disabled to help provide a safe experience.
• Data auditing. Without requiring IT support, you can easily migrate data from your local database file to a server with Windows SharePoint Services — which your organization’s IT professionals can manage, help secure, and back up according to your organization’s policies.
• Revision history. New functionality enables you to track records and see who created, edited, and deleted records. You can also view when the information was modified and roll back data edits if necessary.
• Permission setting. Using Windows SharePoint Services, you can manage which users have access to your data and assign limited reading permissions or full editing rights.
• Recycle bin. You can recover data mistakenly deleted using the recycle bin feature in Windows SharePoint Services.