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
  • Create Tab
  • Navigation Pane
  • Long text
True/False: Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.
  • True
  • 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.
  • True
  • False
True/False: When a form is created based on two or more tables, a relationship must be defined between queries.
  • True
  • False
True/False: Expression Builder is found in the Query Setup group on the DESIGN tab.
  • True
  • False
True/False: It is more efficient to use the Query Wizard for common, informational queries than to design your own query.
  • True
  • False
True/False: A table is a predesigned database that includes professionally designed database objects
  • True
  • False
What are the four field naming guidelines?
  • Average, Count, Max, Min, Sum
  • Related Table
  • No SpacesCapitalize the first letter of each wordAbbr whn appr n necBreak into smallest part
  • Primary Table
Provides the main Access commands organized by task into tabs and groups.
  • Ribbon
  • Condition
  • Field
  • No SpacesCapitalize the first letter of each wordAbbr whn appr n necBreak into smallest part
True/False: Results of a query are narrowed by using the Or logical operator.
  • True
  • False
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.
  • True
  • False
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.
  • Design View
  • Short text
  • Report
  • Datasheet
You can use the _________ to enter an optional description for a field to explain is purpose or usage.
  • Description Property
  • Status Bar
  • Report
  • Navigation Pane
True/False: A query is used to enter, edit, and view records in a database.
  • True
  • False
The "many" table in a one-to-many relationship.
  • Create Tab
  • Related Table
  • Average, Count, Max, Min, Sum
  • Design View
True/False: The field name displayed in database objects, including forms and reports, is determined by the Caption property.
  • True
  • False
True/False: Layout view shows both the form and its data while allowing the form to be modified.
  • True
  • False
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
  • False
  • Report
  • True
true/False: A question asked about the data stored in a database is called a primary key
  • True
  • False
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
  • False
A question you ask about the data stored in a database.
  • Field
  • Table
  • Query
  • True
True/False: Access does not require a table to have a(n) primary key.
  • True
  • False
True/False: Report fields and field value boxes may be repositioned while viewing the report in Layout view.
  • True
  • False
The "one" table in a one-to-many relationship.
  • Primary Table
  • Navigation Pane
  • Table
  • False
True/False: It is not possible to create a query from more than one table.
  • True
  • 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
  • False
A criterion, or rule, that determines which records are selected.
  • Condition
  • Field
  • False
  • No SpacesCapitalize the first letter of each wordAbbr whn appr n necBreak into smallest part
A collection of related fields
  • Field
  • Record
  • Query
  • F6 Key
True/ False: Access does not allow data to be imported from sources other than another Access database.
  • True
  • 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.
  • True
  • False
What are the 8 data types?
  • Short text
  • Average, Count, Max, Min, Sum
  • Database
  • Short TextLong TextNumberDate/TimeCurrency AutoNumberYes/NoHyperlink
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
  • False
A collection of related tables
  • Datasheet
  • Primary Table
  • Table
  • Database
Provides information about the program or open file, as well as buttons for working with the file.
  • Design View
  • Datasheet
  • Database
  • Status Bar
True/False: The process of rearranging records in a specified order or sequence is referred to as sorting.
  • True
  • False
A field Description property can be up to _____ characters long.
  • Report
  • 255
  • False
  • True
An attribute of data that describes a person, place, object, event, or idea.
  • Query
  • Table
  • False
  • Field
True/False: The Tabular and Justified form report layouts display the fields from multiple records at one time.
  • True
  • False
True/False: Access does not require a field description for every field included in a table.
  • True
  • False
True/False: The only option available for creating tables in Access is to use the datasheet view.
  • True
  • False
True/False: A form created from more than one table uses the primary table for the main form.
  • True
  • False
A formatted printout (or screen display) of the contents of one or more tables (or queries) in a database.
  • Long text
  • False
  • Report
  • Create Tab
true/False: The query results are stored in the database in which the query has been created.
  • True
  • False
True/False: Each record in a table is uniquely identified by a foreign key.
  • True
  • False
True/False: Access report printing options may be changed using the Navigation dialog box.
  • True
  • False
Allows field values containing letters, digits, spaces, and special characters. Use for long comments and explanations.
  • Datasheet
  • Short text
  • Long text
  • Report
0:0:1



Answered

Not Answered

Not Visited
Correct : 0
Incorrect : 0