Access Chapter 4

What is not a common format for a number control? A) Currency B) Accounting C) Comma D) Percent

Which of the following is not considered one of the most common methods to create a form? A) Form Design B) Default Form C) Blank Form D) Form Wizard

What is not true about a report? A) It is designed to display only one record at a time. B) It can be sorted independently of its data source. C) It can be previewed before it is printed. D) Its record sources include one of more tables or a query.

Pressing the Ctrl key plus what other key enables you to select all the controls on a form? A) C B) A C) X D) Y

What type of form control is normally used to display data? A) Text box B) Data C) Label D) Button

What is not found on the Data Group on Print Preview tab? A) Portrait B) Excel C) Email D) Text File

What can you not do with an Access report? A) Saved as a Word document B) Edit data C) Print it D) Viewed onscreen

What is not a valid reason to edit a form's layout? A) Unused fields need to deleted. B) The user's needs have changed. C) Extra fields need to be added (just in case they will be needed later). D) New fields need to be added.

Which of the following is not a primary consideration when designing a report? A) How many pages long the report will be B) Who will use the report C) What information will be needed in the report D) The purpose of the report

When modifying a report, on which tab would you find the commands for changing the margins of the report? A) Design B) Arrange C) Format D) Group

What is the advantage of saving a report as a PDF file? A) It opens more quickly for other Microsoft Office users. B) More people can open the file. C) It compresses more tightly. D) It is smaller.

Which of the following can you not do if you use a query as the record source for a form? A) Lock your form so that it cannot be edited B) Filter the records C) Limit the number of fields in the table which are displayed D) Combine records from multiple tables

Which form (which will include the existing fields from the data source) can be created with just one click? A) Tabular layout B) Form Wizard C) Stacked layout D) Blank Form

When running a report, which sort order takes precedence? A) Underlying form B) Report C) Underlying query D) Underlying table

Which tab is not available for modifying a report? A) Design B) Arrange C) Format D) Group

Which form tools creates a box asking for user input? A) Navigation B) Form Wizard C) Modal Dialog D) Datasheet

Which of the following is not true? A) All text boxes should be the same length for consistency of look B) Provide a visual separation between the primary key and the rest of the form C) Changing the color of a border adds contrast D) Adding a bright color draws attention to a field

Which of the following is not a form tool that is available in Access 2016? A) Split Form B) Multiple Form C) Form Design D) Form

How many other forms does the More Forms list provide? A) 2 B) 3 C) 4 D) 5

In Office 2016, Access provides how many tools for creating forms? A) 6 B) 14 C) 8 D) 10

How many reporting tools does Access 2016 provide? A) Six B) Eleven C) Four D) Five

Which of the following is not a report view? A) Report view B) SQL view C) Layout view D) Design view

What is not a group on the Report Layout Tools Format tab? A) Font B) Fields C) Background D) Number

Which view is normally used for data entry? A) SQL view B) Design view C) Form view D) Layout view

What does PDF stand for? A) Portable Document File B) Portable Document Format C) Public Document File D) Public Document Format

Which of the following is not recommended as a professional way of styling a form? A) Separate the primary key from the rest of the form B) Use several fonts to indicate different types of data C) Left-align the text boxes D) Right-align the labels

What can you not easily do using a form? A) Enter data B) Delete data C) Edit data D) Move data

How many navigation form layouts are available? A) Four B) Five C) Six D) Seven

Which of the following cannot be included on a form? A) Sub report B) Drop-down list C) Check box D) Button

Which of the following is not a form view? A) Form view B) SQL view C) Layout view D) Design view

What is not found on the Report Layout Tools Arrange tab? A) Move Up B) Insert Right C) Insert Existing Field D) Insert Left

Which of the following is not true of a form? A) It can be sorted independently of its data source. B) It is the most common method of entering data. C) It can only display one record at a time. D) It can contain background images.

What is not an option in the Layout Options for Grouped Data in the Report Wizard? A) Block B) Outline C) Multi-level D) Stepped

Normally when you Print Preview a report it will generate a report with how many pages? A) All the pages only if they will all fit on the screen at one time B) All the pages C) Only the first page D) Only the first two pages

What is a popular label producing company? A) Easy Labels B) Avery C) MakeIt Labels D) Okidata

The ________ tool enables you to create a form using a tabular layout.

The Form ________ tool enables you to create a form in design view.

When creating a form, Access might automatically add a(n) ________ if more than one table is related

The most common method of finding information in a database is through the use of a(n) ________.

Click ________ & Sort to add sorting to a report

Match the following terms with their description: I. Subform II. Subreport III. Subquery IV. Datasheet format V. SubForm Wizard A. Provides an easy way to add a subform to form B. This does not exist in Access. C. Displays data in a grid like Excel D. Displays related record on a form E. Displays related records on a report

The Form ________ tool enables you to create a form by answering a series of questions.

The ________ tool enables you to create a user-interface which works on the Internet.

To give your forms a more professional and consistent appearance you might want to apply a(n) ________.

Buttons, text boxes, and other tools that are found on a form are called ________.

Match the following terms with their description: I. Form view II. Design view III. Layout view IV. Views group V. Print preview A. Used to make advanced changes to a form B. Often keeps you from wasting paper C. Enables changes while viewing actual data D. Used for data entry E. Found on the Home tab

Match the following terms with the group in which they are found on the Create tab: I. Form Design II. Module III. Application Parts IV. Query Design V. SharePoint Lists A. Queries B. Forms C. Macros & Code D. Templates E. Tables

Most reports do not use the ________ layout because it makes the report longer than the alternative.

The ________ control helps you keep your form looking neat and professional by keeping the other controls aligned properly.

Using a(n) ________ as the record source for a form enables you to pick and choose what fields will be included on the form.

The ________ Form tool enables you to create a form in Layout view.

The ________ tool is the tool most often used to create forms.

A(n) ________ outputs data in a meaningful way to those who view them.

Match the following terms with their description: I. Form II. Application Parts III. Record source IV. Stacked layout V. Tabular layout A. Used to build database objects B. Fields are displayed in a vertical column C. Fields are displayed in horizontal columns D. A user-friendly interface E. Supplies the records for a form or report

One way a company can help its employees transition to the digital world of data collection is to match the look of the forms created in Access with the company's existing ________ forms.

If you wanted the most freedom in creating a report you would use the ________ tool.

Match the following terms with their description: I. Split form II. Multiple items form III. Property sheet IV. Sub form V. Dual Record form A. Controls the behavior of the form B. Displays related records C. Two views of the same record source D. Not available in Access E. More than one record is displayed.

The most common method of entering data into a database is through the use of a(n) ________.

Match the following form tools with their description: I. Form II. Form Design III. Split Form IV. Datasheet V. Switchboard A. Immediately creates a blank form with a stacked layout B. Immediately creates a blank form in Design view C. Creates a form that looks like a table in its normal view D. Includes a stacked layout and a tabular layout in two different sections of the form E. This is not an Access Form tool.

Match the following terms with their description: I. Report Layout Control II. Form controls III. Controls IV. Control Wizard V. Text controls A. Used to keep a uniform look on a form B. This does not exist in Access. C. Used to display values D. Items such as labels and text boxes E. Used to keep a uniform look on a report

Match the following groups with the tabs on which they are found: I. Tables II. Find III. Themes IV. Print V. Rows & Columns A. Design B. Print Preview C. Create D. Arrange E. Home

The default sort order in reports is ________.

Match the following terms with their description: I. Control II. Theme III. Form IV. Report V. Record Source A. Helpful way of displaying data from multiple records B. A consistent set of colors and other formatting which can be applied to a report or form C. Used to display data in a form or report D. Main data entry object E. Determines what data can display in a form or report

Match the following terms with their description: I. Label Wizard II. Form Wizard III. Report Wizard IV. SubForm Wizard V. SubReport Wizard A. Simplified way to create forms B. Simplified way to create subforms C. Simplified way to create reports D. Used to create name tags E. This does not exist in Access.

When you make changes to data in a form, the data in the underlying ________ are affected.

True or False: A multiple items form shows more than one record at one time instead of the one record which is normally displayed in a form.

True or False: It is an acceptable practice to begin entering data before all the database objects have been tested because Access 2016 enables the user to edit data very easily.

True or False: The sort order in a report's source overrides any sort order applied to the report.

True or False: On a form, the text box and its label would be considered two different controls.

True or False: Most forms allow you to enter data into more than one record at a time.

True or False: If you want to resize just a few controls on a form they must be removed from the Layout control.

True or False: You can use the SubForm Wizard to add a subform to an existing form.

True or False: Mailing labels are considered reports in Access 2016

True or False: A record source and a data source are not the same

True or False: Data cannot be changed in Report view.

True or False: Good forms need to balance efficiency with a user-friendly interface.

True or False: The default sort order for a table is by its primary key.

True or False: All database objects should be tested before the database is deployed.

True or False: If a field is found in a query then it must be included in any report based on that query. If you do not want the field displayed, you can set its view property to hidden.

True or False: Sketching out a form's layout on paper is often a helpful first step in designing an Access form.

True or False: One advantage to using a form is that you can display data from more than one table at the same time.

True or False: The easiest way to find information is to search the table directly.

True or False: If a form is designed properly it will not have to be changed once data entry has begun.

True or False: You can edit data in form layout view.

True or False: There is no way to make sure that a record cannot be deleted.