Computer & IT

note!Answer: C) Simple
The Simple Query Wizard creates a basic select query that retrieves chosen fields from tables.

note!Answer: D) Available Fields
The list of fields you can add is called the Available Fields list; double-clicking a field moves it to Selected Fields.

note!Answer: B) Query datasheet
A query's results appear in a query datasheet, which looks like a table of rows and columns.

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.