Title: Quiz Modules 1 through 4
Course: ITSW 1007.90024 C1 Intro. to Database

Q: A relational database organizes information into separate subject-based tables.
- True
- False
A: True

Q: To allow more space to show the table contents, you can close the Navigation Pane
- True
- False
A: True

Q: Each of the objects and everything that you do in a database relies on the data stored in a form
- True
- False
A: False

Q: At least one table must be created before any additional objects can be created
- True
- False
A: True

Q: A field property is a label that helps identify the field
- True
- False
A: False

Q: The primary key is useful in sorting records
- True
- False
A: True

Q: In Design view, the table data looks much like a spreadsheet
- True
- False
A: False

Q: You can add fields only in Design view
- True
- False
A: False

Q: The field properties available depend on the data type selected
- True
- False
A: True

Q: When you work in Design view, the changes are saved as they are made
- True
- False
A: False

Q: A database is a collection of related files or tables
- True
- False
A: True

Q: Database objects are organized into categories in the Object Pane
- True
- False
A: False

Q: In a database, fields are displayed as rows
- True
- False
A: False

Q: By default, a table opens in Datasheet view
- True
- False
A: True

Q: Design view shows details about the structure of the object, including the data type and field properties
- True
- False
A: True

Q: Which of the following is NOT true about databases?
- Like spreadsheets, databases are composed of rows and columns.
- Like Word and Excel, Access has a standard document view
- Access offers more comprehensive functions for manipulating data than Excel
- In Access you can import or link data from other Access databases
A: Like Word and Excel, Access has a standard document view

Q: All data in a database is stored in a
- table
- form
- report
- query
A: table

Q: A ___________ makes it easy for you to view, enter, and edit data.
- table
- form
- report
- query
A: form

Q: A _________ organizes data in a specific layout.
- table
- form
- report
- query
A: report

Q: A _____________ finds and shows data that meet a specified criteria.
- table
- form
- report
- query
A: query

Q: A(n) ________ is a single piece of database data
- field
- record
- datasheet
- primary key
A: field

Q: When you create a new field, you can choose a(n) ____________, such as text or numbers.
- field property
- datasheet
- field name
- data type
A: data type

Q: Which of the following is data that would be stored in a field?
- A first name
- A phone number
- A postal code
- All of the above could be stored in a field
A: All of the above could be stored in a field

Q: A(n) _______________ would store all of the data about an individual.
- field
- record
- datasheet
- primary key
A: record

Q: To insert a table in a database, click the _________ tab on the Ribbon.
- Insert
- Table
- Create
- File
A: Create

Q: To move the insertion point to the previous field in Datasheet view, press ______________.
- Shift+Tab
- the right arrow
- Enter
- Tab
A: Shift+Tab

Q: The default data type for a field is ______________.
- Number
- Text
- Currency
- Yes/No
A: Text

Q: Which of the following is NOT true about deleting and copying records and fields in Datasheet view ?
- The Cut, Copy, and Paste commands are available in Access
- You can use the Undo command to delete a record
- To remove a table field and all the data for the field, you delete the column
- You can rearrange the sequence of the columns
A: You can use the Undo command to delete a record

Q: In Datasheet view, when a record is being edited, a(n) ___________ icon appears to the left edge of the row.
- star
- key
- pencil
- arrow
A: pencil

Q: Pilar is creating a new database for her business.  Pilar wants to store information about customers' orders, as well as product details of her inventory.  She should create separate ___________ for each
- tables
- fields
- records
- databases
A: tables

Q: Pilar uses a unique product number for each product in her inventory.  She makes the product number ______.
- a table
- the primary key
- a database
- a record
A: the primary key

Q: C.J. wants to modify a table in his database.  C.J. wants to easily edit the field properties in his table.  He should work in ________ view.
- Table
- Normal
- Design
- Datasheet
A: Design

Q: C.J. wants to change the default Field Size property for a field with the Text data type from ________  characters to 50
- 8
- 55
- 100
- 255
A: 255