星期五, 8月 06, 2010

New Features in Access 2007

What does the new AutoFilter feature of Access 2007 allow you to do?

Create a list of values for a column
Sort data
Replace the menus and toolbars of previous versions of Access
View the content of tables, reports, and queries in separate tabs



There are three columns – Customer Name, Product Name, and Feedback– in the Feedback table. You want to highlight some text in the Feedback column to emphasize certain important data. How would you achieve this task?

Change the text format from plain text to rich text
Change the text format from rich text to plain text
Define the data type for the Feedback column as Memo
Define the data type for the Feedback column as Text




What does the new tabbed document feature of Access 2007 allow you to do?

Create a list of values for a column
Sort and filter data
Organize tables, reports, and queries
View the content of tables, reports, and queries in separate tabs





You want to collect contact information from your employees from different locations and store that information in the Employee Information table in Access 2007. What is the best way to do this task?

Copy and paste the contact information from the e-mail messages into the Employee Information table
Send an HTML form or a Microsoft Office InfoPath form along with the e-mail message and collect the contact information
Send the Employee Information table to all employees and collect their contact information
Share the Employee Information table and allow the employees to store their information in it