Locked lesson.
About this lesson
Creating a user form using the Form Wizard.
Exercise files
Download this lesson’s related exercise files.
7.01 creating-a-form-form-wizard - Exercise.docx43.7 KB 7.01 creating-a-form-form-wizard - Exercise solution.docx
104.3 KB TechGurusTicketing13.accdb
720 KB TechGurusTicketing13 - Complete.accdb
748 KB CountryList.txt
136 B
Quick reference
Creating a Form - Form Wizard
Use the Form Wizard to create a form so that users can interact with the database.
When to use
Create a form whenever you want users and those maintaining the database to have an easy way to view and modify information.
Instructions
Forms are how users interact with the database. They provide a user-friendly way of viewing, searching, and editing information. Forms can be created in several ways in Access. In this lesson, we will use the Form Wizard to create a form to help us maintain the list of companies.
Creating a Form using the Form Wizard
- From the Create tab, in the Forms group, select Form Wizard.
First, we need to select which fields we want to display on the form. You do not always need to display all fields so think about which fields are relevant to users.
- Select the Company field in the left-hand pane.
- Click the single chevron to move it to the Selected Fields pane.
- Click Next.
Now, we need to choose the layout of our form.
- Choose Tabular from the list.
- Click Next.
Next, we need to give our form a name. As this is a form, we are going to use the prefix, 'frm'.
- Type 'frmCompanyTabular'.
- Select Open the form to view or enter information.
- Click Finish.
Adding, Editing, and Deleting Records
Forms can be highly customized to our needs.
Deleting Records
- Select the record and press the Delete key.
- OR, from the Home tab, in the Records group, click Delete.
Editing Records
- Click in the field and start typing to modify the record.
Adding Records
- Scroll to the bottom of the table.
- Click in the blank field in the last row and add 'Discover Inc'.
Tables by default are sorted in alphabetical order but any new records you add will not be sorted. We will look at this a bit later on.
Login to downloadLesson notes are only available for subscribers.