77-885 試験問題を無料オンラインアクセス

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database named Customers created in Microsoft Office Access 2010. You want to find all customer records where the contact person's title is Owner and the person is located either in Portland or in Eugene. Which of the following filter features will you use to accomplish the task?

• A.Filter By Record
• B.Advanced Filter
• C.Filter By Selection
• D.Filter By Form

Which of the following types of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times?

• A.Select query
• B.Crosstab query
• C.Action query
• D.Parameter query

Choose the functions that an Access user can perform using the Database Tools ribbon available in Microsoft Office Access 2010.

正解：

1 - Open the VBA editor for a module.
2 - Run a macro.
3 - Open the Relationships window to create table relationship
4 - Show or hide the Object Dependencies pane.
5 - Run the Database Documenter and Table Analyzer Wizard
6 - Run the Linked Table Manager for linked Access tables.
7 - Create and edit a switchboard with the Switchboard Manage
8 - Encrypt the database and set a database password.
9 - Manage Access add-ins.
10 - Make an execute-only database by stripping out VBA source
Explanation:
To open the VBA editor for a module
To run a macro, create a shortcut menu from a macro, and convert a macro to VBA To open the Relationships window to create or edit table relationships To show or hide the Object Dependencies pane, property sheet for an object, and message bar To run the Database Documenter, Performance Analyzer, and Table Analyzer Wizard To move tables to a back-end Access database or upsize tables and queries to SQL Server 2005 or later To run the Linked Table Manager for linked Access tables To create and edit a switchboard with the Switchboard Manager To encrypt the database and set a database password To manage Access add-ins To make an execute-only database by stripping out VBA source code

Which of the following is located along the left side of the Access screen and provides an interface for all database objects?

• A.Object Dependencies pane
• B.Quick Access Toolbar
• C.Application part
• D.Navigation Pane

You are working on a home computer with Microsoft Office 2010 installed on it. You are creating a form in Microsoft Office Access 2010 in order to control the execution of Access database application. Which of the following capabilities does this object provide?
Each correct answer represents a complete solution. Choose all that apply.

• A.It links several forms or reports using macros or Visual Basic procedures.
• B.It displays ActiveX objects directly on the form.
• C.It provides a more discrete flow of actions and way to trap errors.
• D.It performs extensive editing of data using a macro or Visual Basic procedure.