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