Access 1 Flashcards

1
Q

Datasheet View

A

Table open in access

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

Row > Access

A

Record

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

Column > Access

A

Field

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

What can you do in Datasheet view?

A

Add, Update, Delete, Sort, or Filter records

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

What can you do in Datasheet view?

A

Add, Update, Delete, Sort, or Filter records

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

Design View

A

Design the structure of the table.

**A table must be “designed” before you can enter data

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

Assign in design view

A

Each field has a field name and a data type

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

Field Size

A

Text: Length of text data
Number: Type of number

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

Format

A

Determines how you want Access to display data

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

Primary Key

A
A field (sometimes multiple fields) whose values are unique for all records.(PO #)
  **No duplicates or spaces
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Input Mask

A

Controls how data is entered

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

Foreign Key

A

References another column (most often the primary key) of another table

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

what are square brackets used for

A

[To designate field names]

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

Aliases

A

A field alias is created by preceding the column heading with the alias and then a colon.

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

Crosstab Query

A

An aggregate query that summarizes values in a matrix layout.

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

Parameter query

A

A query that asks you to enter criteria before the query is run.

17
Q

IIF

A

-Allows you to check if a condition occurs, and then show the result based on the condition.

IIF([babies] = 2, “Twins”, “Not Twins”)
18
Q

Lookup

A
  • 2 options
    • List Box:
    • Value List: options separated by ;