FREE AND STUDY GAMES ABOUT ACCESS EXAM

PDF Download

FREE AND STUDY GAMES ABOUT ACCESS EXAM

QUESTIONS

Actual Qs and Ans Expert-Verified Explanation

This Exam contains:

-Guarantee passing score -75 Questions and Answers -format set of multiple-choice -Expert-Verified Explanation Question 1: the object that retrieves specific data and then displays only the data that you specify is a

Answer:

query Question 2: after a query has been designed to find the records that match the criteria, access must ______the query

Answer:

run

Question 3: ___indicate the groups of related commands on the displayed tab.

Answer:

group names Question 4: the width of columns in tables can be automatically increased to decreased to fit the contents which is known as ____

Answer:

best fit

Question 5: a file or multiple files can be ____into one smaller file that can be e-mailed or transferred over the Internet more easily.

Answer:

Compressed Question 6: the primary method of entering information into your computer is the

Answer:

keyboard Question 7: the selection or setting that is automatically used by a program unless you specify otherwise is called a _______setting

Answer:

default Question 8: Microsoft Office's ____feature provides information about all of the current programs features and displays step-by-step instructions for some tasks.

Answer:

Help Question 9: when creating a form or report the access view that allows changes while the object is open is _____view

Answer:

layout Question 10: A database _______ is pre-formatted database designed for specific purpose

Answer:

Template Question 11: using the _____dialog box you can navigate to and open and existing file created using the same program.

Answer:

open

Question 12: to use the start search feature, display the windows 8 _____and start typing

Answer:

start menu Question 13: Microsoft Office's ______view is a centralized space for tasks related to file management

Answer:

backstage Question 14: the box at the left of a record in datasheet view that you click to select an entire record is the

Answer:

record selector box Question 15: the characteristic that defines the kind of data you can store in a field is the

Answer:

data type

Question 16: In Microsoft access, all data is stored in one or more

Answer:

tables Question 17: the most common database objects are:

Answer:

tables, queries, forms, and reports Question 18: the data type that describes monetary values and numeric data used in mathematical calculations involving data with one to four decimal places is

Answer:

currency

Question 19: a container where files are stored is a

Answer:

folder

Question 20: to create a query using the simple query wizard, you choose the data source and:

Answer:

field names Question 21: the ____displays across the top of the program window, grouping commands features in the manner in which they would most logically be used.

Answer:

Ribbon Question 22: a shortcut menu displays:

Answer:

context-sensitive commands Question 23: to organize your database objects use the:

Answer:

navigation pane

Question 24: the ____displays Microsoft office backstage view

Answer:

file tab Question 25: in the navigation pane the view that groups a query with the table with its data source is

Answer:

tables and related views Question 26: the ____feature provides information about all of a program's features and displays step-by-step instructions for performing many tasks.

Answer:

Help Question 27: precise changes to the properties (characteristics) of selected items in a data base can be made in the

Answer:

property sheet