Microsoft Access Assessment

Q1. Which form view mode allows you to preview live data while you work on the design of the form?

Q2. How can you add multiple view button controls to a form at once?

Q3. What is the Access string operator that joins or concatenates text strings together?

Caveat: “In a desktop database, you can also use the ampersand operator (&) for concatentation. In an Access app, you must use the plus sign (+).”_

Q4. The relationship field in this table has been created with what feature?

<p align="center"><img src="./images/question_4.png"></p>

Q5. On a report, you want to display a header for each change in month name. How should you set up the Group and Sort options so that they are in the proper chronological order?

Q6. What kind of query will display data with both column headers and row headers?


Q7. What currency format displays a thousand separator, but not a currency symbol, such as $ or €?


Q8. In Access Option > Current Database, what does turning off the Allow Full Menus option do?


Q9. You want to create a form to view customer’s details, as well as some information about all order that the customer has placed with your company. What is the best way to display this information on a single screen?

Q10. You want a form to appear automatically, whenever the database starts. How do you do this?


Q11. In Design view, which area of a form is the primary location for text boxes, buttons, and other control objects?

Q12. What tool builds a report containing detailed information about the object in the database?


Q13. You want to validate a proposed modification to a record’s value before the table is saved to the database. What data macro can you add to the table to do this?

Q14. When you add a group to a report, what automatically gets added to the structure?


Q15. A table contains a field with the lookup properties set as shown. What will be the value of the field when the end user clicks Normal from the combo box when entering a record into the table?

General Lookup
Display Control Combo Box
Raw Source Type Value List
Raw Source 1:”High”; 2 :”Normal”; 3: “Low”
Bound Column 1
Column Count 2
Column Heads No
Column Widths 0; 1
List Rows 16
List Width Auto

Q16. What program flow function evaluates a condition and either returns a truepart or a falsepart?

Q17. The display for numerical data defaults to a **_alignment, and text data defaults to **_aligntment

  1. Text:
  2. Numerical:

Q18. Which data type is a modern replacement for the OLE Object data type?


Q19. How can you ensure that each value saved in a particular field is unique from all other values in the field?



Q21. When backing up an Access database, what is added to the file name automatically?

Q22. Which table field property, if supplied, will display instead of the field name as a column header when viewing the datasheet of as a label when the field is added toa form or report?


Q23. Which form control property creates a small pop-up flag that contains text when a user hovers the mouse cursor over the object?

Q24. The expression values <=, <>, and > are found in what expression category?


Q25. Which section of a report appears at the top of every page in the printed report?


Q26. When would you use a left join query?

Q27. How can you run a submacro saved in a macro?

Q28. Which combo box property defines what values appear when the user clicks the drop-down arrow?

Q29. What does the expression Now() evaluate to?

Q30. Certain words have special meaning to Access, and you should avoid using them as table or field names. What are these words called?