Databases - Upwork

Question: How is data in a single record kept together on a page (for a report) or on a column (for a form)?
A
By setting the KeepTogether property to Yes

B
By setting the SinglePagePrint property to Yes

C
By setting the DataTogether property to Yes

D
This feature is currently not available in Access

Note: Not available
1. Report
Question: How do you customize the text on a form or report's window frame or tab?
A
TabIndex Property

B
Text Property

C
Form Property

D
Caption Property

Note: Not available
1. Report
Question: What is the function of a Format Painter?
A
It copies a Table Design to the buffer for later use

B
It copies a control's format to another control

C
It helps to format a report so that it looks tidy and presentable

D
It copies a report design to the buffer for later use

Note: Not available
1. Report
Question: Under the Advanced options for the Access system, there is an option entitled Open Databases Using Record Level Locking. Which of the following are true when this option is checked?
A
Microsoft Access locks the row that is being updated

B
Microsoft Access locks the page that is being updated

C
Microsoft Access locks the table that is being updated

D
Microsoft Access locks the database that is being updated

Note: Not available
1. Report
Question: Which of the following is not a section of a report?
A
Summary

B
Detail

C
Group Footer

D
Report Footer

Note: Not available
1. Report
Question: The primary key index does not allow ________ data in a field.
A
numeric

B
character

C
date

D
duplicate

Note: Not available
1. Report
Question: What is the file extension of an Access Project?
A
.adp

B
.xml

C
.mdb

D
.mdf

Note: Not available
1. Report
Question: A company has the following departments: Finance, Accounts, Human Resources, Administration There is a table named Company having a column named Department, and the above values are stored in that column. What will be the result of the following query? Select Department from Company where Department < 'Finance'
A
The query will return "Accounts, Human Resource"

B
The query will return "Accounts, Administration ,Human Resource"

C
The query will return "Administration"

D
Strings cannot be compared using the < operator

E
The query will return "Accounts, Administration"

Note: Not available
1. Report
Question: If a relationship has the 'Cascade Update Related Fields' option on, which of the following is true?
A
Data in linked fields cannot be updated.

B
When a parent record is updated, all child records in the linked table are updated.

C
Null or blank values cannot be entered into the table.

D
Data in the linked tables can be updated, but new data cannot be added.

Note: Not available
1. Report
Question: Which of the following options most clearly defines the meaning of a bound HTML Control on a Data Access Page?
A
A Control that is bound to the HTML code residing online on a Web Server

B
A Control that displays information in the HTML code which is later used for publishing data on the internet

C
A Control that is bound to the HTML code showcasing the data from a particular field of a table

D
A Control that computes user defined expressions and stores the result in a table in the form of the HTML code.

Note: Not available
1. Report

First Prev 78 79 80 81 82 Next Last

Question: How is data in a single record kept together on a page (for a report) or on a column (for a form)?

Question: How do you customize the text on a form or report's window frame or tab?

Question: What is the function of a Format Painter?

Question: Under the Advanced options for the Access system, there is an option entitled Open Databases Using Record Level Locking. Which of the following are true when this option is checked?

Question: Which of the following is not a section of a report?

Question: The primary key index does not allow ________ data in a field.

Question: What is the file extension of an Access Project?

Question: If a relationship has the 'Cascade Update Related Fields' option on, which of the following is true?

Question: Which of the following options most clearly defines the meaning of a bound HTML Control on a Data Access Page?