Deck 14: Using Forms and Reports in Access

Question 1

When navigating a main form,pressing ________ will move the cursor to the first field of the current record.

A) Home
B) End
C) Tab
D) Ctrl + Home

Answer 1

A

Question 2

When navigating a main form,pressing ________ will move the cursor to the last field of the current record.

A) Home
B) End
C) Tab
D) Ctrl + Home

Answer 2

B

Question 3

When editing a main form,pressing ________ will move the cursor to the last record of the table.

A) Home
B) End
C) Enter
D) Ctrl + End

Answer 3

D

Question 4

When you create a form from two tables that have a one-to-many relationship,the first table selected becomes the main form and the second table you select becomes the ________.

A) joined form
B) co-form
C) split form
D) subform

Question 5

Which of the following is NOT true when changing a form theme?

A) Once a theme is applied to the form, the colors and fonts can be changed independently of the theme, so you can combine the colors of one theme and a font of another.
B) Changing the theme will not only change the colors of the form but also the font type and size and any border colors or object colors added to the form.
C) Because the form is displayed in Form view, once it is created, the first step is to switch to Layout view to make changes to the form itself.
D) By default, Access uses the Office theme when you create a form using AutoForm.

Question 6

A ________ control may be the name of the field or some other text you manually enter.

A) label
B) bound
C) calculated
D) text box

Question 7

If you can see the blinking insertion point in a field,you are in ________.

A) Design view
B) Navigation mode
C) Layout view
D) Edit mode

Question 8

Which of the following is NOT true about navigating forms?

A) A form is an object in Access that you can use to enter, edit, or view records in a table.
B) Often seeing one record at a time in a form can eliminate data entry errors and allow the user to focus on the information for that particular record.
C) A simple form allows you to see records one at a time rather than as a group in Datasheet view.
D) You navigate records in a form the same way you navigate a table, using buttons on the Arrow bar to move from record to record.

Question 9

________ allows you to move from record to record and field to field using keystrokes.

A) Design view
B) Navigation mode
C) Layout view
D) Edit mode

Question 10

Which of the following is NOT true about editing,adding,and deleting records?

A) If the table is part of a relationship, referential integrity has not been enforced, and the cascade delete option has been chosen, a record cannot be deleted if there are related records in another table until those records have also been deleted.
B) Changes to data are saved automatically.
C) When you add a record to a form, you are actually adding the record to the table it will be stored in.
D) Records can be deleted from a single table without additional steps if the table is not part of a relationship.

Question 11

A ________ is a built-in combination of colors and fonts.

A) Form Wizard
B) template
C) control
D) theme

Question 12

A(n)________ control is a control that does not have a source of data such as the title of the form.

A) unbound
B) bound
C) calculated
D) text box

Question 13

When the text of a field is selected and highlighted,you are in ________.

A) Design view
B) Navigation mode
C) Datasheet view
D) Edit mode

Question 14

Which of the following is NOT true about modifying a form's design?

A) Customizing forms can make them more personal and sometimes easier to use.
B) Controls can also be added to a form to include additional fields or labels with text.
C) Pictures and other objects can also be added to a form, but can make the form too difficult to use.
D) Oftentimes, forms are customized to match company or group color themes.

Question 15

Which of the following is NOT true about multiple-table forms?

A) The main form will display the first table one record at a time, just like a single-table form.
B) Access will automatically use the common field between the tables to create the form.
C) Before you can use two tables in a form, you must make sure there is a one-to-many relationship between the tables.
D) The subform will display "one" record in the one-to-many relationship.

Question 16

When navigating a main form,pressing ________ will move the cursor from field to field within a record.

A) Home
B) End
C) Tab
D) Ctrl + Enter

Question 17

There are ________ major kinds of form controls.

A) two
B) three
C) four
D) five

Question 18

Which of the following is NOT true regarding split forms?

A) You can highlight a different record in the form part and the datasheet part at the same time.
B) You can view one record at a time at the top of the window, and see the whole table in Datasheet view at the bottom of the window.
C) This kind of form is helpful when you want to work with one record at a time and still see the big picture in the main table.
D) In a split form, there are buttons on the Navigation bar to move only from record to record, and each record shown at the top is the record highlighted in the datasheet at the same time.

Question 19

A(n)________ control is a control whose data source is a field in the table such as the customer name.

A) unbound
B) bound
C) calculated
D) text box

Question 20

A ________ control is a control whose data source is an expression that you create.

A) label
B) bound
C) calculated
D) text box

Question 21

Which of the following is NOT true about creating a report using the Report Wizard?

A) Once a report is created using the wizard, it will open in Design view.
B) In the Report Wizard, you can choose the table or query to base the report on, and choose the fields to include in the report.
C) In the Report Wizard, you have the option to group the data in your report.
D) The Report Wizard will walk you step by step through the process of building your report.

Question 22

Which of the following is NOT true when resizing and managing controls?

A) When you click a control in Form view, an orange border appears around the control.
B) Controls can be resized to make the form more user friendly.
C) When you create a form using the wizard, the order that you choose the fields in the wizard step is the order the fields are added to the form.
D) Once the control is selected, you can move it or resize it.

Question 23

Print Preview adds the ________ to the page footer at the bottom of every page.

A) file name
B) current date and page numbers
C) creator's name
D) file path

Question 24

Datasheet view shows all the fields and records at one time,which provides all the information you need to update your data,unlike in a form or query,where some of the fields or records may not be in view.

Question 25

Which of the following is NOT true about adding pictures to a form?

A) When a picture is added to a form, then the same picture will appear for every record in the table.
B) A picture can be inserted in the header, footer, or the Detail area of the form where the record values are shown.
C) A different picture can be added for each record.
D) Pictures can be added to forms to make them more appealing.

Question 26

________ allows you to modify the report while seeing the data.

A) Layout view
B) Print Preview
C) Report view
D) Design view

Question 27

Design view shows all the records and fields at one time,which is one advantage to using it to update your records.

Question 28

________ allows you to filter data or copy parts of the report to the Clipboard.

A) Layout view
B) Print Preview
C) Report view
D) Design view

Question 29

When resizing and managing controls,the ________ allows you to move the whole table at one time.

A) subform control
B) Layout Selector
C) control selector
D) Form Wizard

Question 30

Keystroke mode allows you to move from record to record and field to field using keystrokes.

Question 31

Groups are added to a section of the report called the ________.

A) page header
B) page footer
C) group header
D) group footer

Question 32

Calculations performed on a group in a report are added to a section called the ________.

A) page header
B) page footer
C) group header
D) group footer

Question 33

A(n)________ file is usually smaller than the original document,and is easy to send through e-mail.

A) Word DOCX
B) Adobe PDF
C) Excel XLSX
D) PowerPoint PPTX

Question 34

________ allow you to separate related records for the purpose of creating a visual summary of the data.

A) Groups
B) Subtotals
C) Footers
D) Headers

Question 35

To update data in a table,you must be in Edit mode.

Question 36

To calculate totals for smaller groups of records,use ________.

A) the grand total
B) subtotals
C) a footer
D) text box

Question 37

Which of the following is NOT true about creating groups in a report?

A) Grouping allows you to separate related records for the purpose of creating a visual summary of the data.
B) Groups can only be created with data from individual tables.
C) A group is a collection of records along with introductory and summary information about the records.
D) In the Report Wizard, you will have the option to group the data in your report.

Question 38

When the Report Wizard has finished creating the report,it shows you the report in ________.

A) Layout view
B) Print Preview
C) Report view
D) Design view

Question 39

A report can be created from all of the following EXCEPT:

A) one table.
B) a form.
C) multiple tables.
D) a query.

Question 40

________ allows the specification of rules that apply formatting to cells or specific controls,as determined by the rule outcome.

A) A theme
B) Conditional formatting
C) A control
D) A group header

Question 41

An advantage to editing data in a table is that the number of records and/or fields in the datasheet can be overwhelming.

Question 42

A disadvantage to editing data in a form is that some fields may be missing.

Question 43

When you create a form from two tables that have a one-to-many relationship,the first table selected becomes the subform and the second table you select becomes the main form.

Question 44

A text box control represents the actual value of a field and is an unbound control.

Question 45

Changes to data are saved automatically,but can be undone while the table or form is open by using the Undo button.

Question 46

There are three major kinds of controls: inbound,unbound,and calculated.

Question 47

A calculated control is a control whose data source is a calculated expression that you create.

Question 48

When you enter data in a form,it is stored in the form and not the table.

Question 49

A subform is a form created from one table,but it has a Form view and a Datasheet view in the same window.

Question 50

A control is a part of a form or report that you use to enter,edit,or display data.

Question 51

If you want to delete a customer from tblCustomer when referential integrity is turned on,and that customer has appointments in tblSchedule,then the appointments for the customer have to be deleted from the tblCustomer first.

Question 52

A split form is a form created from one table,but it has a Form view and a Datasheet view in the same window.

Question 53

In a split form,there are buttons on the Navigation bar to move only from record to record,and each record shown at the top is the record highlighted in the datasheet at the same time.

Question 54

Deleting records in a table is permanent.

Question 55

A form with a subform allows you to see one record at a time from the main form and multiple records in Datasheet view from the other related table.

Question 56

You can use the Find command to find data in a form.

Question 57

When navigating forms with a subform,the Navigation bar buttons at the bottom of the main window are used to navigate the records in the main form,and a second Navigation bar at the bottom of the subform datasheet is used to navigate the records in the subform.

Question 58

Form view is only for viewing data,so to make any changes to the form you need to switch to either Print Preview or Design view.

Question 59

An advantage to editing data in a query is that there may be fewer records and/or fields in the datasheet making the data more manageable.

Question 60

A split form is helpful when you want to work with one record at a time and still see the big picture in the main table.

Question 61

________ view allows you to make changes to the form while viewing the data at the same time.

Question 62

A theme is a built-in combination of colors and fonts.

Question 63

________ mode allows you to edit,or change,the contents of a field.

Question 64

A(n)________ is a part of a form or report that you use to enter,edit,or display data.

Question 65

When navigating a subform,pressing ________ will move the cursor to the last field of the last record of the subform.

Question 66

A(n)________ is a form created from one table,but it has a Form view and a Datasheet view in the same window.

Question 67

Report view provides an interactive view of your report without page breaks.

Question 68

A(n)________ control is a control whose data source is an expression that you create.

Question 69

A split form is created from one table and displays each record individually at the top of the window and then again as part of the whole table datasheet in the bottom of the window.

Question 70

To break a report into smaller sections,subtotals or groups may be added.

Question 71

When navigating a subform,pressing ________ will move the cursor to the last field of the current record in the subform.

Question 72

When navigating a main form,pressing ________ will move the cursor from field to field within a record.

Question 73

A(n)________ control is a control whose data source is a field in the table such as the customer name.

Question 74

When the Report Wizard is done creating the report,it shows you the report in Layout view.

Question 75

A form with a(n)________ allows you to see one record at a time from the main form and multiple records in Datasheet view from the other related table.

Question 76

________ mode allows you to move from record to record and field to field using keystrokes.

Question 77

A(n)________ control may be the name of the field or some other text you manually enter and is an unbound control.

Question 78

Before you can use two tables in a form,you must make sure there is a one-to-one relationship between the tables.

Question 79

When navigating a main form,pressing ________ will move the cursor to the first field of the current record.

Question 80

Changing the theme will not only change the colors of the form,but also the font type and size and any border colors or object colors added to the form.