Databases - Upwork

Question: What role does Strcomp function perform in Microsoft Access 2003?
A
It compares the length of two strings and returns the value 1 if the difference is even and the value 0 if the difference is odd

B
It compares the number of capital letters, small letters and spaces in two strings and returns the result as an integer between 0 and 255

C
It compares the number of blank spaces contained in two different strings and returns the difference as an integer

D
It compares two strings for equivalence and returns the integer result of the comparison

Note: not sure
1. Report
Question: Which of the following enhanced security features are included in Access 2003?
A
Enhanced security features to help decrease the chances of Access 2003 being targeted in malicious attacks

B
Enhanced security features for Microsoft Jet functions

C
Digital signatures

D
All of these above

Note: not sure
1. Report
Question: Which form property determines whether the current record has been modified since it was last saved?
A
Dirty property

B
LocationOfComponents Property

C
Dependencies Property

D
ServerFilterByForm Property

Note: not sure
1. Report
Question: What is Option Explicit?
A
It is a Database object

B
Requires variable declarations

C
It contains all of the data access pages that are currently open in a Microsoft Access project.

D
It contains all open standard modules and class modules in a Microsoft Access database.

Note: not sure
1. Report
Question: What property for a table is used to locate the back-end database, to which the table is linked?
A
Dependencies Property

B
TableDefs Connect property

C
LinkChildFields Property

D
TableDefs orderbyon property

Note: not sure
1. Report
Question: A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a query named Query1, which combines the data from the tables. If the Products table is deleted, what will happen when users run Query1?
A
Only the data of the Products table will be retrieved.

B
Only the data of the Orders table will be retrieved.

C
An error will be generated.

D
The data will be successfully retrieved.

Note: not sure
1. Report
Question: How do you create a report for a crosstab query if certain column headings are missing?
A
Set the Value field in the crosstab

B
Set the Column Heading field in the crosstab

C
Set the Row Heading field in the crosstab

D
Explicitly set the Pivot list in the crosstab

Note: not sure
1. Report
Question: Which clause will be used to display the rows of a table in an ascending order of a particular column?
A
Where

B
Order By

C
Group By

D
Having

Note: not sure
1. Report
Question: How can you tell if a report has no records to display or print?
A
NotInList event is triggered

B
ApplyFilter event is triggered

C
NoData event is triggered

D
Filter event is triggered

Note: not sure
1. Report
Question: Which property of a table is used to locate the back-end database to which the table is linked?
A
Dependencies Property

B
TableDefs Connect property

C
LinkChildFields Property

D
TableDefs orderbyon property

Note: not sure
1. Report

First Prev 82 83 84 85 86 Next Last

Question: What role does Strcomp function perform in Microsoft Access 2003?

Question: Which of the following enhanced security features are included in Access 2003?

Question: Which form property determines whether the current record has been modified since it was last saved?

Question: What is Option Explicit?

Question: What property for a table is used to locate the back-end database, to which the table is linked?

Question: A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a query named Query1, which combines the data from the tables. If the Products table is deleted, what will happen when users run Query1?

Question: How do you create a report for a crosstab query if certain column headings are missing?

Question: Which clause will be used to display the rows of a table in an ascending order of a particular column?

Question: How can you tell if a report has no records to display or print?

Question: Which property of a table is used to locate the back-end database to which the table is linked?