Deck 4: Creating and Using Professional Forms and Reports

Question 1

Which of the following is not recommended as a professional way of styling a form?

A) Use several fonts to indicate different types of data
B) Left-align the text boxes
C) Separate the primary key from the rest of the form
D) Right-align the labels

Answer 1

A

Question 2

Which of the following is not a good reason for using a form for data entry?

A) Data you enter in a form must then be transferred to the table.
B) You probably will not edit the wrong record.
C) You can show data from more than one table at a time.
D) Your form can resemble paper forms.

Answer 2

A

Question 3

In Office 2016, Access provides how many tools for creating forms?

A) 6
B) 8
C) 10
D) 14

Answer 3

D

Question 4

What can you not easily do using a form?

A) Enter data
B) Edit data
C) Move data
D) Delete data

Question 5

What is not a valid reason to edit a form's layout?

A) New fields need to be added.
B) Unused fields need to deleted.
C) Extra fields need to be added (just in case they will be needed later).
D) The user's needs have changed.

Question 6

How many navigation form layouts are available?

A) Four
B) Five
C) Six
D) Seven

Question 7

Which of the following cannot be included on a form?

A) Check box
B) Sub report
C) Drop-down list
D) Button

Question 8

Which of the following is not considered one of the most common methods to create a form?

A) Default Form
B) Form Wizard
C) Blank Form
D) Form Design

Question 9

What type of form control is normally used to display data?

A) Text box
B) Label
C) Data
D) Button

Question 10

Which form view enables you to make changes to how the form looks at the same time that you are looking at actual data?

A) Design view
B) Layout view
C) Form view
D) SQL view

Question 11

How many other forms does the More Forms list provide?

A) 2
B) 3
C) 4
D) 5

Question 12

Which of the following is not a form view?

A) Form view
B) Design view
C) Layout view
D) SQL view

Question 13

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) Combine records from multiple tables
D) Limit the number of fields in the table which are displayed

Question 14

What is not a common format for a number control?

A) Currency
B) Accounting
C) Percent
D) Comma

Question 15

Which form tools creates a box asking for user input?

A) Modal Dialog
B) Datasheet
C) Navigation
D) Form Wizard

Question 16

Which view is normally used for data entry?

A) Design view
B) Layout view
C) Form view
D) SQL view

Question 17

Pressing the Ctrl key plus what other key enables you to select all the controls on a form?

A) A
B) X
C) C
D) Y

Question 18

Which of the following is not a form tool that is available in Access 2016?

A) Form
B) Multiple Form
C) Form Design
D) Split Form

Question 19

Which of the following is not true of a form?

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

Question 20

Which form (which will include the existing fields from the data source) can be created with just one click?

A) Tabular layout
B) Stacked layout
C) Blank Form
D) Form Wizard

Question 21

What does PDF stand for?

A) Public Document Format
B) Portable Document Format
C) Public Document File
D) Portable Document File

Question 22

How many reporting tools does Access 2016 provide?

A) Four
B) Five
C) Six
D) Eleven

Question 23

Which of the following is not recommended as a professional way of styling a form?

A) Use a serif font for labels and a sans serif font for text boxes
B) Use complimentary fonts for both labels and text boxes
C) Apply bold formatting to the labels
D) Right-align the labels

Question 24

When modifying a report, on which tab would you find the commands for changing what fields appear on the report?

A) Design
B) Arrange
C) Format
D) Group

Question 25

What is not found on the Data Group on Print Preview tab?

A) Excel
B) Text File
C) Portrait
D) Email

Question 26

What is not found on the Report Layout Tools Arrange tab?

A) Insert Left
B) Insert Right
C) Move Up
D) Insert Existing Field

Question 27

Which of the following is not a primary consideration when designing a report?

A) The purpose of the report
B) Who will use the report
C) What information will be needed in the report
D) How many pages long the report will be

Question 28

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

Question 29

What is the advantage of saving a report as a PDF file?

A) More people can open the file.
B) It is smaller.
C) It compresses more tightly.
D) It opens more quickly for other Microsoft Office users.

Question 30

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) Its record sources include one of more tables or a query.
D) It can be previewed before it is printed.

Question 31

What is not an option in the Layout Options for Grouped Data in the Report Wizard?

A) Multi-level
B) Stepped
C) Block
D) Outline

Question 32

When modifying a report, on which tab would you find the commands for adding a background image on the report?

A) Design
B) Arrange
C) Format
D) Page Setup

Question 33

Which of the following is not a report view?

A) SQL view
B) Report view
C) Design view
D) Layout view

Question 34

When running a report, which sort order takes precedence?

A) Underlying table
B) Report
C) Underlying query
D) Underlying form

Question 35

Normally when you Print Preview a report it will generate a report with how many pages?

A) Only the first page
B) Only the first two pages
C) All the pages only if they will all fit on the screen at one time
D) All the pages

Question 36

What can you not do with an Access report?

A) Print it
B) Viewed onscreen
C) Edit data
D) Saved as a Word document

Question 37

Which of the following is not true?

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

Question 38

What is a popular label producing company?

A) Easy Labels
B) MakeIt Labels
C) Avery
D) Okidata

Question 39

Which tab is not available for modifying a report?

A) Design
B) Arrange
C) Format
D) Group

Question 40

What is not a group on the Report Layout Tools Format tab?

A) Fields
B) Font
C) Number
D) Background

Question 41

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

Question 42

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

Question 43

The first step in creating a form is to determine the record ________.

Question 44

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

Question 45

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

Question 46

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.

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

The control that is used to describe the values in a text box is usually the ________ control.

Question 52

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

Question 53

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

Question 54

If you want to sort a form on multiple fields then you would use a(n) ________ as your record source and not the table.

Question 55

If you want more freedom as to where your controls are located on a form you need to remove the ________ control.

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

A record source and a data source are not the same.

Question 62

Click ________ & Sort to add sorting to a report.

Question 63

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

Question 64

Good forms need to balance efficiency with a user-friendly interface.

Question 65

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.

Question 66

All database objects should be tested before the database is deployed.

Question 67

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

Question 68

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

Question 69

The easiest way to find information is to search the table directly.

Question 70

The only people who really need to test new forms are the end users.

Question 71

________ will allow you to see what a report will look like before it is printed.

Question 72

There is no way to make sure that a record cannot be deleted.

Question 73

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

Question 74

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

Question 75

The default sort order in reports is ________.

Question 76

You can use the SubForm Wizard to add a subform to an existing form.

Question 77

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

Question 78

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

Question 79

A Split form shows two records at one time instead of the one record which is normally displayed in a form.

Question 80

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