AnAccess databaseconsists of one or more tables that contain related information.

However, this could become tedious and confusing.

It’s hard to follow relationships between data in tables while you’re trying to enter in data.

Screenshot of creating a new table in Access

Access input forms are a valuable tool for this.

Microsoft Access is great for small businesses.

So, for this example, you’ll create an Access database for tracking sales information.

Adding fields in Access

This database will contain information about your sales staff, monthly sales, and monthly expenses.

To build your table in Access:

Launch a new database in Access.

You’ll see a blankTable1.

Screenshot of naming fields in an Access table.

SelectClick to add, and add five fields.

Right select each field, selectRename Fieldand punch in the new field name.

Name each field Salesperson Name, Address, Phone Number, Month, Sales, and Expenses.

Adding a new Form in Access

Once you’ve renamed all the fields, you’re ready to move on to the next step.

The large number field is only available in Access 2019 or later.

Heres the step-by-step process to create your new input form:

SelectCreatein the menu, and selectForm Wizard.

Adding fields to Access Form

opt for»button to select all fields in the table.

Select theNextbutton to continue.

Choose the form layout that youd like.

Screenshot of selecting Form layout in Access

Justified is a good, attractive starting point.

Remember, this is just a starting point.

You may modify the actual form appearance later in the process.

Screenshot of finishing the Access form wizard.

Select theFinishbutton to generate your form.

Using the Form

Once youve created the form, you might interact with it as you wish.

The layout view allows you to customize the appearance of specific fields and the form itself.

Screenshot of using a Form in Access

The data-entry view allows you to interact with the form and enter data.

Try playing around with the form design.

Use your new Access input form to enter a few records into your table.

Screenshot of using an Access form.

SelectSavein the Records group in the Home menu.

Or you’re able to press tab in the last form field.

Either of these options will secure your change.

Screenshot of a completed Access table

MicrosoftAccess is a very powerful tool for tracking everything from a personal book library to your entire small business.

Forms give you much easier access to all of the data you’ve stored in your Access tables.

Using the Search field in an Access form

Switching to next record in a Form