Chapter 7: Microsoft Access Forms and Reports

Definition: A window that consists of visual components (controls) used to interact with the database through a Graphical User Interface (GUI).

Uses:

• Add, Modify, and Delete data in the database.
• Retrieve, View, and Search for data.

Advantages:

• Easier to Use: Simple graphical components simplify data manipulation.
• User-Friendly: Users can interact by clicking components.
• No Technical Knowledge Required: Users don't need to know SQL.
• Time Saving: Faster data entry (e.g., Master-Detail forms).
• Flexibility: Various styles and layouts available.

Columnar Form: Displays one record at a time. Fields are arranged in columns with labels.

Tabular Form: Displays multiple records at a time in a table format. Rows represent records, columns represent fields.

Datasheet Form: Displays multiple records in Datasheet View (grid like a spreadsheet).

Justified Form: Displays one record at a time with fields justified to fit the window width.

1. Open Database and click Forms button.
2. Double click "Create form by using wizard".
3. Select Table/Query and fields to include.
4. Select Layout (Columnar, Tabular, etc.).
5. Select Style.
6. Enter Title and click Finish.

Allows custom design using Toolbox controls.

1. Click New button on Forms tab.
2. Select Design View.
3. Use Toolbox (View > Toolbox) to add controls like Textbox, Label, Buttons.
4. Drag fields from Field List to the form.

List Box: Displays a scrollable list of items allowing selection of one or more items.

Combo Box: Combination of Textbox and Dropdown list. Occupies less space than List Box. Allows single selection.

Checkbox: Used for Yes/No options. Allows multiple selections from a group.

Radio Button (Option Button): Used for Yes/No options. Allows only single selection from a group.

Command Button: Executes commands (Action queries, Macros, VBA procedures) when clicked.

Definition: A form placed inside another form (Main Form). Typically used to display data from tables with One-to-Many relationships (e.g., Customer [Main] -> Orders [Subform]).

Creation Methods:

• Form Wizard: Create both Main and Subform simultaneously.
• Subform Wizard: Add subform to existing main form.
• Drag-and-Drop: Drag one form onto another in Design View.

Formatting applied based on specific conditions (e.g., Value > 50 turns red).
Use Format > Conditional Formatting menu.

Definition: Output of database application used to display data in a formatted style for printing.

Difference from Forms:

• Forms: Input/Edit data, screen-based.
• Reports: Display/Print data, read-only (statci).

Types:

• Columnar: Field values in a long column.
• Tabular: Fields in rows under column headers.

• AutoReport: Quickly creates a simple columnar or tabular report.
• Report Wizard: Step-by-step guide to select fields, grouping, sorting, and style.
• Design View: Full control over report layout using controls and sections (Header, Detail, Footer).

Definition: A form used to navigate the database application. Contains buttons to open forms, reports, or exit.

Switchboard Manager: Tool to create and modify switchboard pages and items (View > Database Utilities > Switchboard Manager).