Title: ITSC-Access
Course: ITSC 1001.90008.C1Intro to PC

Q: When you are appending records to an existing table, the first row must contain column ____.
- keys
- headings
- records
- sorters
A: headings

Q: Each field has a data ____. This indicates the type of data that can be stored in the field.
- type
- modifier
- name
- property
A: type

Q: The columns in the tables are called ____.
- records
- fields
- keys
- lines
A: fields

Q: In Access, you can use two different views to create a table: ____ view and Design view.
- Worksheet
- Datasheet
- Spreadsheet
- Information sheet
A: Datasheet

Q: The term database describes a collection of data organized in a manner that allows ____ of that data.
- access
- retrieval
- use
- all of the above
A: all of the above

Q: In Access, all the tables, reports, forms, and queries that you create are stored in a single file called a(n) ____.
- datasheet
- database
- information table
- information set
A: database

Q: When you use queries, usually you are looking for those records that satisfy some ____.
- criterion
- property
- protocol
- assumption
A: criterion

Q: One common wildcard, the ____, represents any collection of characters.
- comma
- asterisk
- exclamation point
- question mark
A: asterisk

Q: If you are sorting on more than one field, the more important field is called the ____ key.
- primary sort
- major
- either a. or b.
- neither a. nor b.
A: primary sort

Q: Gr* would return the following in a search.
- great
- grab
- green
- all of the above
A: all of the above

Q: In a ____ relationship, the matching fields are both primary keys.
- one-to-one
- one-to-many
- many-to-one
- many-to-many
A: one-to-one

Q: Normally, Access sequences the records in a table by the ____ key.
- secondary
- foreign
- relationship
- primary
A: primary

Q: If you want records to appear in reverse alphabetical order, click the ____ button.
- Grouping
- Ascending
- Sorting
- Descending
A: Descending