question

Database

answer

A collection of data organized in a manner that allows access, retrieval, and use of that data.

question

Database management system

answer

Software that allows you to use a computer to create a database and preform other function with the database.

question

Database management system

answer

Allows you to edit, ask and answer questions about, and create forms and reports using the data in the database.

question

Relational database

answer

A database consisting of a collection of tables, each of which contains information on a specific subject.

question

Records

answer

Contains information about a given person, product, or event.

question

Field

answer

Contains a specific piece of information within a record.

question

Unique identifier

answer

A field used to uniquely identify each record in the database.

question

Database design

answer

The arrangement of data into tables and fields in a database.

question

Redundancy

answer

The storing of a piece of data in more than one place in a database.

question

?, ", /, , :, *, |, >, <

answer

These characters cannot be used in a file name.

question

Reserved words

answer

Words that have a special meaning to Access, and cannot be used as field names.

question

64

answer

Maximum number of characters in a table and field name.

question

., !, ', [, ]

answer

These characters cannot be used when naming fields or tables.

question

Fields

answer

The same name cannot be used for two different ____ in the same table.

question

Data type

answer

Indicates the type of data that can be stored in the field.

question

Text, Number, Currency

answer

Three of the most commonly used data types

question

Text

answer

The data type in which the field can contain any characters, a maximum of 255.

question

Number

answer

The data type in which the field can contain only numbers, positive or negative, usually used for arithmetic operations.

question

Currency

answer

The data type in which the field can contain only monetary data, in which values appear with currency symbols and with two digits following the decimal point.

question

Blank

answer

If you already know the tables and fields you want in your database, you would use this database option.

question

template

answer

If you do not already know the tables and fields you want in your database, you would use a ____.

question

Access window

answer

This consists of a variety of components to make your work more efficient and documents more professional.

question

Access Window

answer

Consists of the Navigation Pane, Access work area, Ribbon, shortcut menus, and Quick Access toolbar.

question

Access work area

answer

Where you work on objects such as tables, forms, and reports

question

Object tabs

answer

Appears at the top of the Access work area to indicate objects that are open.

question

Navigation Pane

answer

Contains a list of all the objects in the database, used to open an object, you can customize the display of objects.

question

Status bar

answer

Located at the bottom of the Access window, presents information about the database object, the progress of current tasks, the status for certain commands and keys, and viewing options.

question

Primary key

answer

To create a table, you must describe all of the fields that make up the table and their characteristics, and indicate the ____ ____.

question

Datasheet view and Design view

answer

The two views that you can use to create a table in Access.

question

Datasheet view

answer

The view in which the data in the table is presented in rows and columns, like a spreadsheet, used to update data and modify the structure of the table.

question

Design view

answer

The view that is only used to create a table or modify its structure.

question

Design view

answer

Out of datasheet view and design view, which one has more functionality for creating a table?

question

Click to Add

answer

To define an additional field, click this column heading to select the data type and enter the field name.

question

Dim

answer

If there is nothing to undo in Access, the Undo button on the Quick Access toolbar will be this.

question

right-click

answer

Do this to the column heading to get a shortcut menu to delete the column or change the name.

question

Insert Field

answer

To insert a field between existing fields, right-click the column heading for the field that will follow the new field and click this on the shortcut menu

question

drag

answer

To move a field, click the column heading and then do this.

question

Create

answer

Click this on the ribbon and then click the Table button to create a table.

question

Shutter Bar

answer

Click the _______ ______ Open/Close Button to close the Navigation Pane.

question

right-click

answer

Do this to the table in Navigation Pane that you wish to open and then select the desired view in which you wish to view it.

question

Backspace

answer

If you make a mistake when typing, correct it by pressing this key.

question

Primary key

answer

Access will reposition new records(table rows) automatically based on this.

question

Record

answer

A row in a table.

question

Delete

answer

To delete a record, click the record selector and press this key.

question

screen

answer

To change the contents of one or more fields in a record, the record must be on the _____.

question

INSERT

answer

You can use this key to switch between Insert and Overtype mode while editing fields in records.

question

stuck

answer

When you are "this" on the record, Access neither allows you to move to another record nor allows you to close the table until you have made the correction.

question

ESC

answer

To remove from the screen the record you are trying to add if you get "stuck", press this key.

question

Green computing

answer

This involves reducing the environmental waste generated when using a computer.

question

Portrait orientation

answer

The orientation in which the printout is across the width of the page.

question

Landscape orientation

answer

The orientation in which the printout is across the height of the page.(sideways)

question

list

answer

The form that data is stored in in which the first row contains column headings describing the data in each of the columns, and the remaining rows contain the data.

question

Import

answer

To make a copy of data from another source in a table in the Access database.

question

Table

answer

When importing data, you have two choices: create a new ____, or add the records to an existing _____. (Same word)

question

wizard

answer

The process of importing into an Access database uses this, which takes you through basic steps.

question

Import Spreadsheet

answer

If the data is imported from an Excel worksheet, the process will use the _____ ______ Wizard.

question

External Data

answer

To import an Excel worksheet, click this on the Ribbon and then click the Excel button.

question

Queries

answer

Simple questions, the answers to which are in the database.

question

Simple Query

answer

When you are creating a query, if there are no restriction involved in the query, you can use the ____ ______ Wizard.

question

Query Wizard

answer

To create a query, select the appropriate table in the Navigation Pane, click Create on the Ribbon, and then click the ______ _____ button to display the New Query dialog box.

question

Recovery

answer

The process in which invalid data in the database is returned to a correct state.

question

backup copy

answer

The copy of data created while backing up a data base.

question

Backing up

answer

The simplest approach to the recovery process, involving periodically making a copy of the database.

question

live database

answer

If a problem occurs while backing up a database, you can correct the problem by copying this backup copy over the actual database, called this.

Access Chapter 1 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards