BAIS Access Practice Questions

1. The field property that automatically enters the same value into a field for each new record is called: Validation Rule, Default Value, Input Mask, Required, None of the above.

Default Value

2. The data type used when a field needs to store files such as images or documents is: Long Text, OLE Object, Attachment, Hyperlink, None of the above.

Attachment

3. A field that provides a drop-down list of values from which the user can select is referred to as a: Lookup Field, Calculated Field, Composite Field, Attachment Field, None of the above.

Lookup Field

4. Which database object is primarily used to store data in rows and columns? Query, Form, Table, Report, Macro.

Table

5. Which database object is primarily used to retrieve selected information from one or more tables? Form, Query, Report, Macro, Navigation Form.

Query

6. Which database object provides a user-friendly interface for entering, viewing, and editing records? Table, Query, Form, Report, Macro.

Form

7. Which database object is primarily used to organize and format data for viewing or printing? Table, Query, Report, Form, Relationship.

Report

8. A field that uniquely identifies every record in a table is called a: Foreign Key, Primary Key, Lookup Key, Composite Field, None of the above.

Primary Key

9. A field in one table that refers to the primary key of another table is called a: Foreign Key, Primary Key, Lookup Field, Validation Field, None of the above.

Foreign Key

10. In a one-to-many relationship, the infinity symbol represents the: One side, Many side, Primary key, Unrelated table, None of the above.

Many side

11. The Access feature that helps prevent records from referring to nonexistent related records is called: Referential Integrity, Validation Text, Input Masking, Indexing, None of the above.

Referential Integrity

12. Which table view is normally used to define field names, data types, primary keys, and field properties? Datasheet View, Design View, Form View, Report View, Print Preview.

Design View

13. Which table view is normally used to enter and view the actual records stored in a table? Design View, Datasheet View, Layout View, Print Preview, SQL View.

Datasheet View

14. In a query, criteria placed on the same Criteria row are interpreted as: OR, AND, NOT, XOR, None of the above.

AND

15. In a query, criteria placed on separate Criteria and Or rows are generally interpreted as: AND, OR, NOT, Equal, None of the above.

OR

16. Which criteria would find all records in which a Last Name begins with the letter S? "S", Like "S", Like "S", Like "S", >"S".

Like "S*"

17. Which criteria would find records containing the word Island anywhere within a text field? Like "Island", Like "Island", Like "Island", "Island", Between "Island" And "*".

Like "Island"

18. Which symbols are used around literal dates in Microsoft Access query criteria? Quotation marks, Parentheses, Number signs (#), Brackets, Asterisks.

Number signs (#)

19. Which of the following correctly specifies a date range in Access? Between "1/1/2026" And "6/30/2026", Between #1/1/2026# And #6/30/2026#, >1/1/2026<6/30/2026, Like #1/1/2026-6/30/2026#, None of the above.

Between #1/1/2026# And #6/30/2026#

20. In query criteria, the symbol <> means: Greater than, Less than, Equal to, Not equal to, Greater than or equal to.

Not equal to

21. A query that asks the user to enter information each time the query runs is called a: Crosstab Query, Parameter Query, Update Query, Delete Query, Totals Query.

Parameter Query

22. Which of the following represents a parameter query prompt? "Enter City", #Enter City#, [Enter City], Enter City, {Enter City}.

[Enter City]

23. Which of the following is the proper basic format for creating a calculated field in a query? [New Field]=Field1+Field2, New Field: [Field1]+[Field2], New Field; Field1+Field2, Field1+Field2: New Field, None of the above.

New Field: [Field1]+[Field2]

24. Which aggregate function would be used to calculate the average of a numeric field? Sum, Count, Avg, Max, Group By.

Avg

25. Which aggregate function would be used to determine how many records appear in a group? Sum, Count, Avg, Min, Group By.

Count

26. A Crosstab Query organizes summarized information using: Headers and Footers, Rows and Columns, Forms and Reports, Primary and Foreign Keys, Macros and Modules.

Rows and Columns

27. A query designed to modify values already stored in existing records is a: Select Query, Update Query, Delete Query, Parameter Query, Crosstab Query.

Update Query

28. A query designed to permanently remove records that meet specified criteria is a: Update Query, Delete Query, Select Query, Append Form, Lookup Query.

Delete Query

29. The field property that determines whether a user is allowed to leave a field blank is: Default Value, Required, Validation Text, Format, Field Size.

Required

30. The property that specifies what values are permitted to be entered into a field is called: Validation Rule, Validation Text, Input Mask, Default Value, Format.

Validation Rule