IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 77-885 問題集  / 77-885 問題練習

Microsoft 77-885 問題練習

MS Access 2010 試験

最新更新時間: 2020/11/14,合計112問。

いい買物の日:77-885 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、77-885 問題集を使用してください。

 / 8

Question No : 1
Which of the following datatypes cannot be filtered by using common filters? Each correct answer represents a complete solution. Choose two.

正解:
Explanation:
The following datatypes cannot be filtered by using common filters: OLE Object: The OLE Object datatype is used to attach files and add binary data to a table. This datatype stores each data in a bitmap format. This results in an increase in the size of a database file. Only a single file can be added to each row of a table. The files attached can be Microsoft Office files, graphics files, sound files, pdf files, etc. Calculated Field: The Calculated Field datatype is used to store the results of a calculation. The calculation should refer to other fields created in the same table. In order to create the calculation, a user can use the Expression Builder that provides the use of IntelliSense and an easy way to access expression values.
Answer: C and B are incorrect. These datatypes can be filtered by using common filters. The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink. The AutoNumber datatype is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table. The increment can be changed through the New Values property. This property has the following two values: Increment Random

Question No : 2
You have a datasheet named Datasheet1 created in Microsoft Office Access 2010. You need to calculate the sum, average, and count for dat a. This data is grouped by two types of information, one down the left side of the datasheet and another across the top of the datasheet. You want to display the results of the query's calculation in the cell at the junction of each row and column.
Which of the following types of Query wizard will you use to accomplish the task?

正解:
Explanation:
The various types of the Query wizard are as follows:

Question No : 3
You are working on a table named Employee created in Microsoft Office Access 2010. The table is opened in the Design view.
Now, you want to quickly switch to the PivotChart view of the table. Mark the toolbar/button on the program window that helps you in performing the task.



正解:


Explanation:
In order to perform the task, you should click the PivotChart View button on the View Shortcuts toolbar.
A table can be opened in the following four views:

Question No : 4
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 Database1 created in Microsoft Office Access 2010. The database includes two tables named Table-A and Table-B. You want to divide Table-A with many columns and isolate a part of Table-A for security reasons.
Which of the following types of relationship will you create between both tables to accomplish the task?

正解:
Explanation: In order to accomplish the task, you should create a one-to-one relationship between Table-A and Table-B. A one-to-one relationship is an association between two tables in which each record in one table can have only one related record in another table. This type of relationship is not generally used because it is easier to shift all the fields in one table. A one-to-one relationship is created if both of the related fields are primary keys or have unique limitations.
A one-to-one relationship performs the following tasks:
It divides a table with many columns.
It isolates part of a table for security reasons.
It stores short-lived data and deletes this data by deleting the table.
It stores information that applies only to a subset of the main table.
Answer: C is incorrect. A one-to-many relationship is the most common type of relationship. In this type of relationship, a row in the first table can have one or more matching rows in the second table, but a row in second table can have only one matching row in the first table. For example, the States and Cities tables have a one-to-many relationship. Each state has many cities, but each city comes under only one state. A one-to-many relationship is created if the foreign key column does not have a unique constraint.
Answer: A is incorrect. A many-to-many relationship is an association in which two one-to-many relationships are connected together through a third table. This third table is called the junction table. A many-to-many relationship can be viewed in a database that contains Products, Orders, and Order Details tables. The Orders table and the Products table have a many-to-many relationship that is defined by creating two one-to-many relationships to the Order Details table. Each record in the Orders table has many records in the Products table and each record in the Products table has many records in the Orders table.
Answer: D is incorrect. Container-managed relationships (cmr) are relationships that exist between two entity beans within a local interface. The bean provider declares these relationships in the bean class, and the container implements the relationships using the information defined in the deployment descriptor.
There are three kinds of container-managed relationships as follows:

Question No : 5
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 contains a database named Employees created in Microsoft Office Access 2010.
You want to ensure that Access automatically corrects and formats the contents of your database. Mark the option in the Access Options dialog box that you will choose to accomplish the task.



正解:


Explanation:
In order to accomplish the task, you will use the Proofing option in the Access Options dialog box. This option includes the settings to allow Microsoft Office Access to automatically correct and format the contents of database. The Proofing option also includes the settings for how Access indicates the errors.


Question No : 6
You are working on your home computer with Microsoft Office 2010 installed on it. You have a table named Accessories created in Microsoft Office Access 2010. Now, you want to create a form from the table to get an organized and formatted view of all fields. Choose and re-order the steps that you will take to accomplish the task.



正解:


Explanation:
Take the following steps to create a form using the Form tool in Microsoft Office Access 2010:

Question No : 7
You want to perform the following tasks to manipulate data before importing it into Access: Add fields. Combine fields. Use complex mathematical functions.
Which of the following is the best place to perform the above listed tasks?

正解:
Explanation:
A Microsoft Office Excel worksheet is the best place to perform the following tasks to manipulate data before importing it into Access:
Add or remove fields. Combine or split fields.
Use complex mathematical functions. You can easily import a worksheet or a named range from a worksheet into a new table or an existing table. You can also import some particular fields from a worksheet or a named range into Access.
Answer: A, D, and B are incorrect. You can use these three places for importing data into Access, but all these have a complicated process of importing information.

Question No : 8
You are creating a table in Datasheet view of Microsoft Office Access 2010. Choose and re-order the steps that you will take to accomplish the task.



正解:


Explanation:
Take the following steps to create a table in Datasheet view:

Question No : 9
You work as a Database Documenter for Tech Perfect Inc. You have a database named Database1 created in Microsoft Office Access 2010. This database contains three tables named Products, Orders, and Order Details. You want to manage the tables in such a way that each record in the Orders table will have many records in the Products table and each record in the Products table will have many records in the Orders table.
What should you do to accomplish the task?

正解:
Explanation:
In order to accomplish the task, you should create a many-to-many relationship between the Orders table and the Products table. You can define this relationship by creating two one-to-many relationships to the Order Details table.
Answer: B is incorrect. A one-to-one relationship is created between two tables in which each record in one table can have only one related record in another table.
Answer: D is incorrect. A one-to-many relationship is created between two tables in which a row in the first table can have one or more matching rows in the second table, but a row in the second table can have only one matching row in the first table.
Answer: C is incorrect. The Microsoft Office Access does not have this kind of relationship.

Question No : 10
You have created a table named Books in Microsoft Office Access 2010. You have created a new field to enter the Book ID. For this purpose, you need to set the Number datatype for the field.
Which of the following actions will you perform to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

正解:
Explanation:
In order to accomplish the task, you can do one of the following:
Simply insert a number in the created field. When you insert a number in the field and press the 'Enter' key, Access automatically selects the Number datatype for that field. Choose the Number datatype from the Formatting group.



Answer: B is incorrect. When you click on the Field Header, you do not find any option for the datatype.



Answer: C is incorrect. When you right-click the field, you do not find any option for the datatype.


Question No : 11
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 Exam Datasheet created in Microsoft Office Access 2010.
You want to import a table named Students which is created in another database named Info. Choose and re-order the steps that you will take to accomplish the task.



正解:


Explanation:
Take the following steps to import a table from a database in Microsoft Office Access 2010:

Question No : 12
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.

正解:
Explanation:
A form has the following capabilities:
It controls and enhances the looks of data.
It adds controls such as, list boxes and check boxes.
It displays ActiveX objects directly on the form.
It calculates and displays values based on data in a table or a query.
It performs extensive editing of data using a macro or Visual Basic procedure.
It links several forms or reports using macros or Visual Basic procedures.
Answer: C is incorrect. A module provides a more discrete flow of actions and way to trap errors.

Question No : 13
You work as a Database Developer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You want to create a form that allows users to browse to different forms and reports created in Microsoft Office Access 2010. Mark the button that you will choose to accomplish the task.



正解:


Explanation:
In order to accomplish the task, you should choose the Navigation button in the Forms group. It allows a user to browse to different forms and reports created in Microsoft Office Access 2010.
The Navigation button has various options as shown in the image given below:


Question No : 14
Which of the following restricts a user from entering invalid data in the table columns?

正解:
Explanation:
A validation rule is a set of rules associated with a column so that a user is restricted from entering invalid data. A user can be restricted from entering data through the following options: Datatypes: When a field is assigned to a datatype, data of another type cannot be inserted in the field. Field size: The field size restricts the amount of data to be inserted in a table.
Table Properties: Certain table properties such as Required forces a user to enter data or the Format property forces a user to enter data in a defined format. A validation rule can be applied by using the Validation Rule property. A user can be intimated about the invalid data through the Validation Text property.
Answer: A is incorrect. An input mask is used to control values of a field entered by a database user. The input mask includes literal characters, for example, space, dot, parenthesis, and placeholder. Microsoft Office Access contains a number of pre-defined input masks that match with most of the conditions. A user can create customized masks according to his needs. The Input Mask Wizard is used to create an input mask for text and date fields. If the user wants to create an input mask for numeric fields, he should enter the formatting symbol himself.
Answer: C is incorrect. In Microsoft Office Access 2010, an index is a list of field values included in a table. It helps Access in finding and sorting records quickly. An index stores the record's location based on the columns that are part of the index. The indexed fields have unique values which make it more efficient and faster for Access to read and find a specific field value.
Answer: B is incorrect. An application part is a template available in Microsoft Office Access 2010. It can be added to an existing database. It is used to extend the functionality of an Access database. It can include only a single table or a number of database objects, such as tables, forms, reports, and even relationships. A user can open up the Application Parts gallery in order to view the built-in parts.

Question No : 15
You are working with a query created in Microsoft Access 2010. Mark the button that you will click to perform the operations specified by the query.



正解:


Explanation:
In order to perform the operations specified by the query, you should click the Run button. It displays the datasheet of a selected query and serves the same function as selecting Datasheet View from the View button.


 / 8