Chapter 1 Access Dave Poulin #2

A database management system, such as Access, is _______ that allows you to use a computer to create a database; add, change, and delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data in the database.

• Software
• Hardware
• Both a. and b.
• Neither a. nor b.

In a relational database such as those maintained by Access, a database consists of a collection of ______, each of the which contains information on a specific subject.

• graphs
• charts
• tables
• lists

The columns in the tables are called ______.

• records 
• fields
• keys
• lines

A unique identifier also is called a(n) _____ key.

• essential
• security
• administrative
• primary

Database _____ refers to the arrangement of data into tables and fields. 

• Design
• Development
• analysis
• layout

The determination of database requirements is part of a process known as ______.

• Database design
• Database analysis
• Systems design
• Systems analysis

All of the following characters cannot be used in a file name EXCEPT: _______. 

• colon(:)
• comma(,)
• question mark(?)
• asterisk(*)

In designing your database, you must name the tables and fields. Names can be up to _____ characters in length.

• 32
• 64
• 48
• 72

The most common type of relationship you will encounter between tables is the _____ relationship.

• Many-one
• One-many
• One-one
• Many-many

_____ is a commonly accepted shorthand representation for showing the structure of a relational database.

• DBDL
• DLDB
• BDBL
• BLBD