18 min read
Creating a Form with the Form Wizard
The one-click Form button builds a usable form instantly; the Form Wizard gives more control over which fields, layout, and title it uses.
You will learn: Form Wizard and Create → Form. You will do: build MembersForm with the wizard. add a City combo box.
Form Wizard on Members
Goal
Build MembersForm with the Form Wizard.
The wizard picks fields step by step.
Open the database file
Do this
Verification
Check your work
You are correct if all of these are true:
- Record 1 of 5 at the bottom. Each arrow shows another Members row.
Record 1 of 6 · This screen writes into the Members table.
Alternative: Create → Form
Goal
Build a form in one click.
Same result when you want every field.
Select Members
Where
Do this
Verification
Check your work
You are correct if all of these are true:
- Columnar form with MemberID, FullName, City, Phone.
If something looks wrong
Fix
Combo Box for City
Goal
Let staff pick a city from a list.
The value still saves to Members.City.
Open form in layout mode
Do this
Verification
Check your work
You are correct if all of these are true:
- Drop-down lists London, Manchester, Bristol, Leeds. Pick Leeds — Members.City stores Leeds.
Record 1 of 6 · This screen writes into the Members table.
Add a Member
Goal
Add a new member on the form.
AutoNumber assigns the next MemberID.
Start a new record
Where
Do this
Verification
Check your work
You are correct if all of these are true:
- New row appears with the next MemberID.
Practice
Swipe or use the arrows to move between questions.
1 / 2
Field Notes: Two Speeds
Goal
Build a form using the Form Wizard, for more control than the one-click Form button.
The wizard lets you choose exactly which fields to include, in what order, and which layout to use.
Start the wizard
Do this
More lessons in Microsoft Access · Next: Designing a Form in Design View and Layout View · Previous: What Is a Form, and Why Use One?