Deck 5: Basic Forms and Reports

Question 1

What cannot be used as a record source?

A)A report
B)Table
C)Query
D)Multitable query

Answer 1

A

Question 2

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.

Answer 2

C

Question 3

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

Answer 3

A

Question 4

Which form view is normally used for data entry?

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

Question 5

Which of the following cannot be included on a form?

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

Question 6

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.

Question 7

What can you not easily do using a form?

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

Question 8

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

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

Question 9

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 10

Which of the following is not a form view?

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

Question 11

What is not true about a split form?

A)You can pick one record for the top and a different record for the bottom
B)Combines two views of the same record
C)Top section uses a stacked layout
D)Bottom section uses a tabular layout

Question 12

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 13

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

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

Question 14

What is not true about Navigation forms?

A)Can give the look and feel of web-based forms
B)Allows the quick navigation between objects in the database
C)Simplifies navigation for data-entry people
D)It is not designed to be changed after it is set up

Question 15

What is not true about print preview?

A)It shows what the report will look like if printed.
B)It allows you to change the layout of the report.
C)It will display all the pages by default.
D)The report can be exported from this view.

Question 16

What is not true about a multiple items form?

A)Displays multiple records in a stacked layout
B)Displays multiple records in a tabular layout
C)Allows more customization than a datasheet
D)Data appears similar to a datasheet

Question 17

What is not true about the Form Design view?

A)Gives access to advanced design settings
B)Gives more control over form design
C)It allows you to see live data while you edit the form.
D)Allows you to remove layout controls from a form

Question 18

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)Find Duplicates

Question 19

Which form layout displays the data horizontally across the page.

A)Tabular
B)Stacked
C)Horizontal
D)Subform

Question 20

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 21

What is not true about the label wizard?

A)Allows you to print name tags
B)Allows you to select from many label companies
C)It sets up a label mail merge file which actually prints through Microsoft Word
D)It is considered a specialized report

Question 22

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 23

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

Question 24

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 25

Which of the following is not a report view?

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

Question 26

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

Question 27

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 28

What does PDF stand for?

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

Question 29

The stacked layout displays data horizontally across the page.

Question 30

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

Question 31

When running a report,which sort order takes precedence?

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

Question 32

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 33

A record source and a data source are synonymous.

Question 34

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 35

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

Question 36

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

Question 37

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 38

The Report Wizard allows you to easily create a customized report.

Question 39

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

Question 40

Which control provides guides to keep your form neat?

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

Question 41

The default sort order for a table is by its primary key.

Question 42

The PDF format allows files to be shared without the recipient owning the program which created the file.

Question 43

Just as with forms,you can add,edit,or delete data in a report.

Question 44

The tabular layout displays data vertically across the page.

Question 45

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

Question 46

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.

Question 47

The Stacked Layout display data horizontally across the page.

Question 48

Navigation forms enable users to quickly navigate between the objects of a database.

Question 49

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

Question 50

Data can be changed in Report view.

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

The form Layout view gives the form designer the most flexibility in creating forms.

Question 56

You can edit data in Form Layout view.

Question 57

Mailing labels are considered reports in Access 2019.

Question 58

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 59

Design view allows less options for editing your form than Layout view?

Question 60

The sort order in a report's source overrides any sort order applied to the report.

Question 61

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

Question 62

A(n)________ is an Access object that outputs data in a meaningful way to those who view them.

Question 63

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

Question 64

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

Question 65

________ & Sort is used to add sorting to a report.

Question 66

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

Question 67

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

Question 68

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

Question 69

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 70

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

Question 71

The ________ view allows you to make changes to the form while viewing your actual data.

Question 72

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

Question 73

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 74

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

Question 75

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

Question 76

The form ________ view enables you to change advanced design settings.

Question 77

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

Question 78

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

Question 79

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

Question 80

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