Deck 4: Workshop 4: Access Information From an Access Database

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

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

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

Answer 2

A

Question 3

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)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.
C)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.
D)A simple form allows you to see records one at a time rather than as a group in Datasheet view.

Answer 3

B

Question 4

Which of the following is NOT true about form views?

A)Data is not shown while you are in Design view.
B)Layout view allows you to make changes to the form while viewing the data at the same time.
C)To make any changes to the form you need to switch to either Layout view or Datasheet view.
D)Form view is only for viewing and changing data.

Question 5

There are ________ major kinds of form controls.

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

Question 6

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

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

Question 7

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

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

Question 8

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

A)Records can be deleted from a single table without additional steps if the table is not part of a relationship.
B)When you add a record to a form,you are actually adding the record to the table it will be stored in.
C)Changes to data are saved automatically.
D)If the table is part of a relationship,referential integrity has 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.

Question 9

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 $ + $Enter $

Question 10

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 11

When editing a main form,pressing ________ will move the cursor to the first character in the field.

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

Question 12

When editing a main form,pressing ________ will move the cursor to the last character in the field.

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

Question 13

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 14

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

A)joined form
B)main form
C)subform
D)split form

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

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 17

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

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

Question 18

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)subform
C)co-form
D)split form

Question 19

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 20

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 21

Which of the following is NOT true about enhancing a report with grouping and sorting?

A)The Report Wizard gives you the opportunity to sort and group records,but sometimes seeing the report changes your mind about what and how to group and sort.
B)You can change the sorting and grouping options from either Layout or Report view.
C)Groups are added to a section of the report called the group header.
D)Calculations performed on a group in a report are added to a section called the group footer.

Question 22

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

Question 23

Which of the following is NOT true about working with a report in Print Preview?

A)Print Preview provides a view of the report representing how it will look when it is actually printed and provides you with printing options such as orientation,margins,and size.
B)To make any changes to the report,you can work in Print Preview.
C)Once a report is created using the wizard,it will open in Print Preview.
D)The current date and page numbers are added,and you can navigate the report in this view using the Navigation bar.

Question 24

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)Pictures can be added to forms to make them more appealing.
D)A different picture can be added for each record.

Question 25

Which of the following is NOT true about saving a report as a PDF file?

A)If you need to distribute the report electronically,you also have the option to save the report as an Adobe PDF file.
B)The correct terminology for saving a report as a PDF file format is to "repurpose" the report.
C)An Adobe PDF file is usually smaller than the original document,is easy to send through e-mail,and preserves the original document look and feel so you know exactly what it will look like when the recipient opens it.
D)When you are saving the report as a PDF you will see the option to Publish,not to Save or Print.

Question 26

Which of the following is NOT true about printing a report?

A)One way to print a report is to use the Print dialog box on the File tab to select your printing options.
B)In Print Preview,you have many options to make design changes to your report before you send it to the printer.
C)Before you print,it is always a good idea to view the report in Layout view to make sure it looks the way you want.
D)In Print Preview,you can change the margins and orientation,and you can select how many pages,if not all,you want to print.

Question 27

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

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

Question 28

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 29

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

A)layout selector
B)subform control
C)control selector
D)Form Wizard

Question 30

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

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

Question 31

Which of the following is NOT true about customizing a report?

A)Reports created by the wizard can be easily customized after they have been created and saved.
B)Themes can be applied to just the report or the whole database to change the colors,fonts,or both.
C)Controls,bound and unbound,can be added or modified on the report to make room for more information or to rearrange the information already there.
D)To break a report into smaller sections,grand totals or sorts may be added.

Question 32

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

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

Question 33

Which of the following is NOT true about creating totals on reports?

A)When you report on textual data,you have the option to ask Access to calculate sums,averages,minimums,and maximums of the data.
B)The grand total calculates the total for all records.
C)Subtotals calculate totals for smaller groups of records.
D)Grand totals and subtotals can be added to a report after it has been created.

Question 34

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)A group is a collection of records along with introductory and summary information about the records.
C)Groups can only be created with data from individual tables.
D)In the Report Wizard,you will have the option to group the data in your report.

Question 35

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

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

Question 36

________ allows you to change more details of the report design or add other controls that are only available in this view.

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

Question 37

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

A)Controls can be resized to make the form more user friendly.
B)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.
C)Once the control is selected you can move it or resize it.
D)When you click a control in Form view,an orange border appears around the control.

Question 38

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 39

Which of the following is NOT true about enhancing a report with conditional formatting?

A)You can change the fonts and colors of fields only when certain conditions are met in the field.
B)If a field value meets the conditions you specify,then the formatting will be applied.
C)Conditional formatting is a useful tool to automatically highlight sales numbers on a report if they meet a certain threshold,or to highlight students' grades when they exceed a certain limit.
D)Access determines the font color and font effects for the formatting.

Question 40

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

A)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.
B)Once a report is created using the wizard,it will open in Design view.
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 41

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

Question 42

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 43

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

Question 44

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

Question 45

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 46

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

Question 47

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 48

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

Question 49

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

Question 50

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 51

A report is an object in Access that you can use to enter,edit,or view records in a table.

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

Deleting records in a table is permanent.

Question 57

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 58

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

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

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 61

The layout view selector allows you to move the whole table at one time.

Question 62

To make changes to data in a form,you must be viewing the form in ________ view.

Question 63

On a report,you can change the sorting and grouping options from either Layout or Design view.

Question 64

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

Question 65

A(n)________ is an object in Access that you can use to enter,edit,or view records in a table.

Question 66

A(n)________ control represents the actual value of a field and is a bound control.

Question 67

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

Question 68

On a form,a group is a collection of records along with introductory and summary information about the records.

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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 76

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.

Question 77

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

Question 78

If the table is part of a(n)________,referential integrity has been enforced,and the cascade delete option has not been chosen,a record cannot be deleted if there are related records in another table until those records have also been deleted.

Question 79

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 80

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