Access Exam - Intro to Computer Systems2

expression

a statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation

common field

a field that appears in more than one table, allowing you to connect the records in the separate tables

form view

the Access view you use to view, enter, and maintain data in the table on which a form is based

primary key

a field, or a collection of fields, whose values uniquely identify each record in a database table

Database Management System (DBMS)

a software program that lets you create databases and then manipulate data in them

comparison operator

in a query, an operator that asks Access to compare the value in a database field to the condition value and to select all the records for which the relationship is true

home tab

a ribbon tab that provides access to frequently used commands

design view

the Access view you use to define or modify a table structure or the properties of the fields in a table

layout view

the Access view in which you can make design changes to a form or report while it is displaying data so that you can immediately see the effects of changing the design

relational database management system

a software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field

record

a complete set of field values for a specific person, place, object, event, or idea

foreign key

a primary key field from one table that you include as a field in a second table to form a relationship between the two tables

data type

the field property that determines what field values you can enter for the field and what other properties the field will have

theme

a predefined set of formats for text, colors, images, and graphical effects that are applied throughout a document to create a specific look and feel

condition

a criterion, or rule, that determines which records are selected in a query

sort field

the field used to determine the order of records in a datasheet

control layout

a set of controls grouped together in a form or report so that you can manipulate the set as a single control

run (a query)

answering a query and displaying the results

field

a single characteristic or attribute of a person, place, object, event, or idea

query

a question you ask about the data stored in a database; in response, Access displays the specific records and fields that answer your question

aggregate function

a function that performs an arithmetic operation on selected records in a database

zoom box

a dialog box you can use to enter text, expressions, or other values

logical operator

in a query, an operator that allows you to combine two or more conditions

report wizard

an Access tool that asks you a series of questions, and then creates a report based on your answers

find command

a command you use to search for data in a form or a table or query datasheet so that you can locate a specific field value or part of a field value

join line

in the Relationships window, the line that connects the common field that joins two tables

primary table

A form created from more than one table uses the _____________ for the main form.

redundant key

a primary key that consists of two or more fields

multitable query

a query based on more than one table

one or more

Access may base query on ___________ tables or queries.

spaces

Experienced database developers avoid using ______ in field names and object names because names with ______ might cause errors if the objects are involved in programming tasks.

64

How many characters may a field name in Access contain including numbers, letters, spaces and special characters?

ID field

the default primary key for an Access database

long integer

the default setting for the Field Size property for a field with the Number data type

-

the character that represents the wildcard character that matches any one of a range of characters in ascending order

False

True or False: All fields in a database should be contained in one table.

True

True or False: Access does not require a field description for every field included in a table.

one-to-many

a relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table

False

True or False: Access automatically assigns the Number data type to all new fields.

wildcard character

a placeholder used in a search when the search should start or end with a specific character or match a particular pattern

False

True or False: A question asked about the data stored in a database is called a primary key.

True

True or False: Access does not require a table to have a primary key.

True

True or False: A form created from more than one table uses the primary table for the main form.

False

True or False: A sort field is unique if more than one record can have the same value for the sort field.

False

True or False: A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.

False

True or False: A single characteristic or attribute of a person, place, object, event, or idea is a table.

the query is run

A calculated field created in a query generates results when ________________.

True

True or False: A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).

False

True or False: A query is used to enter, edit, and view records in a database.

False

True or False: Access does not allow data to be imported from sources other than another Access database.

detail record

a set of field values for a record that is found in a table related to the primary table on which a report is based