Quackit Logo
$1.99 Domain Names
With every new non-domain purchase thru ZappyHost, you get a domain name for only $1.99.
Create free Flash websites

Microsoft Access - Create a Form

Print Version

As mentioned in the previous lesson, forms provide non-technical users the ability to add data to your database.

Here are the steps involved in creating a form in Access.

  1. Ensuring the "Forms" tab is selected, click "New".
  2. Select "Form Wizard" and click "OK". (For now, we'll use the "Form Wizard" to create a form. Once you become comfortable with creating forms, you can choose another option if you prefer).
    Create a form - step 2
  3. Select the fields that you need on your form and click "Next". In this case, we only need the user to enter first name and last name, so we choose those two fields:
    Create a form - step 3
  4. Choose which layout you'd like your form to use. Leave this at the default ("Columnar") and click "Next":
    Create a form - step 4
  5. Choose which style you'd like your form to use. Leave this at the default ("Clouds") and click "Next":
    Create a form - step 5
  6. Choose a name for your form and click "Finish":
    Create a form - step 6

Your form should now look something like this:

Create a form - Finished result

This is a very basic form and in most cases, you'd have a lot more fields on your form. You can see that the form is already presenting the first record in our Individual table.

  • To jump to the next record, click the Next record button button.
  • To jump to the last record, click the Next record button button.
  • To jump past the last record so that it's blank and ready for a new record to be entered, click the Next record button button.

Enjoy this website?

  1. Add this page to your Favorites
  2. Link to this page (copy/paste into your own website or blog):
  3. Help support Quackit by making a donation

Oh, and thank you for supporting Quackit!

Need Website Content?
Get unique, quality digital content for your website.
  • 270+ Website Templates
  • 800+ Flash Templates
  • 25,000+ Images, Logos
  • 30,000+ e-Books
  • 15,000+ Scripts
  • 27,000+ Animated GIFs
  • 21,000+ Ringtones
  • ...and much more!
Get your content now!
FREE Hosting!
With every domain you register with ZappyHost you get FREE hosting.
© Copyright 2000 - 2010 Quackit.com