MIS 342 chapter 1

A single characteristic or attribute of a person, a place, an object, an event, or an idea

Field

A primary key from one table that is used to form a relationship with a second table

Field Value

The content of any given field is the ____.

Field Value

The ____ tab provides options for adding, removing, and formatting the fields in a table.

Fields

The first step in organizing data into a database is to identify the individual ____.

Fields

A field or collection of fields whose values uniquely identify each record in a table

Primary Key

A field, or a combination of fields, that has a unique value is a ____.

Primary Key

A ____ is a question you ask about data stored in a database.

Query

A question you ask about data stored in a database

Query

The ____Toolbar provides one-click access to commonly used commands, such as Save.

Quick Access

A relational database is a collection of ____.

Related Tables

Organizes data as a collection of tables

Relational DBMS

A collection of related tables

Relational Database

A formatted printout (or screen display) of the contents of one or more tables

Report

The ____ places all the fields from a selected table (or query) on a report.

Report tool

Which of the following is NOT an example of an Access object?

Report tool

The ____ provides the main Access commands organized by task into tabs and groups.

Ribbon

If you are unable to see all of the fields on your display, click the ____ to give you more room on the screen to view the object's contents.

Shutter Bar Open/Close Button on the Navigation Pane

You cannot print a report without displaying the Print dialog box and selecting options for printing.

True

You connect the records in separate tables through a common field that appears in both tables.

True

Which extension identifies a file as a Microsoft Access 2010 database?

.accdb

New databases created using Access 2010 have the same file extension and file format as Access ____ databases.

2007

An Access database can contain up to ____ objects.

32,768

The ____ window is the program window that appears when you create a new database or open an existing database.

Access

A relational DBMS allows you to create database structures containing ____.

All of the above: fields tables table relationships

Which of the following could be defined as a field in a database?

All of the above: Customer name Phone number Order number

A field can be described as a(n) ____.

Attribute

The process of making a copy of the database file to protect your data against loss or damage

Backing up

You can use the ____ column in the table datasheet to add new fields.

Click to add

Connects the records in separate tables

Common Field

Data from separate tables can be connected by specifying a ____.

Common Field

To rearrange the data and objects in a database file, to decrease its file size

Compact

A table's contents are displayed as rows and columns in ____.

Datasheet view

To correct a value by replacing it entirely, press the ____ key, and then type the correct value.

Esc

A primary key in one table cannot be used as a foreign key in a different table.

False

Access has a button you can use to save the active database.

False

Backing up a database rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly.

False

Defining a(n) primary key in a second table creates a relationship between that table and the table where the primary key was first defined.

False

Like spreadsheets, a DBMS can handle massive amounts of data and can easily form relationships among multiple tables.

False

More than one user can enter data into a database.

False

Only one user can retrieve and analyze data that was entered into a database by others.

False

Query results automatically are stored in the database.

False

To back up your database, click the Home tab to display Backstage view, click the Save & Publish tab in the navigation bar, click Back Up Database in the Advanced section of the Save Database As pane, and then click the Save As button.

False

To restore a backup database file, you copy the backup from the drive on which it is stored to your hard drive, or whatever device you use to work in Access, and start working with the restored database file.

False

To start Access, click the Start button on the taskbar, click All Programs, click Microsoft Office, and then click Microsoft Office Access 2010.

False

When you create a table in Datasheet view, you can use the options in the Database group on the Fields tab to add fields to your table.

False

A field name can consist of up to 255 characters.

False; 64 characters

Whenever you open an Access database and work in it, the size of the database decreases.

False; it increases

In Design view, you can make design changes to the form while it is displaying data, so that you can see the effects of the changes you make immediately.

False; layout view

The specific content of a field

Foreign Key

The ____ quickly creates a form containing all the fields in the table (or query) on which you are basing the form.

Form tool

The ____ is the main control center for opening and working with database objects.

Navigation Pane

You open a table, or any Access object, by double-clicking the object name in the ____.

Navigation pane

A field name cannot begin with a ____.

Space

Which of the following can be used in a field name?

Spaces

Use the ____ key(s) to move to the next column in a table.

Tab and enter

A collection of fields that describe a person, a place, an object, an event, or an idea

Table

All related fields can be grouped together as a(n) ____.

Table

Access assigns the default name ____ to the first new table you create.

Table1

A collection of fields describing a person, a place, an object, an event, or an idea is a table.

True

A collection of related tables is called a relational database.

True

A database is a collection of related tables.

True

A relational DBMS controls the storage of databases on disk and facilitates the creation, manipulation, and reporting of data.

True

A single set of field values within a table is a record.

True

A(n) relational database management system provides protection for your data through the use of security, control, and recovery facilities.

True

A(n) template is a predesigned database that includes professionally designed tables, reports, and other database objects that can make it quick and easy for you to create a database.

True

Although a field has unique values in the table in which it is the primary key, it does not have to have unique values in the table in which it is the foreign key.

True

One benefit of a relational database management system is that it contains a built-in query language, which lets you obtain immediate answers to the questions you ask about your data.

True

The Datasheet view is the first view that appears when you start Access.

True

The Report tool creates a report based on the selected table or query.

True

The navigation buttons provide a way to move vertically through the records.

True

Access can guide you through the steps to create a query by using the Query ____.

Wizard

data warehouse

a database that stores large amounts of historical data in a form that readily supports analysis and management decision making

technology infrastructure

all the hardware, software, databases, networks, people, and procedures that are configured to collect, manipulate, store, and process data into information. The technology infrastructure is a set of shared IS resources that form the foundation of each computer-based information system

Application software

allows you to accomplish specific tasks, including editing text documents, creating graphs, and playing games

database

an organized collection of facts and information, typically consisting of two or more related data files

Networks

connect computers and equipment in a room, building, campus, city, across the country, or around the world to enable electronic communication

Hardware

consists of computer equipment used to perform input, processing, storage, and output activities

Software

consists of the computer programs that govern the operation of a particular computing device, be it desktop computer, laptop, tablet, smartphone, or some other device

A form is used to ____.

enter, edit, and view records in a database

If you don't type the filename ____, Access adds it automatically.

extension

Group IS

information systems that improve communications and support collaboration among members of a workgroup. Examples: 1. Web conferencing software 2. wikis 3. electronic corporate directories

Personal IS

information systems that improve the productivity of individual users in performing stand-alone tasks. Examples: personal productivity software - 1. word-processing 2. presentation 3. spreadsheet software

Enterprise IS

information systems that organizations use to define structured interactions among their own employees and/or with external customers, suppliers, government agencies, and other business partners Examples: 1. transaction processing 2. enterprise 3. interorganizational systems

information system (IS)

is a set of interrelated components that collect, process, store, and disseminate data and information; an information system provides a feedback mechanism to monitor and control its operation to make sure it continues to meet its goals and objectives.

computer-based information system (CBIS)

is a single set of hardware, software, databases, networks, people, and procedures that are configured to collect, manipulate, store, and process data into information

Every foreign key must ____.

match the field value of a primary key in a related table

Click the Open command in the ____ to display the Open dialog box.

menu bar

A primary key ____.

must contain a unique value for each record

In Datasheet view, the star symbol that appears in the record selector area always identifies the ____ in the database.

next available row for a new record

The Create tab has options to create all of the following EXCEPT ____.

other databases

System software

oversees basic computer operations such as start-up, controls access to system resources, and manages memory and files

Access allows you to ask questions and obtain information about your data through use of a built-in ____.

query language

In Datasheet view, clicking a row selector selects an entire ____.

record

In Datasheet view, the pencil symbol indicates the ____.

record being edited

The Save button on the Quick Access Toolbar is used to ____.

save the design of an access object

Clicking a record selector ____.

selects an entire row

Clicking a field selector ____.

selects the entire column

The maximum size of an Access database is ____.

two gigabytes