Access
Data stored as a(n) ________ file cannot be imported into a table in Access.
Adobe PDF
In corporate databases, end users of a database computer system often use queries to enter and change data
False
The Format property tells Access how data is to be displayed
False
We use design view of a form to enter and edit data
False
When defining keys, the combination of two fields is called a natural primary key.
False
When the Report Wizard is done creating the report, it shows you the report in Layout view.
False
When you create a form from two tables that have a one-to-many relationship, the first table selected becomes the subform and the second table you select becomes the main form.
False
When you delete records from a table and realize you made a mistake, you can undo the deletion by clicking Undo in the Quick Access toolbar.
False
When you enter data in a form, it is stored in the form and not the table.
False
________ give more information on how the data is stored, entered, and processed.
Field properties
Calculated query fields must be formatted in the query design grid using the ________.
Field properties sheet
A ________ query is used when you want to find records with the same specific value.
Find Duplicates
A ________ query is used when you want to find the rows in one table that do not have a match in the other table.
Find Unmatched
Which of the following is NOT true regarding the Find Unmatched query?
The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query
A split form is a form created from one table, but it has a Form view and a Datasheet view in the same window.
True
Access is a relational database program
True
Which of the following is NOT true regarding split forms?
You can highlight a different record in the form part and the datasheet part at the same time.
When you ________, you select a value in a record and Access filters the records that contain only the values that match what you have selected.
filter by selection
There are ________ major kinds of form controls
three
A(n) ________ control is a control that does not have a source of data such as the title of the form.
unbound
When you want to specify multiple criteria, and all criteria must be true for a record to be included in the results, then the ________ logical operator is used.
AND
How is Access different from Excel?
Access allows multiple tables with relationships between the tables.
By default, records in a table or query are sorted by the foreign key field.
False
Design view of a table shows the data contents within a table.
False
Design view shows all the records and fields at one time, which is one advantage to using it to update your records.
False
A report in Access has _____ views.
4
Which of the following is NOT true regarding database design?
A field is an instance of an entity.
Which of the following is NOT true about applying filters to a datasheet?
A filter is a condition you apply permanently to a table or query.
Many-to-many
A many-to-many relationship is really two one-to-many relationships with a junction/link table.
While Access allows you to leave several tables open at the same time, it is a good idea to get into the habit of ________ a table when you are finished with it.
Closing
________ define the kind of data that can be entered into a field, such as numbers, text, or dates.
Data types
________ allows you to change more details of the report design or add other controls that are only available in this view.
Design view
Which of the following is NOT one of the three steps in database design?
Determine the queries you want to create.
Which of the following is NOT true regarding tables and relational databases?
Do not use special characters, such as an underscore, in table names.
A many-to-many relationship is a relationship between tables in which one record in one table has many matching records in a second table, and one record in the related table has many matching records in the first table.
False
A primary key is a value in a table that is the foreign key of another table.
False
A report is an object in Access that you can use to enter, edit, or view records in a table.
False
A text box control represents the actual value of a field and is an unbound control.
False
A ________ provides another interface beyond the table in Datasheet view.
Form
Which of the following is NOT true about editing, adding, and deleting records?
If the table is part of a relationship, referential integrity has been enforced, and the cascade delete option has been chosen, a record cannot be deleted if there are related records in another table until those records have also been deleted.
In a query, you can select any records that have no value in a field using the ________ criteria.
Is Null
________ allows you to modify the report while seeing the data.
Layout view
When you open a database, Access displays the ________ on the left side.
Navigation Pane
The ________ allows you to move to the top and bottom of a table or scroll to a specific record.
Navigation bar
Which of the following is NOT true about creating a report using the Report Wizard?
Once a report is created using the wizard, it will open in Design view.
The ________ Bar Open/Close button at the top of the pane opens and closes the pane.
Shutter
A ________ is used to ask questions about your data.
Query
The ________ Wizard starts similarly to the Query Wizard in selecting fields for the report.
Report
Which of the following is NOT a main object in an Access database?
Script
The most appropriate data type to use for a Street Address field is the ________ data type, so a street address can contain numbers, letters, and special characters.
Short Text
When you create a form from two tables that have a one-to-many relationship, the first table selected becomes the main form and the second table you select becomes the ________.
Subform
Which of the following is NOT true about creating queries in Design view?
The query window in Design view allows you to specify the data you want to see by building a query by wizard.
Which of the following is NOT true about multiple-table forms?
The subform will display "one" record in the one-to-many relationship.
Which of the following is NOT true about tables?
The upper pane of Design view has four columns: Field Name, Data Type, Length, and Description.
Which of the following is NOT true about form views?
To make any changes to the form you need to switch to either Layout view or Datasheet view.
Which of the following is NOT a method used to open or switch views?
To open an object in default view, double-click it in the Navigation bar.
An Access table looks similar to an Excel worksheet. Both have rows and columns of data. In addition, both applications can manage data, perform calculations, and produce reports
True
An input mask defines a consistent template and provides the punctuation, so you do not have to type it.
True
Changing the sort order of a table in a query does not affect how the data are stored, only how they appear in the query results
True
Comparison operators are used to compare the values in a table or another query with the criteria value in a query
True
Datasheet view shows all the fields and records at one time, which provides all the information you need to update your data, unlike in a form or query, where some of the fields or records may not be in view.
True
Datasheet view shows the values of the data within the table.
True
Datasheets are used to view all records in a table at one time.
True
Design view shows the structure of the table with the fields and their definitions.
True
Each row in an Access table is called a record
True
If your data has a unique identifier that is a natural part of your data, you can use the field as a natural primary key.
True
In addition to the Simple Query Wizard, there are three additional query wizards available to make quick, step-by-step queries.
True
The AutoNumber data type is used for keys.
True
The Query Wizard uses a question-and-answer dialog box to create a query.
True
The power of a database system comes with the ability to link tables together.
True
When creating a query with multiple criteria, the logical operators are used to combine these criteria.
True
You can easily import data from Excel to Access.
True
You can use both the AND and OR logical operators in design view of a query
True
Which of the following is NOT true when entering data manually?
When you open a table in Design view, you can type data directly into the table.
A(n) ________ is a step-by-step guide that walks you through tasks by asking you questions to help you decide what you want to do.
Wizard
To search for a word that starts with "ar" you would enter ________.
ar*
A(n) ________ control is a control whose data source is a field in the table such as the customer name.
bound
Access allows you to import a smaller portion of a worksheet, known as a ________, into a table.
named range
A(n) ________ key field is a field that uniquely identifies the record.
primary
A ________ is a form created from one table, but it has a Form view and a Datasheet view in the same window.
split form
To search for a three-letter word that starts with "t" and ends with "p" you would enter ________.
t?p