Question 1

Page breaks display in the Report view.

Accepted Answer

Page breaks are not displayed in the Report view; they are used for printing or print layout view and do not appear in the standard report viewing mode.

Question 2

Reports can ONLY be created from a table.

Accepted Answer

Reports can be created from multiple sources such as tables, queries, forms, and even a combination of them.

Question 3

The view that offers more options for adding and editing controls on a report,including options not available in any of the other views is the Design view.

Accepted Answer

Design view allows for more customization and control over a report's layout and functionality than the other views.

Question 4

If a data text box on a report displays ########,the field is not wide enough to display all the date.

Accepted Answer

The # symbol is often used as a placeholder when a field is not wide enough to display the entire value. Therefore, if a data text box on a report displays ########, it means that the field is not wide enough to display all the data.

Question 5

To add a theme to a form,you MUST first change to Layout view.

Accepted Answer

In Layout view, you can access the design tools needed to add a theme to the form. In Form view, you can only interact with the finished form as a user.

Question 6

In a split form,you cannot highlight a different record in the form part and the datasheet part at the same time.

Accepted Answer

In a split form, the form part and the datasheet part are linked, so highlighting a different record in each part is not possible.

Question 7

When you add pictures to a form,a different picture CANNOT be added for each record.

Accepted Answer

When you add pictures to a form, the same picture will be displayed for each record. It is not possible to add a different picture for each record using this method.

Question 8

When records are deleted from a form,they are actually deleted from the query it is stored in.

Accepted Answer

When records are deleted from a form, they are actually deleted from the underlying table or database that the form is connected to, not from a query. Queries display data based on their criteria, but deleting records from a form affects the data source directly.

Question 9

A label CANNOT be added unless you also add a text box.

Accepted Answer

A label can be added without a text box, but a text box cannot be added without a label.

Question 10

When you create a report from one table,it is a single table report.

Accepted Answer

When you create a report from one table, it will only display data from that table, making it a single table report.

Question 11

When you add a label to a footer,you must manually expand it to fit the text.

Accepted Answer

Most modern software and web development frameworks automatically adjust the size of a footer to accommodate the content, including labels, without manual intervention.

Question 12

To make a form more visually appealing,you can add pictures and images.

Accepted Answer

Adding pictures and images to a form can make it more visually appealing by breaking up text and adding interest to the overall design.

Question 13

Controls are used on reports,but are NOT used on forms.

Accepted Answer

Controls are used on both reports and forms in order to interact with data and display information in a structured way.

Question 14

If you CANNOT see the entire form on the screen,you need to reduce the form size.

Accepted Answer

You need to adjust the zoom level or resolution of your screen, not necessarily reduce the form size itself. Reducing the form size might make it harder to interact with or read the form's content.

Question 15

A bound control is a control that does NOT have a source of data such as the title of the form.

Accepted Answer

A bound control is a control that is bound to a data source such as a field in a database or a property of an object. Controls that do not have a source of data, such as labels or textboxes used for headers or instructions, are considered unbound controls.

Question 16

When you create a form using two tables with a one-to-many relationship between the tables,Access will automatically use the common field between the tables to create the form.

Accepted Answer

Access will use the common field between the tables as the linking field to create the form.

Question 17

You should add fields to the report wizard in the order in which you want the fields to appear in the report.

Accepted Answer

By adding fields to the report wizard in the desired order, you can ensure that the report layout fits your specific needs and displays the information in a clear and organized manner.

Question 18

A split form displays data from two different tables,with the information from the main table at the top of the window,and the information from the secondary form in the bottom of the window.

Accepted Answer

A split form displays data from the same table in two different views: a form view and a datasheet view, not from two different tables.

Question 19

In a report,you can change the appearance of a control by adding borders or fill color.

Accepted Answer

This is true. By adding borders or fill color to a control in a report, you can change its appearance. This can be done in the report design view by selecting the control and accessing its properties.

Question 20

Once you have created a form,you must change to the Layout view or the Design view to make changes to the form.

Accepted Answer

This is true. Once a form is created, you must switch to the Layout or Design view to make modifications or changes.

Quiz 8: Microsoft Access 2010,workshop 4: Maintaining and Presenting Data