Access

A ________ control may be the name of the field or some other text you manually enter. A) label B) bound C) calculated D) text box

Answer: A

A ________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value. A) wildcard character B) Replace command C) Find command D) Find & Replace command

Answer: A

A report can be created from all of the following EXCEPT: A) one table. B) a form. C) multiple tables. D) a query.

Answer: B

A(n) ________ control is a control whose data source is a field in the table such as the customer name. A) unbound B) bound C) calculated D) text box

Answer: B

Being able to format a phone number in a field as (412) 555-8676 without manually entering the symbols occurs when a(n) ________ has been applied to the field. A) wizard B) link C) input mask D) relationship

Answer: C

Calculated query fields must be formatted in the query design grid using the ________. A) Navigation Pane B) Expression Builder C) Property Sheet D) Navigation bar

Answer: C

True or False? Before you can use two tables in a form, you must make sure there is a one-to-one relationship between the tables.

Answer: FALSE

True or 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.

Answer: FALSE

True or False? When you enter data in a form, it is stored in the form and not the table.

Answer: FALSE

True or False? Comparison operators compare the values in a table or another query to the criteria value you set up in a query.

Answer: TRUE

True or False? 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.

Answer: TRUE

Which of the following is NOT true about the Find Unmatched query wizard? A) The wizard uses the primary key from the first table and matches it with the foreign key in the second table in order to determine if there are unmatched records. B) 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. C) The wizard will try to match the primary key field and the foreign key field if there is a one-to-many relationship between the two tables. D) If a one-to-many relationship exists between the two tables, then the wizard will join the two correct fields automatically.

Answer: B

________ allows the specification of rules that apply formatting to cells or specific controls, as determined by the rule outcome. A) A theme B) Conditional formatting C) A control D) A group header

Answer: B

The ________ key in one table acts as a primary key of another table. A) numeric B) natural C) composite D) foreign

Answer: D

True or False? A person's phone number would serve as a good primary key.

Answer: FALSE

True or False? Relationships are links between the tables.

Answer: TRUE

If no sort criteria are specified when creating a query, Access will sort the results by the ________. A) first text field B) first numeric field C) foreign key D) primary key

Answer: D

You can use a database ________ to ask a question of the data. A) report B) form C) table D) query

Answer: D

True or False? Data is an important asset to any organization after it is converted to information.

Answer: TRUE

True or False? In addition to the Simple Query Wizard, there are three additional query wizards available to make quick, step-by-step queries.

Answer: TRUE

A ________ query is used when you want to find records with the same specific value. A) Find Duplicates B) Crosstab C) Find Unmatched D) Simple

Answer: A

The ________ view shows the query's structure. A) Query Results B) SQL C) Datasheet D) Design

Answer: D

Each column in an Access table is called a(n) ________. A) record B) field C) piece D) section

Answer: B

True or False? Form view is only for viewing data, so to make any changes to the form you need to switch to either Print Preview or Design view.

Answer: FALSE

True or False? The Simple Query Wizard provides the opportunity to select data criteria

Answer: FALSE

True or False? The Undo button will permit a user to undo up to 100 changes.

Answer: FALSE

True or False? The data contents within a table can be seen in Design view.

Answer: FALSE

True or False? To search for a three-letter word that starts with "t" and ends with "p" you would enter t!p.

Answer: FALSE

True or False? A filter is a condition you apply temporarily to a table or query

Answer: TRUE

True or False? A theme is a built-in combination of colors and fonts.

Answer: TRUE

True or False? An aggregate function can be used in Datasheet view by adding a total row to a table.

Answer: TRUE

True or False? A form with a subform allows you to see one record at a time from the main form and multiple records in Datasheet view from the other related table.

Answer: TRUE

True or False? A record is all of the data pertaining to one person, place, thing, or event.

Answer: TRUE

True or False? A split form is a form created from one table, but it has a Form view and a Datasheet view in the same window.

Answer: TRUE

True or False? Datasheets are used to view all records in a table at one time.

Answer: TRUE

True or False? Relationships between tables must be based on common fields.

Answer: TRUE

True or False? The process of normalization causes multiple smaller tables to be created.

Answer: TRUE

True or False? The size of a field can be changed in a table's Design view.

Answer: TRUE

True or False? When you have a one-to-one relationship, you could combine the two tables into a single table.

Answer: TRUE

True or False? If you want to insert data from another file into an Access database, you must use copy and paste.

Answer: FALSE

________ allows you to modify the report while seeing the data. A) Layout view B) Print Preview C) Report view D) Design view

Answer: A

Which of the following is NOT true about undoing in Access? A) If you have made changes to several fields in a single record, you can click Undo to undo each of them. B) Just like in other Office applications, there is a great deal of undo/redo functionality in Access. C) Pressing Esc gets you out of an error. D) Until the design of an object is saved, you can click Undo to undo design changes.

Answer: B

________ is a tool in Access that can help you format your calculated fields correctly. A) Navigation Pane B) Expression Builder C) Property Sheet D) Navigation bar

Answer: B

Data can be entered into a database using one of two methods: entering the data directly into the table or entering it in ________. A) a query B) a report C) a form D) the relationship window

Answer: C

In a database, data is stored in a ________. A) report B) form C) table D) query

Answer: C

Reports have ________ views. A) two B) three C) four D) five

Answer: C

When two fields are needed to uniquely identify a record, a ________ key is used. A) numeric B) natural C) composite D) foreign

Answer: C

________ an Access database rearranges objects so disk space is used more efficiently. A) Backing up B) Recovering C) Compacting D) Saving

Answer: C

A ________ helps create objects using a step-by-step process. A) template B) shortcut C) file extension D) wizard

Answer: D

The Navigation Pane is located on the ________ when Access is opened. A) top B) bottom C) right side D) left side

Answer: D

The ________ data type generates the value by automatically incrementing the value for each new record to produce unique keys. A) Short Text B) Calculated C) Number D) AutoNumber

Answer: D

To search for a word that begins with "ar" you would enter ________. A) ar? B) ar# C) ar! D) ar*

Answer: D

Which of the following is NOT true about multiple-table forms? A) The main form will display the first table one record at a time, just like a single-table form. B) Access will automatically use the common field between the tables to create the form. C) Before you can use two tables in a form, you must make sure there is a one-to-many relationship between the tables. D) The subform will display "one" record in the one-to-many relationship.

Answer: D

True or False? A column in an Access table is called a characteristic.

Answer: FALSE

True or False? A form pulls records from a table in an easy-to-read format suitable for printing.

Answer: FALSE

True or False? In Datasheet view, you can use the Replace command to quickly locate specific records using all or part of a field value.

Answer: FALSE

True or False? To search for a word that starts with "ar" you would enter ar*.

Answer: TRUE

True or False? When using the Find Duplicates Query Wizard, you select the fields that you think may include duplicate information, and the wizard creates the query to find records matching your criteria.

Answer: TRUE

A phone number is an example of a(n) ________. A) attribute B) entity C) relationship D) property

Answer: A

In a query, if you wanted to display the number of records retrieved, you would use the ________ aggregate function. A) Count B) Sum C) Minimum D) Maximum

Answer: A

The ________ in a table dictates what data can be stored in a field. A) data type B) description C) field name D) field properties

Answer: A

The ________ allows you to move to the top and bottom of a table or scroll to a specific record. A) Forward and Backward arrows B) Navigation bar C) Arrows bar D) Navigation Pane

Answer: B

Tables have ________ view(s). A) two B) three C) four D) one

Answer: A

Which of the following is NOT true about applying filters to a datasheet? A) A filter is a condition you apply permanently to a table or query. B) You can choose to save a table with the filter applied so when you open the table later the filter is still available. C) A filter is a simple technique to quickly reduce a large amount of data to a much smaller subset of data. D) All records that do not match the filter criteria are hidden until the filter is removed or the table is closed and reopened.

Answer: A

Which of the following is NOT true about creating a report using the Report Wizard? A) Once a report is created using the wizard, it will open in Design view. B) In the Report Wizard, you can choose the table or query to base the report on, and choose the fields to include in the report. C) In the Report Wizard, you have the option to group the data in your report. D) The Report Wizard will walk you step by step through the process of building your report.

Answer: A

________ perform arithmetic operations, such as calculating averages and totals, on records displayed in a table or query. A) Aggregate functions B) Special operators C) Comparison operators D) Is Null criteria

Answer: A

In a customer table, a(n) ________ field would serve as a good primary key. A) phone number B) customer ID C) address D) date of birth

Answer: B

The ________ view of a table displays the data stored in the table. A) Layout B) Datasheet C) Design D) Report

Answer: B

To calculate totals for smaller groups of records, use ________. A) the grand total B) subtotals C) a footer D) text box

Answer: B

When a database is ________, redundancy is minimized. A) shared B) normalized C) joined D) delimited

Answer: B

When the Report Wizard has finished creating the report, it shows you the report in ________. A) Layout view B) Print Preview C) Report view D) Design view

Answer: B

If one student in tblStudents can register for many classes in tblClasses, the relationship would be noted as a ________ relationship. A) many-to-many B) one-to-one C) one-to-many D) There would not be a relationship between the two tables.

Answer: C

In a database, a(n) ________ is a field that uniquely identifies a record. A) input mask B) Yes/No field C) primary key D) named range

Answer: C

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 ________. A) joined form B) co-form C) split form D) subform

Answer: D

Which of the following is NOT true regarding compound fields? A) Break product information into StyleNumber, Color, and Size fields. B) Break addresses into fields such as StreetAddress, City, State, and ZipCode. C) Break names into FirstName and LastName fields. D) Break dates into Month, Day, and Year fields.

Answer: D

True or False? A report allows you to enter, edit, and delete data.

Answer: FALSE

True or False? A text box control represents the actual value of a field and is an unbound control.

Answer: FALSE

True or False? Data is always stored in a form.

Answer: FALSE

True or False? Design view shows all the records and fields at one time, which is one advantage to using it to update your records.

Answer: FALSE

True or False? Backing up a database will help protect you against any mishaps with the original database such as accidental loss of data.

Answer: TRUE