Brainscape's Knowledge GenomeTM

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


See full index

Computer Applications > Unit 3 Access > Flashcards

Unit 3 Access Flashcards

0
Q

What does database design refer to?

A

The arrangement of data into tables and fields

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

What is a data sheet?

A

A collection of rows and columns

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

What is the purpose of the Key Tip?

A

To select a command using the keyboard

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

What are fields?

A

Contain a specific piece of information within a record

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

What is the office button?

A

Central location for managing and sharing database objects

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

What is the first step in planning a database?

A

Data entry

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

What is a gallery?

A

Set of choices, often graphical,mar ranged in a grid or list

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

What does a database allow you to do with the data?

A

Organizes it so it can be accessed, retrieved, and used

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

What is Access?

A

Database management system

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

Where is the vertical scroll bar located?

A

Right edge of window

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

What is the insertion point?

A

Blinking vertical bar indicating where text or pictures will be inserted

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

What is a file?

A

A saved database

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

What are database properties,

A

Details about the file

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

What is redundancy?

A

Storing the same fact in more than one place

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

How do you view a data sheet and a form simultaneously?

A

Split form

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

What does the data type do?

A

Indicates the type of data that can be used in a field

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

What does landscape orientation allow you to do?

A

Printout will be across the length of the paper

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

What are records?

A

Rows in the table

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

What are choices for yes/no field?

A

Yes/no, true/false, and on/off

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

What is a primary key?

A

Unique identifier

Only appears in a single record in the database

20
Q

What would be a good primary key for a book database?

A

ISBN number

21
Q

What is a row selector?

A

The small box you click to select the entire row

22
Q

Where are commands located

A

Menu, the ribbon

23
Q

How do you display a shortcut menu?

A

Right click

24
Q

What is a task pane?

A

Window that can remain open while you work in the database

25
Q

What does the AND criterion require?

A

Each individual criterion must be true

26
Q

Where must the criteria go when combining criteria with OR?

A

Separate lines

27
Q

What is the sort key?

A

Field/fields that records are sorted for

28
Q

What is a common restrictions?

A

Exclude duplicates

29
Q

What words imply a descending order?

A

Decreasing, descending, high to low

30
Q

How is the minor key determined within a sort?

A

The field on the right

31
Q

What property must be changed to omit duplicates?

A

Unique values (change to yes)

32
Q

What must records in the two tables posses in order to be joined?

A

A common field

33
Q

What is a calculated field?

A

Field that can be computed from other fields

34
Q

What is grouping?

A

Creating groups of records that share a common characteristic

35
Q

Which view is most often used when creating queries?

A

Design view

36
Q

What are wildcards?

A

Symbols that represent any character or combination of characters

37
Q

What is a wildcard for a individual letter called?

A

A question mark (?)

38
Q

What is a parameter query?

A

Query that prompts for input whenever it is used

39
Q

In what must a value be enclosed when making a parameter query?

A

Square brackets

40
Q

What is the first step when working with putting data in a special order?

A

Determine whether sorting is required

41
Q

What comparison operator is NOT used in Access?

A

Not equal to

42
Q

What is sorting?

A

To order the records to the answer to a query in a particular way

43
Q

What is the first step when designing a query?

A

Click query design

44
Q

What is the Zoom dialog box used for?

A

To enter calculated fields

45
Q

What is a query?

A

A question presented in a way access can process?

46
Q

What are the two query views?

A

Data sheet view and design view

47
Q

What are the ways to view query results?

A

Run/ view

48
Q

What are the stood in the Query Wizard?

A
  1. Pick type of query
  2. Select fields
  3. Give it a name

Computer Applications (2 decks)

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