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