Access 1 Flashcards
Datasheet View
Table open in access
Row > Access
Record
Column > Access
Field
What can you do in Datasheet view?
Add, Update, Delete, Sort, or Filter records
What can you do in Datasheet view?
Add, Update, Delete, Sort, or Filter records
Design View
Design the structure of the table.
**A table must be “designed” before you can enter data
Assign in design view
Each field has a field name and a data type
Field Size
Text: Length of text data
Number: Type of number
Format
Determines how you want Access to display data
Primary Key
A field (sometimes multiple fields) whose values are unique for all records.(PO #) **No duplicates or spaces
Input Mask
Controls how data is entered
Foreign Key
References another column (most often the primary key) of another table
what are square brackets used for
[To designate field names]
Aliases
A field alias is created by preceding the column heading with the alias and then a colon.
Crosstab Query
An aggregate query that summarizes values in a matrix layout.