Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

COMPUTER > ACCESS > Flashcards

ACCESS Flashcards

1
Q

Access is a

A

database management system (DBMS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

a database is a powerful tool for

A

storing
organizing
retrieving information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

a database containing one table is called

A

simple database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

two or more tables of related information is called a

A

relational database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A data base stores data in or more spreadsheet-like lists

A

tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

each row in a table is called a

A

record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

records consist of _____, which are columns holding information about one aspect of a record.

A

Fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

column headings are

A

field names

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

this is a user-friendly window that is used to input data.

A

Form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

this extracts data from one or more database tables according to set criteria.

A

Query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

a condition

A

Query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

a summary of information pulled from the database specifically designed for printing

A

Report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

tables, forms, queries and reports are program components called

A

Objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A list of data organized in rows (records) and columns (fields)

A

Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A set of criteria you specify to retrieve data from a database.

A

Query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A window that lets you view, enter and edit data in a database one record at a time.

A

Form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

A summary of database information designed specifically for distributing or printing

A

Report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

two ways to create an Access database

A
  1. starting with a blank database

2. using a template

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

a blank table datasheet with a temporary table name, Table 1

A

The right pane below the ribbon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

the left pane is called the ____________ ______, this is where all database objects for the open database are listed.

A

Navigation pane

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

when working in a new database, a blank table opens in

A

Datasheet view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

In this view, you can add fields and view the data contained in the table.

A

Datasheet view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

before beginning to add fields to a table it is a good idea to

A

save the table with an appropriate name.

24
Q

every table in a database must contain one field that is designated as the _____ _____ ___, which uniquely identifies each record among all other records in the database

A

Primary Key Field

25
Q

It is often easier to add fields to a new or existing table using

A

Design view

26
Q

Identify the purpose of a field and help users understand the information that the field is meant to contain

A

Field description

27
Q

To view and change the designated primary key field use

A

Design View

28
Q

the best view for modifying a table structure is

A

Design view

29
Q

Data characteristics that dictate how Access stores, handles, and displays field data in design view

A

Field properties

30
Q

a label that appears in a form or in Datasheet view in place of a field name

A

Caption property

31
Q

the data you enter in each field is called a

A

Field value

32
Q

this is to the left of each record lets you select a record or records

A

Row selector

33
Q

An efficient way to enter and edit data: Usually displays one record at a time

A

Form

34
Q

devices for inputting data; for example, text box, list arrow, or check box

A

Form Controls

35
Q

To view different records, you use the buttons on the

A

Navigation bar.

36
Q

you can only open _____ Access database file at a time

A

one

37
Q

The field that is primary is called the

A

outermost sort field

38
Q

conditions that must be met for a record to be displayed

A

Criteria

39
Q

a database object that extracts data from one or more tables in a database according to criteria that you set

A

Query

40
Q

To relate tables, they must share a

A

common field

41
Q

the most common type of relationship to set up is ___ __ __ _____ in which the primary key field in one table is associated with multiple records in a second table

A

one-to-many relationship

42
Q

In the second table, the common field shared with the first table is called the

A

Foreign key

43
Q

a field that contains and expression

A

calculated field

44
Q

a combination of fields, values, and mathematical operators.

A

Expression

45
Q

a summary of database information designed specifically for printing

A

Report

46
Q

One way to create a report is by using the ______ ____, which automatically create a report based on setting that you specify.

A

Report Wizard

47
Q

choose the ______ _____ to select the database object from which a report gets data

A

record source

48
Q

Use _______ to organize a report by field or field values

A

Grouping

49
Q

see exactly how the report will look when printed

A

Print preview

50
Q

it displays the report in continuous flow without page break

A

Report view

51
Q

includes many tools for modifying a report, but shows only the structure of the report not the included data.

A

Design view

52
Q

does not include as many modification tools as design view, but it shows you report data. can resize, move, and delete columns.

A

Layout view

53
Q

A field is composed of two parts

A

the field label, and its associated control

54
Q

an object that displays information in a report

A

control

55
Q

five summary calculations you can use in your database reports.

A 
SUM
AVG
COUNT
MIN
MAX
56
Q

______ ______ in a report displays statistics about one or more fields in a database.

A

summary calculations

COMPUTER (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions