You know that Access is great for storing large amounts of data. It also lets you format, sort, filter and print this data in multiple ways to help meet your business needs. But, you can also enter and edit new data, and the best way to do this is by entering one new record at a time in a form. A form is just a pop up window box that you design that asks for the necessary information that each new record requires. In this short tutorial, I will show you how to create a simple form to enter new records into your database.
 
 

Go to Start>Programs>Microsoft Access to open the program. Go to File>Open and find the database named “Customer Listing.” The database will open in the table view, which looks like an Excel spreadsheet. From the “Objects” menu on the left hand side of your screen, click on “Forms,” and the select the option “Create form by using wizard.”

 

Since a form is a pop up window that asks for information needed to create a new record, you will probably need all the fields’ information that you specified when you created the “Customer Roaster” database. In this step, click on the “Select all fields” button and hit Next. Now, click on the “Columnar layout” button and click Next. Following that, select “Standard” style and hit Next. Finally, click Finish and agree to the name given to the new form.

 

Now you will see your newly created Customer Roaster Form where you will be able to continue entering new records in a fast and accurate way.

 
Good Job! In three easy steps, you created a neat looking shortcut for entering new records into an Access database.

discuss this topic to forum