How can we help?

You can also find more resources in our Help Center.

40 terms

Advance Database True/False

STUDY
PLAY
True
In Datasheet view, an Attachment field appears as a paper clip rather than the field name.
False
A hyperlink field can contain only links to Web pages.
True
When entering data in a field that has an input mask, Access will insert the appropriate special characters in the proper positions.
False
When you enter data in a memo field, Access automatically expands the row and column to display all the data in the field.
False
Rows in a datasheet may be different sizes.
True
When you insert data in an OLE field, you either can create a new object or insert an already created object in the field.
False
Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.
False
Any row and column spacing changes made to a datasheet are saved automatically when you close the table.
False
To select more than one control at a time on a form, press and hold down the ALT key as you select additional controls.
True
You can use the ruler to select multiple controls.
True
When a form includes a subform, the subform is a separate object in the database.
False
In the accompanying figure, the portion of the picture that appears as well as the way it appears is determined by the size mode. The Stretch size mode is the best option for photographs.
True
In the accompanying figure, the portion of the picture that appears as well as the way it appears is determined by the size mode. With the Zoom size mode, the entire picture will appear and be proportioned correctly.
True
In the accompanying figure, the portion of the picture that appears as well as the way it appears is determined by the size mode. To change the size mode, use the property sheet.
False
Access only allows you to change the font and font size for a label on a form.
False
You cannot change the size of the property sheet.
False
Once the tab order for fields is determined, it cannot be changed.
True
A form that contains a subform includes navigation buttons for both the form and subform.
True
You can create new Access tables in either Datasheet view or Design view.
False
If you link an Excel workbook to an Access database, you can edit the linked table in Access.
False
When you create a report in Design view, the initial report that displays in the Design window contains all the fields in the underlying table or query.
True
To create a new query, click the Query Design button on the Create tab.
False
To display the Expression Builder dialog box, click the Build Expression button on the Design tab.
True
The record source for a report is the table or query that will furnish the data for the report.
False
You can move a property sheet box but you cannot resize it.
False
A report contains three types of controls: bound controls, unbound controls, and formatted controls.
True
The process of converting an unbound control to a bound control is called binding.
False
To concatenate strings, you use the asterisk (*) operator.
True
The process of combining two or more text data items into a single expression is called concatenation.
True
To ungroup controls, use the Ungroup button on the Size/Space button menu on the Arrange tab.
True
The subreport appears as a separate report in the Navigation Pane.
False
If the Can Shrink property is set to No, Access will remove blank lines that occur when the field is empty.
True
To cause the contents of the Group Header section to appear at the top of each page, change the Repeat Section property to Yes.
False
To add a page number to a report, use the Report Footer button.
True
When you use the Title button to add a title to a report, the title is the same as the name of the report object.
True
If a name is too long to fit in the available space, change the Can Grow property to Yes so that the name will extend to additional lines.
False
To display the Group, Sort, and Total pane, click the Group Report button.
False
To find the largest value, use the LARGE aggregate function.
True
To add totals or other statistics to a footer, add a text box control.
True
To change the report margins, use the Margins button on the Page Setup tab.