Table
Query
Form
Report
Random
100
When entering data into a table which is NOT a method to correct typing errors? A. Delete the entire record by clicking the record selector and choosing the delete command. B. Backspace to remove characters to the left. C. Use the mouse to select the text to the replace and enter in the correct data.
A. Delete the entire record by clicking the record selector and choosing the delete command
100
What type of query is used when no restrictions, calculations, or special order must be applied to the data? A. Simple query B. Crosstab query C. Duplicates query D. Unmatched query
A. Simple query
100
What type of form enables a user to simultaneously view both simple form and database views of the data? A. Split B. Dual C. Divided D. Distributed
A. Split
100
What are the objects that appear in a report called? A. Fields B. controls C. switches D. Sections
B. Controls
100
What are the keyboard code icons that appear in Access 2010 when the ALT key is pressed on the key board? A. Key codes B. Key tips C. Screen tips D. Screen codes
B. Key tips
200
In a table, which of the following contains information about a given person, product, or event? A. Cell B. Column C. Record D. Field
C. Record
200
What object may be used in a simple query? A. Marco B. Report C. Form D. Table
D. Table
200
What is an automated step-by-step method for creating a form in a database called? A. Form wizard B. Form designer C. Form creator D. Auto form
A. Form wizard
200
Which of the following is used to display data that comes from the database in a report? A. Calculated controls B. Sections C. Bound controls D. Unbound controls
C. Bound controls
200
What is the meaning of the downward point arrows that appear with some Ribbon commands? A. Related commands available B. Dialog box attached C. Launch command D. Open command window
A. Related commands available
300
In a table, what contains a specific piece of information within a row? A. Cell B. Column C. Record D. Field
D. Field
300
How is a query stored after it is created and saved? A. As an image B. As a database object C. As a database macro D. As a database code
B. As a database object
300
Which view is used to manipulate the placement of form controls in a form? A. Layout view B. Design view C. Print preview D. Form view
B. Design view
300
Which of the following is used to display information that does not come from the database in a report? A. Calculated controls B. Sections C. Bound control D. Unbound control
D. Unbound control
300
Which is the process of organizing together records that share a common characteristic? A. Sorting B. Grouping C. Filtering D. Ordering
B. Grouping
400
in a table which is a way of exclusively identifying each record in a database? A. Unique marker B. Unique identifier C. Primary marker D. Primary category
B. Unique identifier
400
In a query, what condition must the records that are included satisfy? A. Measure B. Benchmark C. Criterion D. Principle
C. Criterion
400
Which Ribbon contains the command to add specialized items such as a date and time to a form header? A. Form layout tools design ribbon B. Form layout tools arrange ribbon C. Form layout tools format ribbon D. Form layout tools modify ribbon
A. Form layout tools design ribbon
400
Which Ribbon contains the command to apply a background image in a report? A. Report design tools design ribbon B. Report design tools arrange ribbon C. Report design tools format ribbon D. Report design tools page setup ribbon
C. Report design tools format ribbon
400
Which does NOT reflect an item that the designer must verify PRIOR to creating the database? A. Questions that the database should be able to answer B. Colors or design elements to include C. The audience that will use the database D. How the data is related
B. Color or design elements to include
500
in the table design view which area contains commands for designating a specific field size? A. Field properties B. Table tools C. Field options D. Table controls
A. Field properties
500
Which view allows a user to specify fields, criteria, sorting, and calculations when creating a query? A. Data sheet B. Design C. File D. Backstage
B. Design
500
Which Ribbon contains the command to modify the appearance of a control in a form? A. Form layout tools deign ribbon B. Form layout tools arrange ribbon C. Form layout tools format ribbon D. Form layout tools modify ribbon
C. Form layout tools format ribbon
500
Which command is used to emphasize values in a column that satisfy certain criteria by formatting them differently in a report? A. Criterion B. Conditional formatting C. Value formatting D. Rule specification
B. Conditional formatting
500
What type of database is a collection of data that is NOT related to any other collection of data? A. Joined B. Relational C. Flat D. Managed
C. Flat
M
e
n
u