Access Lessons 4-9

Helps you create controls such as command buttons, list boxes, combo boxes, and option groups.

• Unbound Control
• Control Layouts
• Stacked Layout
• Control Wizard

A marker that a value does not exist for a field and is differentiated from a value that has been missed being entered by a user.

• Control
• Tabular Layout
• Null Value
• Unbound Control

The tables or queries from which a query gets its data.

• Record Source
• Select Query
• Unbound Control
• Bound Control

A control that displays the result of a calculation, or expression.

• Tabular Layout
• Calculated Control
• Unbound Control
• Parameter Query

A layout in which the controls are arranged in rows and columns like a spreadsheet, with labels across the top.

• Tabular Layout
• Stacked Layout
• Controls Layout
• Parameter Query

Changes the appearance of a control or the value in a control when certain conditions are met.

• Control Layouts
• Control Wizard
• Conditional Formatting
• Unbound Control

Uses a field in a table or query as the data source.

• Control Layouts
• Unbound Control
• Bound Control
• Record Source

A control that displays information such as lines, shapes, or pictures; it is not bound to a field.

• Unbound Control
• Control
• Calculated Control
• Bound Control

A field that uses an aggregate function to calculate data.

• Grouping Field
• Print Preview
• Aggregate Function
• Aggregate Field

A wizard that performs the normalization process by examining a table design and suggesting a way to divide the table for maximum efficiency.

• Label Wizard
• Table Analyzer
• Aggregate Field
• ^{Navigation Form}