Building Modified Forms   «Prev  Next»

Creating Access Form - Exercise

Course Project: Practice creating a form from scratch

Objective: Get practice choosing a record source and creating a form.

Exercise scoring

You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background | Overview

Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business. For one of your large clients, you need to create an easy way for the client to find transaction records.

Download files

As we stated in the first module, the database_course_project.mdb database is included in the compressed download file available on the Resources page. If you've already downloaded the database, continue to work in that version.


  1. Click the Forms button in the Database window toolbar.
  2. Click New.
  3. Pick a record source from the list of tables and queries.
  4. Click OK.


You will be placed in a form called “Form1” in Design mode. Note that if you already have a Form1 in the database, Access sequentially names the form, for example, Form2, Form3, and so on.