The following Access MCQs have been compiled by our experts through research, in order to test your knowledge of the subject of Access. We encourage you to answer these multiple-choice questions to assess your proficiency.
Please continue by scrolling down.
A. False
B. True
A. Set up Forms with the right data
B. Use the Relationships property to define them.
C. Delete all old files.
D. Build queries.
A. $1,268
B. $1,267.5
C. $1,264
D. $1267.5
E. $1,267.50
A. A MACRO controlled document.
B. The opposite of a query.
C. The best method for printing the results of data in a database.
D. A way to store data in a database.
A. Delete the field.
B. Change the font size.
C. Use a validation rule.
D. Adjust the field width.
A. 32
B. 15
C. 10
D. 5
E. 9
A. Displaying and printing the data you wish to see.
B. Enforcing primary key relationships.
C. Keeping all MACROs operating.
D. Retrieving the data you want from the tables.
A. The field the only contains uppercase values
B. Any field
C. The only field in a table
D. A field or a combination of fields that contain unique values
A. full
B. empty
C. None of these
D. accurate
A. FALSE
B. 124abcd
C. d
D. abcd
A. Does not apply to tables.
B. Only with a MACRO.
C. Yes
D. No
A. All of these
B. Change the type in the Datasheet menu, under Data Type
C. Change view to Design, and change the data type
A. Create a new table in the same file
B. Convert the database into an Excel spreadsheet
C. Back up the database file
D. Create queries for all fields
A. It prevents all other columns from being moved
B. It prevents the column from moving positions
C. It makes the selected column move easier
D. It hides a column
A. is not null
B. is null
C. is like 0
A. MACRO
B. Report
C. Table
D. Form
A. Totals
B. Append
C. Sort
D. Property Sheet
A. Delete Query
B. Record Query
C. Removal Query
D. Update Query
E. None of the above
A. It uniquely identifies each list in a query.
B. It uniquely defines each list in a report.
C. It identifies multiple records in a table.
D. It uniquely identifies each record in a table.
A. Table
B. Report
C. Export
D. Form
A. An Access object where you can enter, edit or display data from a table only
B. An Excel object where you can enter, edit or display data from a table
C. An Access object where you can enter, edit or display data from a query only
D. An Access object where you can enter, edit or display data from a table or query
A. Date
B. Number
C. Hyperlink
D. Text
A. True
B. False
A. Report
B. Table
C. Form
D. Query
A. Print preview
B. Query Manager
C. Form view
D. Design view
A. Datasheet View
B. Design View
C. None
D. Pivot Chart View
A. * (Asterisk Operator)
B. ! (Exclamation Operator)
C. # (Hash Operator)
D. & (Ampersand Operator)
A. Text
B. Memo
C. AutoNumber
D. AutoIncrement
A. Zoom to the field.
B. Make the field set to the "Memo" data type.
C. Use a filter.
D. Set the "Required" setting to "Yes"
A. Spreadsheets do not chart well.
B. Databases are easier to set up.
C. Multiple data from various tables are needed.
D. Databases and Spreadsheets are interchangeable.
A. (Amount)+(Field Name)
B. \Amount\ + \Field Name\
C. Amount + Field Name
D. [Amount]+[Field Name]
A. Yes
B. No
C. Only with a query.
D. Does not apply to tables.
A. Keeps the minimum number of characters in a field above a preset amount.
B. Sets the size of a report.
C. Restricts the number of characters in a field to a preset amount.
D. Sets the size of a form.
A. Use the AutoNumber feature
B. Double check daily
C. Use a MACRO to double check
D. Set the font to bold.
A. Used as a user note on an opening form.
B. The label for a field when used on a form.
C. The same as a text box.
D. Sets a default value.
A. A default value
B. A Caption
C. A validation rule
D. An Input Mask
A. Only the data is erased
B. Only a certain piece of data is erased
C. Both the field and the data are erased
D. Only the field is erased
A. Text
B. Default value.
C. Primary Key.
D. Date/Time value
A. (Where was this shipped to?)
B. *Where was this shipped to?
C. #Where was this shipped to?
D. [Where was this shipped to?]
A. A Form pushbutton is added
B. The "Show" checkbox is checked
C. A Report displays the Query
D. The "Show" checkbox is not checked
A. To create a preliminary list of fields
B. To identify primary and foreign keys
C. To review existing data
D. To check for potential data maintenance problems
A. To the end of the document
B. Within the same field
C. The adjacent field
D. A new record
A. Counts the number of records that match in a field
B. Duplicates records displayed
C. Limit records displayed to those that match a condition
D. Creates a calculated field
A. Query and Page
B. Table and Query
C. Form and Query
D. Macro and Table
A. Visual Basic for Applications
B. Visual C#
C. Visual Basic .NET
D. Visual Binary for Applications
A. Wizard
B. Table Assistant
C. Query
D. Relation
A. External Data tab->Excel button in Export group
B. Internal Data tab->Excel button in Export group
C. External Data tab->Excel button in Import group
D. Create->export->Excel
A. Shift+Enter
B. ALT+F11
C. CTRL+ALT+Delete
D. ALT+Enter
E. CTRL+Break
A. .xlsx
B. .mdf
C. .accdb
D. .mdb
A. rewrites
B. protects
C. deletes
D. runs