Advance Database True/False
Order by
40 terms
Terms | Definitions |
|---|---|
 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. |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.