Wednesday, September 15, 2010

Microsoft Office Access 2007 Features

Thinking about taking Access? Here are some of the features of this program:
  • 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.
  • Attach documents and files to your database  
  • WYSIWYG: Office Access 2007 features a what-you-see-is-what-you-get (WYSIWYG) forms design interface. You can design and modify the form layout in real time on the screen — and preview your form as you build it.
  • Interactive report browse:  The new report browse mode makes user reports more accessible. Use CTRL+F to find records, copy the data into other applications, and get to detailed records to edit the data.
  • Revision history: New functionality enables you to track records and see who created, edited, and deleted records.
  • Work with multivalue fields: Office Access 2007 supports complex data types, so you can create columns that accept more than one value in a cell. For example, if you assign a task to more than one person, you can include both names in the cell. 
  • 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.
  •  Collect information through forms in e-mail or import data from external applications.

No comments:

Post a Comment