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

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

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

Question 11

Which of the following datatypes is used to specify whether a condition is true or false?

A.OLE Object
B.Memo
C.Yes/No
D.AutoNumber

Correct Answer: C

The Yes/No datatype is a Boolean datatype that is used to specify whether a condition is true or false. A record can be retrieved based on any given condition. A user can use the WHERE clause to retrieve the data for those records that have been set to yes or no.
Answer A is incorrect. 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 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.
Answer D is incorrect. 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

Comment: *

Name: *

Email: *

Verification: *

Question 12

Choose and reorder the steps that you will take to assign a password to a database located on the network so that unauthorized users cannot access it.

Correct Answer:

1 - Click the Open option.
2 - Choose the database to assign a password.
3 - Click the arrow next to the Open button.
4 - Choose the Open Exclusive option.
5 - Display the Backstage view and click the Info option.
6 - Click the Encrypt with Password option.
7 - Type the password in the Password box.
8 - Verify the password, and then click the OK button.
9 - Click the OK button to close the message box.
Explanation:
1.Click the Open option.

2.Choose the database to assign a password.

3.Click the arrow next to the Open button, and then choose the Open Exclusive option.

4.Display the Backstage view and click the Info option.

Comment: *

Name: *

Email: *

Verification: *

Question 13

Which of the following datatypes is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table?

A.OLE Object
B.Memo
C.AutoNumber
D.Yes/No

Correct Answer: C

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
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.
Answer A is incorrect. 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 D is incorrect. The Yes/No datatype is a Boolean datatype that is used to specify whether a condition is true or false. A record can be retrieved based on any given condition. A user can use the WHERE clause to retrieve the data for those records that have been set to yes or no.

Comment: *

Name: *

Email: *

Verification: *

Question 14

Which of the following Report Layout tools is used to specify the color, width, and line style for the outline of the selected field of a report?

A.Arrange
B.Design
C.Page Setup
D.Format

Correct Answer: D

The Format tool is used to specify the color, width, and line style for the outline of the selected field of a report. It is also used to set font size, font style, and background image.

Answer B is incorrect. The Design tool is used to apply themes, controls, and header/footer in a report.
Answer A is incorrect. The Arrange tool is used to arrange the rows and columns in a report.
Answer C is incorrect. The Page Setup tool is used to set the page layout and page size of a report.

Comment: *

Name: *

Email: *

Verification: *

Question 15

Which of the following parts of the Access Window provides a command interface by consolidating all tasks or entry points in one place?

A.Navigation Pane
B.View selector
C.Ribbon
D.Tabbed document

Correct Answer: C

Comment: *

Name: *

Email: *

Verification: *

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

[×]

Download PDF File

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

Email: