Access
select
(n) ____________ query displays a subset of data from one table based on specified criteria. A. select B. variable C. operational D. join
join
A ____________ query displays a subset of data from two or more tables using a common field. A. select B. complex C. table D. join
record
A group of related fields in a database is called a(n): A. record. B. object. C. memo. D. table.
table
A group of related records in a database is called a(n): A. column. B. object. C. key. D. table.
relations
A relational database organizes data by logically grouping similar data into ____________, or tables that contain related data. A. keys B. relations C. fields D. records
Must be unique for every field
A tables primary key must
Stores one unique piece of data in only one table
A well-designed database...
object-oriented
A(n) ____________ database stores data in objects, not in tables. A. object-oriented B. relational C. multidimensional D. object-relational
query
A(n) ____________ enables users to have the database select and display records that match a certain criteria. A. query B. sort C. operation D. join
Calculated field
A_______ displays a value returned by an expression.
Select query
A_______ displays data from one or more tables or queries, based on the fields that you select.
bound
A________ text control displays data from a field.
Subform
A_________ is a form within a form that displays records related to the record in the main form.
Split Form
A__________ combines the convenience of a continuous Datasheet form with the usability of a single record form displaying one record at a time.
Table
All data entered into a form are stored in the underlying
Forces users to enter data in a consistent format.
An input mask..
Calculated
An unbound text box control that contains an expression (formula) is called a _______ control.
Tables
Are the basic building blocks of a database
field list
Click and drag fields from the ______ to add controls to a blank report
Field
Each column in a table represents a specific data value called a
Record
Each row in a table contains all the data for a single
Not equal to.
Entering<>80 as the criteria for a query will return results that are______________.
Report footer section
Grand totals in a report are added to the_________.
You cannot add a record to the secondary table without an associated record in the primary table, AND you cannot make changes to the primary table that would cause records in the secondary table to become unmatched.
If two tables have referential integrity enforced,
uppercase
If you enter .> in the field format property, all text will appear in which format?
Field validation rule
If you require a value in a field to always be less than 25, which of the following you use?
Record Validation Rule
If you require the value in one field in a table to always be greater than the value of another field in the table, which of the following would you use?
Unmatched Query Wizard
If you want to create a query that shows record from one table that have no corresponding records in another table use a________.
Duplicates
If you wanted to display records of all employees who live in the same city (from the city field in the table), you would use a __________.
field
In a database, a category of information is stored in a(n) ____________.
key
In a relational database, tables are logically linked to each other by a: A. key. B. hyperlink. C. field type. D. field size.
input form
In addition to keying data directly into the database, data entry can be done from a(n): A. input form. B. table. C. field. D. data dictionary.
relationships
The premise behind a relational database is that ____________ are established among the tables. A. relationships B. schema C. consistencies D. normalizations
layout
To change the direction a report prints on the page, change the page____________.
The field Size Property
To control the number of characters a user can enter into a table field.
attachment
To include a photo image with each record in a table, use a field with this data type...
false- compact and repair
True or False, Creating a backup of the database removes unnecessary file space and hidden
True
True or False, The input mask "ID"00999;0;_ will store the literal text "ID" in the database?
False-auto number is automatically assigned its value by access and they are often used as a primary key if no other unique field exists in the table
True or False, Users can enter and edit data in an Autonumber field
False- is ONLY temporary, if you want a more permanent filter apply it to criteria in design view.
True or false, Auto filter and Filter selection settings are saved with the database object.
True???
True or false, Page numbers can only be added to a footer section.
True
True or false, To Limit query results to only records that meet all the criteria, enter criteria for multiple fields on the criteria row, or enter multiple criteria for the same field separated by the word AND.
False- the UPPER pane shows the tables referenced in the query, the LOWER pane shows the query grid where you specify which fields to include in the query.
True or false, the upper pane in query Design view shows the query grid where you specify which fields to include in the query.
true
True/false Before working with a new blank database, you must save it as a new file.
Extracts data from a table or related tables. Also can update values or delete data. THE DATA IS NOT STORED PERMANENTLY.
What is a Query?
A primary key field from one table that you include as a filed in a second table to form a relationship between the two tables.
What is a foreign key?
A field, or a collection of fields, whose values uniquely and minimally identity each record in a database table and whose values do not change.
What is a primary key?
(*) (?) and "like" to find inexact text matches. The * wildcard replaces any string of characters. The ? replaced a single character. To include all record type Like "laskdbflksjbdf?"
What is a wildcard?
Quick start
What is the easiest way to add address fields and other common field groups to your table?
validation rules
When entering data, violations of ____________ usually result in error messages. A. data entry B. validation rules C. arithmetic operators D. computation
true
When importing data into access, you can identify a column or field from the imported data as the primary key
Undo the entire record at once
When you are entering data in a new record in a form, the undo command will
Parameter Query
When you create a ________, you specific the field or fields that the query will use, but you don't specify the exact criteria.
Page numbers
Which design elements is not available in forms?
contacts
Which of these Quickstart application parts would be most useful in a database that manages customers?
You can export Access data to which of the file formats?
Word
You cannot import data into access from which of these file types?
True
You must manually save the record each time you enter data in a table or form
Criteria
________ are conditions that the records must meet in order to be included in the query results.
Double-click the column header and type the new field name OR right-click the column header and select Rename field and type the new field name.
to rename a field...
False- right click
true or false, To rename a database object, double-click the name in the Navigation Pane and type the new name.
False
true or false, the currency field format is the same as currency data type
False- ex: .05 displays as 5, and 5 displays as 500.
true or false, the percent field format displays the % symbol in the data table.
false
true or false, you can undo a record deletion