Instant Access Microsoft.77-885.v2022-02-01.q48 Actual Practice Test Engine for Free (Page 8)

Welcome to DumpsDB

- Passing Exams, Dumps for Free

Request Exam Contact

Home
Popular Exams
- Oracle
- Fortinet
- Juniper
- Microsoft
- Cisco
- Citrix
- CompTIA
- VMware
- ISC
- SAP
- EMC
- PMI
- HP
- Salesforce
View All Exams
New Dumps
Upload

Oracle
Fortinet
Juniper
Microsoft
Cisco
Citrix
CompTIA
VMware
ISC
SAP
EMC
PMI
HP
Salesforce

Home
Microsoft Certification
77-885 Exam
Microsoft.77-885.v2022-02-01.q48 Dumps

««
«
…
2
3
4
5
6
7
8
9
10
11
»

Question 31

You are creating a report named Performance in Microsoft Office Access 2010 using the Report Design feature. This feature opens a report layout in the Design view. Which of the following tasks can you perform in the Design view?
Each correct answer represents a complete solution. Choose all that apply.

A.Add and manage controls.
B.Add fields from the Field List.
C.Adjust the report elements' properties.
D.Adjust the size of sections of design grid.

Correct Answer: A,C,D

The following tasks are performed in the Design view of an Access report:
Apply a new theme.
Adjust the size of sections of design grid.
Add controls.
Manage controls.
Adjust the report elements' properties in the Property Sheet.
Answer B is incorrect. You can perform this task when you are working with an Access form.

Comment: *

Name: *

Email: *

Verification: *

insert code

Question 32

You have two tables named Customers and Orders created in Microsoft Office Access 2010. In Orders table, each order has a customer ID. You want to correspond it to a record in the Customers table. Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

A.Entity integrity
B.Domain integrity
C.Primary key
D.Foreign key

Correct Answer: C,D

In order to accomplish the task, you should use the following:
Primary key: A table usually has a column or combination of columns whose values uniquely identify each row in the table. This column (or columns) is called the primary key. Primary key ensures that no duplicate or null values are entered in the column (or columns) defined as primary key columns. This enforces integrity of the table. A primary key can be created by defining a primary key constraint while creating or altering a table. A table can have only one primary key constraint. As primary key constraints ensure uniqueness, they are often defined by using an identity column.
Foreign key: A foreign key is a column or combination of columns used to establish and enforce a relationship between the data in two tables. This relationship is created by adding a column(s) in one of the tables to refer to the other table's column(s) protected by a PRIMARY KEY or UNIQUE constraint. This column becomes a foreign key in the first table. A foreign key can be created by defining a FOREIGN KEY constraint when creating or altering a table.
Answer A is incorrect. Entity integrity enforces the uniqueness of rows in a table. The uniqueness of rows can be enforced by the identifier column(s) through indexes, UNIQUE constraints, PRIMARY KEY constraints, or IDENTITY properties.
Answer B is incorrect. Domain integrity enforces data validity by restricting the data type, valid values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY constraints) for columns in a table.

Comment: *

Name: *

Email: *

Verification: *

insert code

Question 33

Which of the following view types allows a user to manipulate data on the form created in Access 2010?

A.Datasheet view
B.Form view
C.PivotChart view
D.PivotTable view

Correct Answer: B

The Form view is a default view type for an Access form. It allows a user to manipulate data on the form.

Answer A is incorrect. The Datasheet view displays the data in the table format.
Answer C is incorrect. The PivotChart view allows a user to display the data of a form as pivot charts.
Answer D is incorrect. The PivotTable view allows a user to display the data of a form as a pivot table.

Comment: *

Name: *

Email: *

Verification: *

insert code

Question 34

Choose the appropriate tasks that you can perform in the Design view of an Access form.

Correct Answer:

1 - Adjust the size of sections of design grid.
2 - Apply a new theme to the form.
3 - Modify the control's size.
4 - Organize controls logically for assisting data entry.
5 - Change the form elements' properties in the Property Sheet
6 - Add fields from the Field List.
7 - Add controls for limiting data entry selections.
Explanation:
Adjust the size of sections of design grid.
Apply a new theme to the form.
Modify the control's size.
Organize controls logically for assisting data entry.
Change the form elements' properties in the Property Sheet.
Add fields from the Field List.
Add controls for limiting data entry selections.

Comment: *

Name: *

Email: *

Verification: *

insert code

Question 35

Which of the following datatypes is used to attach Microsoft Office files, graphics files, sound files, and pdf files to a table?

A.Hyperlink
B.Memo
C.OLE object
D.Text

Correct Answer: C

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.
Answer A is incorrect. 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.
Answer D is incorrect. The Text datatype is used to store alphanumeric values. These values can be numbers, alphabets, special characters such as <, >, ?, etc. This datatype accepts values up to 255 characters. The number of characters can be limited to a fixed size by using the field size property.
Answer B is incorrect. The Memo datatype stores alphanumeric values. These values can be numbers, alphabets, special characters such as <, >, ?, etc. This datatype is used in place of the Text datatype. It can store 65,535 characters. It also accepts text with rich text format, paragraphs, descriptions, etc.

Comment: *

Name: *

Email: *

Verification: *

insert code

««
«
…
2
3
4
5
6
7
8
9
10
11
»

[×]

Download PDF File

Enter your email address to download Microsoft.77-885.v2022-02-01.q48 Dumps

Email:

We are the Largest and the most Updated website for all vendors Certification Exam materials around the world.

Using resources of we provide, we strive using dumps to strengthen the community of High level Certification professionals for free.

DMCA
About
Contact Us
Privacy Policy
Terms & Conditions

©2026 DumpsDB

www.dumpsdb.com materials do not contain actual questions and answers from Cisco's certification exams.

Web Analytics