Microsoft Access Chapter 1
A maximum number of ____ characters is allowed in a field whose data type is Short Text.
255
Criterion
A ____ is a condition that the records must satisfy in order to be included in the query results.
Software
A database management system 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; and create forms and reports using the data.
Yes/No
A field with the ____ data type can store only one of two values.
Primary
A unique identifier also is called a(n) ____ key.
Hard
A(n) ____ copy or printout is information that exists on a physical medium such as paper.
Properties
Access helps you organize and identify your databases by using database ____, which are the details about a file.
Layout
Changing a column width changes the ____, or design, of a table.
Headings
Column ____ are descriptions of the contents of the column, rather than data.
Short Text
Fields that contain numbers but will not be used for arithmetic operations (such as postal codes) usually are assigned a data type of ____.
Type
For each field in your database, you must determine the field's data ____, which indicates what can be stored in the field.
Backspace
If you discover a mistake while still typing an entry, you can correct the error by repeatedly pressing the ____ key until the incorrect characters are removed.
Import
If your data for a table is stored in an Excel worksheet, you can ____ the data, which means to make a copy of the data as a table in the Access database.
Datasheet
In Access, you can use two different views to create a table: ____ view and Design view.
Datasheet
In Datasheet view, the table is represented as a collection of rows and columns called a ____.
Form
In ____ view, where data is displayed in a form on the screen, you usually can see all the fields, but only for one record.
Tables
In a relational database such as those maintained by Access, a database consists of a collection of ____, each of which contains information on a specific subject.
64
In creating your database, you must name tables and fields. Names can be up to ____ characters in length.
Formatted
Like a paper form, a form in a database is a ____ document with fields that contain data.
Lower-left
Navigation buttons, which are buttons used to move within a table, are found near the ____ corner of the screen when a table is open.
Create
Tap or click ____ on the ribbon, and then tap or click the Table button to create a table.
Navigation
The ____ Pane contains a list of all the objects in the database. You use this pane to open an object.
Status
The ____ bar, located at the bottom of the Access window, presents information about the database object, the progress of current tasks, and the status of certain commands and keys.
Detail
The ____ option of the Simple Query Wizard shows all the records and fields.
Design
The database ____ process is the process of determining the tables and fields that make up a database.
System Analysis
The determination of database requirements is part of a process known as ____.
Identify the Tables
The first step in the database design process is to ____.
Records
The rows in the tables are called ____.
Backup
The simplest approach to recovery involves periodically making a copy of the database called a(n) ____ copy.
Database
The term ____ describes a collection of data organized in a manner that allows access, retrieval, and use of that data.
Fields
To create a table in Access, you must define its structure. That is, you must define all the ____ that make up the table and their characteristics.
Shift
To resize all columns in a datasheet to best fit simultaneously, select the column heading for the first column, hold down the ____ key and select the last column in the datasheet. Then, double-tap or double-click the right boundary of any field selector.
Row
To see the field size and/or caption for a field, tap or click the field's ____ selector, the small box that precedes the field.
Datasheet
When working with a report in Access, there are four different ways to view reports. They include all of the following EXCEPT: ____. a:Design b: Report c:Layout d: Datasheet
Link to
When you ____ the data in the worksheet, the data appears as a table in the Access database but it is maintained in its original form in Excel.
Currency
With the ____ data type, the field can contain only monetary data.
Key
You can add records in any order. When you close a table and reopen it, the records are sorted in the order of the primary ____.
Tenplate
You can use either the Blank desktop database option or a ____ to create a new database.
Work
You work on objects such as tables, forms, and reports in the Access ____ area.
Queries
____ are simply questions, the answers to which are in the database.
Green Computing
____ involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.
DBDL
____ is a commonly accepted shorthand representation for showing the structure of a relational database.
Standard
____ properties are associated with all Microsoft Office documents and include author, title, and subject.
Automatically Updated
____ properties include file system properties, such as the date you create or change a file, and statistics, such as the file size.
Redundancy
____ usually results from placing too many fields in a table; fields that really belong in separate tables and often causes serious problems.
Design
____ view is only used to create a table or to modify the structure of a table
at the top
object tabs for open objects appear ____ the work area.