note!Answer: C) Column
Rearranging columns in a query datasheet changes only the display order, not the underlying table's field order.
note!Answer: C) fields from the selected table
In the Subform Wizard you choose the source table or query and then the fields to include in the subform.
note!Answer: B) Form Content
Form Design sections are Form Header, Form Detail, and Form Footer; 'Form Content' is not a section.
note!Answer: C) Label
Selecting a Label control also selects its attached text box, so they move together as one unit.
note!Answer: C) Form Design
Form Design view is used to create and modify a form's structure and controls.
note!Answer: D) Open Exclusive
Opening the database in Exclusive mode from the Open dialog allows you to set a password.
note!Answer: D) Click on the three dots to the right of the Input Mask entry field
The Input Mask Wizard is opened by clicking the three-dot builder button beside the Input Mask property.
note!Answer: D) MDB
Access 2003 databases use the .mdb extension.
note!Answer: C) A report that displays data grouped by fields you specify
A grouped report organises records into groups based on the field values you choose.
note!Answer: D) Sub-schema
A sub-schema is the user or application view of the database, a subset of the full schema.
note!Answer: C) Enter a date before 1995
The validation rule <#1/1/95# means the date must be earlier than 1 January 1995.
note!Answer: B) Object Browser
The Object Browser in the VB Editor lists the objects and members of type libraries.
note!Answer: B) DDL
Data Definition Language (DDL) is used to define the data structure for the DBMS.
note!Answer: B) Workbooks
Access objects are tables, queries, forms, reports, pages, macros and modules; workbooks belong to Excel.
note!Answer: C) Master file
A master file holds relatively permanent data, while a transaction file holds changing data.
note!Answer: B) Scheme
The schema is the complete logical description of all data stored in the database.
note!Answer: A) Record
A record is a collection of related data items grouped together for storage.
note!Answer: B) Set theory
The relational database model is based on set theory and relations.
note!Answer: B) Tuple
In relational theory, a row (record) of a table is called a tuple.
note!Answer: D) All of above
Access allows importing tables, queries, forms and other objects from other databases.