A | B |
When a record has an entry that is unique to them, such as a customer number, this field is called a(n) _____. | primary key |
A _____ indicates the type of data that can be stored in a field. | data type |
The _____ data type can store a variable amount of text or combination of text and numbers. | Memo |
A _____ is a set of choices, often graphical, arranged in a grid or a list. {Page AC 20} | Gallery |
Access displays tabs, called _____, when you perform certain tasks. {Page AC 20} | Contextual Tabs |
The _____, which appears automatically based on tasks you perform, contains commands related to changing the appearance of text in a database object. {Page AC 21} | Mini Tool Bar |
A _____, which appears when you right-click an object, is a list of frequently used commands. . {Page AC 21} | Shortcut |
The _____ is a central location for managing and sharing database objects. . {Page AC 22} | Office Button |
A _____ contains a list of commands. {Page AC 22} | Menu |
To select a command using the keyboard, press its displayed code letter, or _____. {Page AC 23} | Key Tip |
The _____ is the small box or bar that, when you click it, selects the entire row. {Page AC 28} | Row Selector |
In _____, the table is represented as a collection of rows and columns. {Page AC 30} | Datasheet View |
A collection of rows and columns is called a _____. {Page AC 30} | Data Sheet |
Object tabs for the open objects appear at the _____ of the work area. AC18 | Top |
Navigation pane, Ribbon and Mini toolbar are part of the _____. AC17 | Access Window |
The file extension for Access 2007 is _____. AC13 | .accdb |
The _____ is the name assigned to a file when it is saved. AC13 | File Name |
The rows in the tables are called _____. AC4 | Records |
In a query, a _____ is a condition the records to be included must satisfy. AC81 | criterion |
_____ is data in a field whose data type is Text. AC86 | text |
A field that can be computed from other fields is called a _____. AC113 | calculated field |
_____ are symbols that represent any character or combination of characters. AC87 | wildcards |
A _____ is a query that prompts for input whenever it is used. AC89 | parameter |
A _____ is simply a question presented in a way that Access can process. AC74 | query |
A(n) _____ wildcard symbol represents any collection of characters. AC87 | asterisk |
In an _____ criterion, each individual criterion must be true in order for the compound criterion to be true. AC95 | AND |
The following is NOT a comparison operator: _____. AC94 | equal to |
A ____________________ is a line that Access draws between matching fields in two tables. {Page AC 105} | Join Line |
Microsoft Office Access 2013 is usually referred to as _____. | Access |
The rows in the tables are called _____. | Records |
File names can be a maximum of _____ characters long including the file extension. | 255 |
Navigation pane, Ribbon and Mini toolbar are part of the _____. | Access Window |
Object tabs for the open objects appear at the _____ of the work area. | Top |
The _____ is the name assigned to a file when it is saved. | File Name |