2nd Term - Test Revision

Form 6 - Computer

2024-2025

Floor 4 - Computer Room

Mr. Peter

Outline

Outline

Exercise Demo

1

Step 01 - Create Form & Form Design

2

3

Step 02 - Record Searching

4

Step 03 - Macro and Query

5

Control Wizar Problem

Exercise Demo

Exercise Demo

Demo

Exercise Demo

Requirements

1

Table: Albums

2

Query: track greater than

3

Form: Tracks more than button

4

Form: Albums

5

Macro: tracks greater

What will be done in this exercise

Exercise Demo

Albums Form - Functions

1

Album icon & Album title

2

Field & labels font and size

3

Next record button

4

Previous record button

5

Close form button

6

Fields & Image layout

7

Background image

What will be done in Album Form

Exercise Demo

Album Search Form - Functions

1

Album searching combo box

2

Album searching button

3

Tracks more than button

4

List All Albums button

5

Background image

What will be done in Album Search

Step 01 - Create Form & Form Design

Step 01 - Create Form

Step 01 - Create Form & Form Design

Step 02 - Save Form

Step 01 - Create Form & Form Design

Step 03 - Design View

Step 01 - Create Form & Form Design

Step 04 - Ruler and Grid

Step 01 - Create Form & Form Design

Step 05 - Icon and Title

Download music.png from Google Classroom

Step 01 - Create Form & Form Design

Step 06 - Change Background

Download Background1.png from Google Classroom

Step 01 - Create Form & Form Design

Step 07 - Remove Layout

Step 01 - Create Form & Form Design

Step 08 - Change Font

Step 01 - Create Form & Form Design

Step 09 - Change Fill Color

Step 01 - Create Form & Form Design

Step 10 - Add Next & Previous Buttons

Step 01 - Create Form & Form Design

Step 11 - Change Button Style

Step 01 - Create Form & Form Design

Step 12 - Add Close Button

Step 13 - Create Blank Form

Step 02 - Record Searching

Step 02 - Record Searching

Step 14 - Save Form

Step 15 - Add Combo Box

Step 02 - Record Searching

Step 16 - Add Search Button

Step 02 - Record Searching

17 - Change Background

Step 02 - Record Searching

Download Background2.png from Google Classroom

Step 18 - Add List All Button

Step 02 - Record Searching

Step 19 - Add Query

Step 03 - Macro and Query

>[Tracks greater than]

Step 03 - Macro and Query

Step 20 - Add Macro

Step 21 - Add Macro Button

Step 03 - Macro and Query

22 - Control Wizard Problem

Control Wizar Problem

Control Wizar Problem: No popup navigation menu if a button is inserted