Designer Window
"Navigating" Access
Mystery
100

A recorded sequence of commands or keystrokes that can be saved and then executed, or run, by single action by the user.

What is a macro?

100

A control that displays a scroll-able list of values.

What is a list box control?

100

An object with tabs that allows you to display objects in an organized way to users.

What is a navigation form?

200


        Double Jeopardy

This is the number of common actions Access provides to include in macro.

200

These are the five main SQL statement types.

What are select, update, delete, insert, create?

200

A form that does not need data from a user defined table/query.

What is an unbound form?

300

This tab allows you to go into the window to create and modify macros.

What is the Macro Design?

300

This is the best practice covered in class when creating navigation forms dealing with opening the form.

What is ensure a form element has the focus when the form is opened?

300

This is the main reason you learn about SQL.

What is every full-featured relational DBMS has a version of SQL?

400

This is when you execute a macro one action at a time.

What is single stepping through a macro?

400


         Double Jeopardy

These group of objects are special objects maintained by access that store information about the characteristics of a database and about the structure of its objects.

400

This system object keeps track of the names, types and other characteristics of every object in a database.

What is the MSysObjects table?