Question 1

When Access creates a form with two related record sources,the main form is displayed with a stacked layout,while the subform with a datasheet layout.

Accepted Answer

When a form with two related record sources is created in Access, the main form displays the data in a stacked layout and the related subform displays the data in a datasheet layout.

Question 2

Which of the following is NOT a form view?&#10;A) Form&#10;B) Edit&#10;C) Layout&#10;D) Design

Accepted Answer

B

Question 3

A report can be saved as a PDF file so users without Access can view it.

Accepted Answer

This is true. Access allows you to save reports as PDF files, which can be viewed by users who do not have Access installed on their computers.

Question 4

Which of the following is NOT a report view?&#10;A) Report&#10;B) Design&#10;C) Layout&#10;D) Print

Accepted Answer

All the other options (Report, Design, Layout) are report views in Microsoft Access. However, "Print" is not a report view. It is a command used to print the report in the chosen view.

Question 5

Pmt is an example of a(n)________.&#10;A) parameter&#10;B) function&#10;C) argument&#10;D) subroutine

Accepted Answer

Pmt is a built-in function in Microsoft Excel used to calculate the payment for a loan based on constant payments and a constant interest rate. It is not a parameter or argument passed into a function or subroutine, and it is not a subroutine itself.

Question 6

The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3)will appear in a column with the heading ________.&#10;A) PricePerRoom&#10;B) ListPrice&#10;C) Beds&#10;D) Baths

Accepted Answer

The formula PricePerRoom calculates the price per room based on the ListPrice, Beds, and Baths. Therefore, the column heading for the results should be PricePerRoom.

Question 7

You can sort the data in a form by double-clicking a field and selecting Sort A to Z or Sort Z to A.

Accepted Answer

Sorting data by double-clicking a field is not a standard feature in most software applications. Sorting is typically done through menu options or by clicking on column headers.

Question 8

When Access creates a form with two record sources having a one-to-many relationship,the one record source is displayed in the main form and the many record source is display in a ________.&#10;A) subform&#10;B) report&#10;C) query&#10;D) register

Accepted Answer

When Access creates a form with two record sources having a one-to-many relationship, the many record source is displayed in a subform that is embedded in the main form. Therefore, the best choice is A - subform. The other options (B, C, and D) do not accurately reflect the way Access displays related records in a form.

Question 9

Changes to data in a form are made in design view.

Accepted Answer

Changes to data in a form are made in either form view or data entry view, not design view. Design view is used to make structural changes to the form itself, such as adding or removing fields.

Question 10

Which database object is used to add data into or edit data in a table?&#10;A) report&#10;B) query&#10;C) form&#10;D) macro

Accepted Answer

A form is typically used to add new data into a table or edit existing data. It provides a user-friendly interface to input and view data in the table. Reports are used to present data already in the table, queries are used to retrieve data from the table based on specified criteria, and macros are used to automate tasks or perform a series of actions in the database.

Deck 4: Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos