Creating And Using Forms And Reports

This question bank verified by Studydeets

Questions Bank

Creating a Database and Tables
Using Design View, Data Validation, and Relationships
Creating and Using Queries
Creating and Using Forms and Reports
Templates, Advanced Relationships, and Macros
Creating Advanced Queries and Reports and Using SQL
Creating Advanced Forms
Integrating Applications
Designing and Managing Databases
Customizing Access and Using Skydrive and Office Web Apps

All Questions

Question 1

Free

True/False

Design view provides you with the most flexibility in creating forms.

Choose correct answer/s

True

False

Check answer

Question 2

Free

True/False

The Page Footer form section displays information when a form is printed,and is only visible in Design or Print Preview view.

Choose correct answer/s

True

False

Check answer

Question 3

Free

True/False

When you create a form in Design view,all sections,including the Detail section,are automatically added to the form.

Choose correct answer/s

True

False

Check answer

Question 4

Free

True/False

If you are unable to reduce the height of a section or the width of the form,it is because a control somewhere in the form requires the space.

Choose correct answer/s

True

False

Check answer

Question 5

Free

True/False

The order that Access navigates from one control to another is determined by the value in the Tab Stop property.

Choose correct answer/s

True

False

Check answer

Question 6

True/False

By default,the tab order is initially set based on the order that fields have been added to the form.

Choose correct answer/s

True

False

To unlock the question

Question 7

True/False

Focus determines whether the cursor stops at a control when the user presses Tab or Enter.

Choose correct answer/s

True

False

To unlock the question

Question 8

True/False

Setting the Enabled property to No does not affect the way the label displays.

Choose correct answer/s

True

False

To unlock the question

Question 9

True/False

In a one-to-many form,the main form displays data from the "one" side of the relationship.

Choose correct answer/s

True

False

To unlock the question

Question 10

True/False

If Access was not able to determine the correct linking fields between the subform and the main form or if you created an incorrect link,you can manually establish the link.

Choose correct answer/s

True

False

To unlock the question

Question 11

True/False

The linking fields are typically the primary key in the "one" table and the foreign key in the "many" table.

Choose correct answer/s

True

False

To unlock the question

Question 12

True/False

Because the subform uses a datasheet layout,it is possible to customize the font characteristics of individual fields on the subform.

Choose correct answer/s

True

False

To unlock the question

Question 13

True/False

Navigation buttons can be removed from any form.

Choose correct answer/s

True

False

To unlock the question

Question 14

True/False

When a calculated expression is longer than the size of the control,you can use the Expression Builder or Zoom window to see the entire expression.

Choose correct answer/s

True

False

To unlock the question

Question 15

True/False

To aggregate over a group of records on the subform,you must place the aggregate function calculation in the Detail section of the subform.

Choose correct answer/s

True

False

To unlock the question

Question 16

True/False

If you switch to Form view after adding the aggregate function onto the subform,you will not see any differences in the form.

Choose correct answer/s

True

False

To unlock the question

Question 17

True/False

The #Error error means that you have used a name for a field,control,form,or function that is not valid.

Choose correct answer/s

True

False

To unlock the question

Question 18

True/False

The #Error error indicates that Access can't evaluate the expression that provides the control's value.

Choose correct answer/s

True

False

To unlock the question

Question 19

True/False

You can save images as a .bmp file,which results in a smaller file size,instead of using a larger ·jpg file.

Choose correct answer/s

True

False

To unlock the question

Question 20

True/False

The Image button inserts an embedded image.

Choose correct answer/s

True

False

To unlock the question