How to Create a Multi-Page Form Based in Microsoft Access Database

Being one of the most influential components of the MS Office suite of applications, MS Access, or Microsoft Access, is being used for a variety of purposes. It is often used to create simple database solutions. The simple tasks can be performed through macros having point and click options. When it was first developed, its original use was to be able to access data from any source through exporting and importing data to many formats including Outlook, Excel, dBase, Paradox, Oracle, SQL Server etc. Apart from this, it also had the ability to view data from its existing location and using it for viewing, editing, querying, and reporting. This allowed for change in the existing data and for the Access database to use the latest data always.

However, its applications are now much more beyond exporting and linking of data. It has become a very powerful, famous and user friendly application that has gained importance throughout the world, for the various uses it now offers to businesses and individuals alike. One of the best features of Microsoft Access is the ability to create a user friendly yet highly detailed data entry forms. With the help of the application, experienced users can create data entry forms of multiple pages. Workers can use these forms to enter queries, reports and data that present the form in an actionable and usable format.

Instructions to create a Multiple page form based in Microsoft Access Database.

Below are the instructions that are used for this purpose.

Step 1: When you log on to your computer, click on ‘start’ to access and open Microsoft Access. After that, open the required database that needs to be worked on.

Step 2: On the left hand side of the screen, click on the tab that says ‘Forms’. From the menu, choose ‘Design view’. A new form will then be opened.

Step 3: On the Access toolbar, click on the icon ‘Toolbox’. It appears like a crossed hammer and wrench. Wait for it to be opened.

Step 4: On the Toolbox, click the icon that says ‘Tab Control’. This icon resembles a file folder. After clicking on it, a small box would appear on the screen. To size the box, drag the cursor and click the mouse. The box can then be seen on the screen.

Step 5: To go to that page, click on one of the pages. After that, drag the particular fields you want to include in that page. The fields can be arranged according to your liking. Once you are through, click on page 2 and follow the same process of dragging the fields that you want to include in that page.

Step 6: To save the form, click on ‘Save’. A descriptive name needs to be given to the form. In the ‘Forms’ tab, open the new form by double clicking on it.

Creation of multiple page forms has become one of the major uses of the MS application, and is being used across industries.

Leave a Reply

Your email address will not be published. Required fields are marked *