Which feature provides the capability of setting a form field at a desired location in a form and restricting its movement? Form anchoring
Conditional formatting
Expression Builder
Arrange tables

Which file format produces a lock-down version of an Access database?

Accdb
Accdb-be
Accde
Accdb-e

Mohammed needs to ensure that users can execute a query against a table but provide different values to the query each time it is run. Which option will achieve this goal?

parameter queries
dynamic queries
query joins
static queries

Which term is used in object-oriented programming to reference characteristics of an object?

class
methods
features
attributes

Taran is concerned with the security of his macros in a database. Which security option could he use to provide protection?

digital signatures
hide database objects
start-up options
secure VBA code

Samuel needs to import information from Excel to an Access table, but he wants to ensure that if the source table is changed, the information in Access will be updated automatically. What should he do?

Create a new copy of the Excel spreadsheet and import it.
Create a linked copy of the Excel spreadsheet.
Create a linked database and merge it with the Excel spreadsheet.
Create a new database and import the Excel spreadsheet.

Which word has special meaning in VBA, like a function or subprocedure?

expression
statement
keyword
variable

Montel needs to add a calculated field into a report that he has built that will show the total sale price of items sold in a given month. Which type of control should he add in Design view?

control box
text box
label
subreport

I know it's a lot but I really need some assistance, thanks people!