Access Tutorials 1-4

24 July 2022
4.7 (114 reviews)
66 test answers

Unlock all answers in this set

Unlock answers (62)
question
True/False: A database or a relational database is a collection of related tables.
answer
True
question
true/False: The query results are stored in the database in which the query has been created.
answer
False
question
true/False: A question asked about the data stored in a database is called a primary key
answer
False
question
True/False: Access report printing options may be changed using the Navigation dialog box.
answer
False
question
True/False: The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a datasheet.
answer
True
question
True/False: Each record in a table is uniquely identified by a foreign key.
answer
False
question
True/False: The only option available for creating tables in Access is to use the datasheet view.
answer
False
question
True/False: A table is a predesigned database that includes professionally designed database objects
answer
False
question
True/False: A query is used to enter, edit, and view records in a database.
answer
False
question
True/False: A single characteristic or attribute of a person, place, object, event, or idea is a(n) table.
answer
False
question
True/False: Relationship integrity is a set of rules used by Access to maintain consistency between related tables when data in either table is updated.
answer
False
question
True/False: Access does not require a table to have a(n) primary key.
answer
True
question
True/ False: Access does not allow data to be imported from sources other than another Access database.
answer
False
question
True/False: Access does not require a field description for every field included in a table.
answer
True
question
True/False: The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view.
answer
True
question
True/False: Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.
answer
True
question
True/False: In order to define table relationships, each table being joined must contain a common field.
answer
True
question
True/False: A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut.
answer
True
question
True/False: The field name displayed in database objects, including forms and reports, is determined by the Caption property.
answer
True
question
True/False: All fields in a database should be contained in one table.
answer
False
question
True/False: Hiding a field in Datasheet view removes the field from the current table.
answer
False
question
True/False: Changes made to a field in a query datasheet updates the same field in the table on which the query is based.
answer
True
question
True/False: A sort field is unique if more than one record can have the same value for the sort field.
answer
False
question
True/False: The process of rearranging records in a specified order or sequence is referred to as sorting.
answer
True
question
True/False: It is not possible to create a query from more than one table.
answer
False
question
True/False: Expression Builder is found in the Query Setup group on the DESIGN tab.
answer
True
question
True/False: It is more efficient to use the Query Wizard for common, informational queries than to design your own query.
answer
False
question
True/False: Access may base queries on one or more tables or queries.
answer
True
question
True/False: The contents of query datasheet are permanent.
answer
False
question
True/False: Results of a query are narrowed by using the Or logical operator.
answer
False
question
True/False: Layout view shows both the form and its data while allowing the form to be modified.
answer
True
question
True/False: A form created from more than one table uses the primary table for the main form.
answer
True
question
True/False: Report fields and field value boxes may be repositioned while viewing the report in Layout view.
answer
True
question
True/False: When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option.
answer
False
question
True/False: The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.
answer
False
question
True/False: A form's object name appears on the tab for the form in the Access window.
answer
True
question
True/False: The Tabular and Justified form report layouts display the fields from multiple records at one time.
answer
False
question
True/False: Field values edited in Form view are also changed in the form's underlying table.
answer
True
question
True/False: A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.
answer
False
question
True/False: When a form is created based on two or more tables, a relationship must be defined between queries.
answer
False
question
Provides options for creating various database objects, including tables, forms, and reports. The options appear on the tab grouped by object type.
answer
Create Tab
question
A question you ask about the data stored in a database.
answer
Query
question
A formatted printout (or screen display) of the contents of one or more tables (or queries) in a database.
answer
Report
question
Lists all the objects (tables, reports, and so on) in the database, and it is the main control center for opening and working with database objects
answer
Navigation Pane
question
Provides information about the program or open file, as well as buttons for working with the file.
answer
Status Bar
question
Displays the table's contents in rows and columns, similar to a table that you create in a word document or an excel spreadsheet.
answer
Datasheet
question
Provides the main Access commands organized by task into tabs and groups.
answer
Ribbon
question
Exists between two tables when one record in the first table matches zero, one, or many records in the second table, and hen one record in the second table matches at most one record in the first table.
answer
One-to-Many Relationship
question
The "one" table in a one-to-many relationship.
answer
Primary Table
question
The "many" table in a one-to-many relationship.
answer
Related Table
question
Allows you to define or modify a table structure or the properties of the fields in a table
answer
Design View
question
When defining the fields in a table, you can move from the Table Design grid to the Field Properties pane by pressing the ________.
answer
F6 Key
question
You can use the _________ to enter an optional description for a field to explain is purpose or usage.
answer
Description Property
question
A field Description property can be up to _____ characters long.
answer
255
question
A criterion, or rule, that determines which records are selected.
answer
Condition
question
Asks Access to compare the value in a field to the condition value and to select all the records for which the condition is true.
answer
Comparison Operator
question
A collection of related tables
answer
Database
question
A collection of related records
answer
Table
question
A collection of related fields
answer
Record
question
An attribute of data that describes a person, place, object, event, or idea.
answer
Field
question
What are the four field naming guidelines?
answer
No Spaces Capitalize the first letter of each word Abbr whn appr n nec Break into smallest part
question
What are the 8 data types?
answer
Short Text Long Text Number Date/Time Currency AutoNumber Yes/No Hyperlink
question
Allows field values containing letters, digits, spaces, and special characters. Use for names, addresses, descriptions, and fields containing digits that are not used in calculations.
answer
Short text
question
Allows field values containing letters, digits, spaces, and special characters. Use for long comments and explanations.
answer
Long text
question
A set of rules that Access enforces to maintain consistency between related tables when you update data in a database.
answer
Referential Integrity
question
What are the 5 aggregate functions?
answer
Average, Count, Max, Min, Sum