Access questions, very easy

Name ____________________________
Date ___________________

Access 2010: Chapter 4 – Multiple Choice

Instructions: Circle the best answer.

1. ____ view is most useful when the changes you need to make to a report are especially complex.

a. Layout

b. Form

c. Design

d. Tools

2. The contents of the ____ section print once at the beginning of the report.

a. Report Header

b. Report Footer

c. Form Header

d. Page Header

3. In Layout view of a report, you can specify ____.

a. grouping

b. sorting

c. both a. and b.

d. neither a. nor b.

4. ____ controls are not associated with data from the database and are used to display such things as the report’s title.

a. Calculated

b. Unbound

c. Bound

d. Structured

5. When working on a report in Layout view, you can make additional layout changes by using the Report Layout Tools ____ tab.

a. Design

b. Format

c. Page Setup

d. Arrange

6. A report that includes the group calculations such as subtotals, but does not include the individual detail lines is called a ____ report.

a. basic

b. top-line

c. detail

d. summary

7. To assign a theme to a single object, click the Themes button (Design tab | Themes group) to display the Theme ____.

a. picker

b. helper

c. editor

d. wizard

8. The ____ Header section appears at the top of the form and usually contains the form title.

a. Form

b. Page

c. Report

d. Section

9. To add a date to a form, use the ____ button on the Design tab.

a. Date

b. Time

c. Date and Time

d. Clock

10. Once you create mailing labels, you can customize them just as you can customize other reports. In ____ view, you can add a picture to the label, change the font size, adjust the spacing between controls, or make any other desired changes.

a. Live

b. Design

c. Create

d. Tools

Name _________________________

Date ___________

Access 2010: Chapter 4 –

T

rue/

F

alse

Instructions: Circle T if the statement is true or F if the statement is false.

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

1. A form is the appropriate choice if it is necessary to print data.

2. Once you decide on a general report style, you should stick with it throughout your database.

3. The various objects on a report are called tools.

4. If you point to any theme in the Theme picker, you will see a dialog box giving the name of the theme.

5. To assign a theme, it is easiest to use Form view.

6. You can create a summary report in either Layout view or Design view.

7. As with reports, it is usually simplest to begin creating a form by using the wizard.

8. When working with a form in Access, there are three different ways to view the form. They are Form view, Layout view, and Print view.

9. To move the control, the pointer must be a two-headed arrow.

10. The Page Setup tab is available for both forms and reports.

Name ____________________________
Date ___________________

Access 2010: Chapter 5 – Multiple Choice

Instructions: Circle the best answer.

1. Special data types include all of the following EXCEPT: ____.

a. OLE Object

b. Picture

c. Attachment

d. Hyperlink

2. You can add fields in Datasheet view. One way to do so is to use the Add & Delete group on the ____ Fields tab.

a. Datasheet

b. Table Finder

c. Edit

d. Table Tools

3. Delete a field by clicking the field and then clicking the ____ button.

a. Recycle

b. Delete

c. Erase

d. Undo

4. Fields that are Yes/No fields contain ____.

a. check boxes

b. text boxes

c. radio buttons

d. hyperlinks

5. The field ____ is the bar containing the field name.

a. selector

b. helper

c. picker

d. chooser

6. To undo changes to the column width, right-click the field selector, click Field Width on the shortcut menu, and then click the ____ Width check box in the Column Width dialog box.

a. Primary

b. Default

c. Standard

d. Basic

7. You can create a form in ____ view, which gives you the most flexibility in laying out the form using a blank design on which you place objects.

a. Layout

b. Forms

c. Design

d. Datasheet

8. On the Size/Space menu, you can ____ either the vertical or the horizontal spacing.

a. increase

b. decrease

c. either a. and b.

d. neither a. nor b.

9. The form title belongs in the Form ____ section.

a. Date

b. Title

c. Footer

d. Header

10. The possible size modes include all of the following EXCEPT ____.

a. Clip

b. Stretch

c. Zoom

d. Resize

Name ____________________________
Date ___________________

Access 2010: Chapter 5 – Short Answer

Instructions: Fill in the best answer.

1. A(n) ________________ specifies how data is to be entered and how it will appear.

2. To use the Input Mask Wizard, select the Input Mask property in the field’s property sheet and then select the ________________ button.

3. If you scroll down in the Data Type gallery, you will find a(n) ________________ section. The commands in this section give you quick ways of adding some common types of fields.

4. To enter data in Date/Time fields, click the Date ________________ that will appear next to the field, and then use the calendar to select the date.

5. To change the size of a row, you use a record’s record ________________, which is the small box at the beginning of each record.

6. To undo changes to the row height, right-click the row selector, click Row Height on the shortcut menu, and then click the ________________ Height check box in the Row Height dialog box.

7. To insert data into an Attachment field, you use the ________________ Attachments command on the Attachment field’s shortcut menu.

8. A(n) ________________ is a form that is contained within another form.

9. You can use the ________________/Back Color button on the Form Design Tools Design tab to change the background color of a form.

10. The portion of a picture that appears as well as the way it appears is determined by the property called ________________.

Name _________________________

Date ___________

Access 2010: Chapter 5 –

T

rue/

F

alse

Instructions: Circle T if the statement is true or F if the statement is false.

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

1. When designing reports and forms in Access, you must determine whether new fields are required and identify the source (table or tables) of the data.

2. Fields containing pictures do not require a special data type.

3. When you store an image as an OLE object, the image stays with the database.

4. If you determine that you need new fields in a table, you then need to determine data types for these fields.

5. Numeric is the appropriate data type for the Phone Number field.

6. You cannot add fields in Datasheet view.

7. You can move a field from one location to another by dragging the field.

8. When you are entering data in a field that has an input mask, Access will insert the appropriate special characters in the proper positions.

9. To enter data in Date/Time fields, you can simply type the dates and include dashes (-).

10. To view attachments, you do not need to have the application that created the attachment file installed on your computer.

Name ____________________________
Date ___________________

Access 2010: Chapter 6 – Multiple Choice

Instructions: Circle the best answer.

1. You can create new Access tables in either ____ view or Design view.

a. Datasheet

b. Create

c. Home

d. Design

2. Two of the primary reasons to link data from another program to Access are to use the query and ____ features of Access.

a. report

b. function

c. both a. and b.

d. neither a. nor b.

3. When an external table or worksheet is imported, or ____, into an Access database, a copy of the data is placed in a table in the database.

a. linked

b. converted

c. pasted

d. set up

4. If you move, rename, or modify linked tables, you can use the Linked Table ____ within the Database Tools tab to update the links.

a. Manager

b. Wizard

c. Gallery

d. Library

5. The text box consists of a control that is initially unbound and a(n) ____ label.

a. attached

b. unattached

c. primary

d. source

6. Paste Append, which is available if you have ____ a record, allows you to paste the record to a table with a similar structure.

a. cut or copied

b. saved or deleted

c. opened or closed

d. all of the above

7. To use a function, type a(n) ____, followed by the function name.

a. dollar sign

b. asterisk

c. plus sign

d. equal sign

8. The IIf function consists of the letters IIf followed by three items, called ____, in parentheses.

a. criterion

b. expressions

c. arguments

d. properties

9. If you print or preview the report, you will notice that all the controls have boxes around them called ____.

a. frames

b. borders

c. edges

d. markers

10. After reviewing a report, if you realize you need an additional control, you could add it by using the appropriate tool in the ____ group or by dragging a field from the field list.

a. Insert

b. Stretch

c. Fields

d. Controls

Name ____________________________
Date ___________________

Access 2010: Chapter 6 – Short Answer

Instructions: Fill in the best answer.

1. The first report contains a(n) ________________, which is a report that is contained within another report.

2. When you create a table in Datasheet view, Access automatically creates an ID field with the ________________ data type as the primary key field.

3. When you link an Access database to data in another program, all changes to the data must be made in the ________________ program.

4. To identify that a table is linked to other data, Access displays a(n) ________________ in front of the table in the Navigation Pane.

5. You can use a control’s property ________________ to change the value in the appropriate property.

6. If the value of the ________________ property is set to Yes, Access will remove blank lines that occur when the field is empty.

7. ________________ allows you to paste data into different formats.

8. To assign a conditional value, you will use the IIf ________________.

9. If you click the Page Setup button, you will see the Page Setup dialog box with the ________________ tab selected.

10. You may find that you need to increase the size of a control, which you can do by selecting the control and dragging the appropriate ________________.

Name _________________________

Date ___________

Access 2010: Chapter 6 –

T

rue/

F

alse

Instructions: Circle T if the statement is true or F if the statement is false.

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

T

F

1. To implement a many-to-many relationship in a relational database management system such as Access, you create a third table that has as its primary key the combination of the primary keys of each of the tables involved in the many-to-many relationship.

2. AutoNumber fields are useful when there is no data field in a table that is a suitable primary key.

3. You can import and link XML files.

4. If you link an Excel workbook to an Access database, you can edit the linked table in Access.

5. You can use Design view to modify a report created by the wizard.

6. You can place a text box on a report or form by using the Text Box tool in the Text group on the Page Setup tab.

7. The date is automatically added to the report header.

8. Use the Undo button on the Navigation Pane Toolbar to reverse your last action.

9. When you use the Background Color button on the Ribbon, you see standard colors, but no theme colors.

10. Because each control has properties associated with it, Access assigns a default name to each new control.

Name ____________________________
Date ___________________

Access 2010: Chapter 4 – Short Answer

Instructions: Fill in the best answer.

1. The contents of the ___________________ section print once at the end of the report.

2. The contents of the ___________________ section print once at the top of each page and typically contain the column headings.

3. The contents of the ___________________ section print once for each record in the table.

4. ___________________ controls are used to display data that comes from the database, such as the client number and name.

5. ___________________ controls are used to display data that is calculated from other data, such as a total.

6. If you want to create a layout similar to a paper form, with labels to the left of each field, click the ___________________ button on the Arrange tab.

7. If you want to create a layout similar to a spreadsheet, with labels across the top and data in columns below the labels, click the ___________________ button on the Arrange tab.

8. A(n) ___________________ consists of a selection of colors and fonts for the various sections in a report or form.

9. When selecting themes, Access furnishes a(n) ___________________of what the report or form will look like with the theme before you actually select the theme.

10. To assign a theme to a single object, click the Themes button (Design tab | Themes group) to display the Theme ___________________.