Title: Quiz Modules 5 through 8
Course: ITSW 1007.90024 C1 Intro. to Database

Q: Creating a form adds a new object to the database.
- True
- False
A: True

Q: When you create a form using the Form Wizard, all the fields from the table or query are automatically included on the form.
- True
- False
A: True

Q: When you apply a theme to a form, the table style is also updated.
- True
- False
A: False

Q: Entering data in a form is similar to entering data in a table in Datasheet view.
- True
- False
A: True

Q: Descending order sorts numerically from the highest to the lowest number.
- True
- False
A: True

Q: After you sort table data, you cannot use the Undo command.
- True
- False
A: False

Q: You should use the Replace All command only when you are confident about making all the replacements without reviewing them first.
- True
- False
A: True

Q: When you print a database in Datasheet view, all of the data in the database is printed
- True
- False
A: True

Q: When you finish the Report Wizard, the report is displayed in Design view.
- True
- False
A: False

Q: In Design view, you can change the appearance of a report by applying a different theme and/or colors and fonts
- True
- False
A: True

Q: When working with a form, Design view shows a detailed view of the structure of the form.
- True
- False
A: True

Q: When you sort in ascending order, you sort alphabetically from Z to A
- True
- False
A: False

Q: The Find command provides a quick and easy way to locate specific records.
- True
- False
A: True

Q: Which of the following is NOT true about creating a form?
- When you create a form using the Form button it is predesigned
- You can modify the form using the Layout view
- The Form button is located on the Insert tab
- You can modify the form using Design view
A: The Form button is located on the Insert tab

Q: When you work with a form, you can work in all of the following views, EXCEPT :
- Form
- Datasheet
- Layout
- Design
A: Form

Q: When you work with a form,  ___________ view is used for adding, editing, and viewing data.
- Form
- Datasheet
- Layout
- Design
A: Form

Q: When you work with a form, ________ view enables you to make changes to the font styles and colors
- Form
- Datasheet
- Layout
- Design
A: Layout

Q: Which of the following is true about entering and editing data in a form?
- You can use the Tab and arrow keys to move the insertion point among fields
- When you enter or edit a record in Form view, Access automatically updates the records in the table
- When entering text, the Edit Record icon is displayed in the upper left corner of the form
- All of the above are true
A: All of the above are true

Q: The Sort & Filter group is located on the ____________ tab.
- Layout
- Home
- Create
- Design
A: Home

Q: The Find button is located on the __________ tab.
- Home
- Database Tools
- Table Tools Layout
- Fields
A: Home

Q: When the _________ command is turned off, Access ignores capitalization in a search.
- Any Part of Field
- Match Case
- Search Fields
- All Caps
A: Match Case

Q: When you create a(n) ________ you can locate multiple records that match specific criteria
- datasheet
- report
- form
- query
A: query

Q: A(n) _______ provides a way for you to ask a question about the information stored in one or more database tables.
- query
- report
- form
- search
A: query

Q: Which of the following is NOT true about reports?
- The Report Wizard prompts you to specify the data to include.
- Landscape orientation formats the report with the long edge of the page at the top
- The Report Wizard button is located on the Create tab
- You can only create a report based on a table
A: You can only create a report based on a table

Q: Alaina is working on creating a large database for a non-profit organization she works for.  Alaina has a lot of data to enter, and wants to make it easy to enter.  She creates a(n) ________.
- form
- report
- query
- table
A: form

Q: Alaina wants to print selected data for the database so she can distribute it to donors.  She creates a ______.
- form
- report
- query
- table
A: report

Q: Juan is working with a large database and trying to locate information in it.  Juan wants to locate all records that contain a certain postal code, one at a time,  He uses the __________command.
- Query
- Replace
- Find
- Search
A: Find

Q: Juan wants to locate all records that contain a certain postal code, and display them all at once.  He creates a _____________.
- table
- report
- form
- query
A: query

Q: A(n) ______________________ provides a more convenient way to enter and edit data.
A: Form / form / Forms / forms

Q: When you create a form using the Form button, it opens in ____________ view.
A: Layout / layout

Q: The Form ________ prompts you to select the fields and the form layout for the new form.
A: Wizard / wizard

Q: To make all instances of Incorporated that appear in a company name appear a Inc., use the __________________ command
A: Replace / replace

Q: A(n) ____________________ is a database object that allows you to organize, summarize, and print data.
A: Report / report