Access MCQs

Access MCQs

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.

1: True or False: Embedded macros can be attached to the event property of a form, report or control.

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.

3: What would Format("1267.5", "Currency") return?

A.   $1,268

B.   $1,267.5

C.   $1,264

D.   $1267.5

E.   $1,267.50

4: What is a report?

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.

5: How to you ensure that a field is filled out properly?

A.   Delete the field.

B.   Change the font size.

C.   Use a validation rule.

D.   Adjust the field width.

6: What is the maximum number of indexes that you can create on an Access table?

A.   32

B.   15

C.   10

D.   5

E.   9

7: If tables are for storing data, what are queries used for?

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.

8: A primary key can be described as:

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

9: The Is Null criteria searches for fields that are ____.

A.   full

B.   empty

C.   None of these

D.   accurate

10: What would LCase("124ABCd") return?


B.   124abcd

C.   d

D.   abcd

11: Can a primary key be used as a non-primary key in another table?

A.   Does not apply to tables.

B.   Only with a MACRO.

C.   Yes

D.   No

12: To change the type of data input for a specific field, you:

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

13: Before you split a database, you should:

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

14: What happens when you freeze a column?

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

15: In an Access Query, if you would like your result to display blank values, what criteria would you use?

A.   is not null

B.   is null

C.   is like 0

16: This holds data in a database:


B.   Report

C.   Table

D.   Form

17: The functions of Avg, Sum, Count, etc. can be found in which tool group?

A.   Totals

B.   Append

C.   Sort

D.   Property Sheet

18: Which query can you delete records?

A.   Delete Query

B.   Record Query

C.   Removal Query

D.   Update Query

E.   None of the above

19: What is a primary key?

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.

20: What is the best way to view and print the results of a query?

A.   Table

B.   Report

C.   Export

D.   Form

21: What is a 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

22: Which data type allows for text and numbers to be added to a field?

A.   Date

B.   Number

C.   Hyperlink

D.   Text

23: True or False: You cannot assign a Macro to a Command Button.

A.   True

B.   False

24: Which database object acts as a storage container for the data?

A.   Report

B.   Table

C.   Form

D.   Query

25: To edit how a form looks, you go to:

A.   Print preview

B.   Query Manager

C.   Form view

D.   Design view

26: You can edit the field size for allowable characters in:

A.   Datasheet View

B.   Design View

C.   None

D.   Pivot Chart View

27: What character do you use to concatenate two character strings?

A.   * (Asterisk Operator)

B.   ! (Exclamation Operator)

C.   # (Hash Operator)

D.   & (Ampersand Operator)

28: Which of the following is NOT a valid data type in an Access table?

A.   Text

B.   Memo

C.   AutoNumber

D.   AutoIncrement

29: How do you ensure that a field is filled out in a table?

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"

30: Why use a database instead of a spreadsheet?

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.

31: Which of these is a proper example of how to write an equation for a query?

A.   (Amount)+(Field Name)

B.   \Amount\ + \Field Name\

C.   Amount + Field Name

D.   [Amount]+[Field Name]

32: Can relationships be between primary keys and non-primary keys?

A.   Yes

B.   No

C.   Only with a query.

D.   Does not apply to tables.

33: What does field size do?

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.

34: A good feature for having a unique primary key is:

A.   Use the AutoNumber feature

B.   Double check daily

C.   Use a MACRO to double check

D.   Set the font to bold.

35: What is a caption?

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.

36: To ensure a value no greater than 30 is entered into a field you would use:

A.   A default value

B.   A Caption

C.   A validation rule

D.   An Input Mask

37: If you delete a field from a table:

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

38: What do you call a value that is automatically entered in a filed for new records?

A.   Text

B.   Default value.

C.   Primary Key.

D.   Date/Time value

39: Which of these would be a proper way to type a parameter?

A.   (Where was this shipped to?)

B.   *Where was this shipped to?

C.   #Where was this shipped to?

D.   [Where was this shipped to?]

40: How do you make sure that a field from a query is displayed in the results?

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

41: Why should you enter sample data in tables after creating them?

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

42: When you press the Tab key, which way does the insertion point go?

A.   To the end of the document

B.   Within the same field

C.   The adjacent field

D.   A new record

43: The Where function does what?

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

44: Which two objects can a report object be based on?

A.   Query and Page

B.   Table and Query

C.   Form and Query

D.   Macro and Table

45: What language is used to extend and automate MS Access?

A.   Visual Basic for Applications

B.   Visual C#

C.   Visual Basic .NET

D.   Visual Binary for Applications

46: Which of the following takes you through the process of creating a table

A.   Wizard

B.   Table Assistant

C.   Query

D.   Relation

47: How do you create a new table by importing an Excel Spreadsheet?

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

48: What is the shortcut key combination for stopping the execution of a query?

A.   Shift+Enter

B.   ALT+F11

C.   CTRL+ALT+Delete

D.   ALT+Enter

E.   CTRL+Break

49: What is the file extension of an Access 2010 database?

A.   .xlsx

B.   .mdf

C.   .accdb

D.   .mdb

50: Access _____ the saved query each time it is opened.

A.   rewrites

B.   protects

C.   deletes

D.   runs