It is not a secret to anyone that this microsoft program has a variety of tools and functions that allow its handling to be very simple for the users, especially when having to work with a large amount of data in the .
In the case of the are considered as tools that allow much easier to see and obtain the data or that is sought. In addition, through them you can add, edit and view data stored in the database. In the case that several users have to use the databaseit is best to have well designed forms to specify data more precisely.
Taking all this into account and the importance of forms in the use of Microsoft Access, Here we are going to explain a little more how you can start create the navigation forms in your database from scratch. Keep in mind that this procedure is very simple to carry out, to do so, follow in detail everything that we will teach you next in the post.
What is a navigation form and what is it used for in a database?
A scan form or also known as navigation form in access is considered as an object that allows create a user interface for an application Database. The same can be dependent or independent, the dependent forms are those that are directly connected to a data origin as is one or a query and that are used to specify, edit, or display the data from that data source.
In the case of independent forms not directly linked to a data originbut contain command buttons, labels and other controls necessary for running the application. They are used mostly for control access to data.
It should also be mentioned that navigation forms are those that contain navigation controlThis means that these forms they can arrive to be incorporated into any desktop database. However, so that you can understand all this a little more, here we are going to show you how you can start creating these forms from scratch in your Access database, To do this, simply follow everything that will be taught below in detail.
Learn step by step how to create and use a navigation form in an Access database
Knowing that are the navigation or exploration forms in an Access database, the next thing will be to teach you how to create and use them in each of your databases.
For this, it is necessary that you follow in detail each of the processes that we will teach you below:
Create navigation form
The first thing will be create the navigation form with whom you will work the database, This procedure is very simple and quick to achieve.
To do this, follow each of these steps:
- To start you must open the database to which you want to add a navigation form.
- Now in the tab “To create” and in the section “Forms” you must select the option “Navigation” and there you choose the type of navigation you want to use.
- Once you have chosen some of the options that appear there, Access will create the form, add the navigation control to it and teaches it in the presentation view.
Add forms or reports
once created the formulathe following will be add a new one.
To do this, simply follow each of these steps:
- In the event that not show the navigation panel on the screenyou will need to press the F11 key on your keyboard.
- Here you must make sure that the navigation form is open in the presentation view. So that you can verify this you must click with the right mouse button on navigation pane and then select the option “View Presentation”.
- For add a new form you will need to drag the report of the navigation pane to the button “Add new”.
- Automatically Access will create the navigation button and will teach it in the form or object panel.
Modify form label
By default every time what is created is a Access navigation form finish by adding the tag “Navigation form” which will appear in the form header.
To be able to modify this label you need to perform these steps:
- The first thing will be to open the form in the presentation view by right clicking with the mouse on navigation pane and there you choose the option “View Presentation”.
- Now click the form header tag so that you can select it, and click again so that the cursor is over the label and you can change it.
- Here you must execute the label modification as you wish and then press the key “Enter” on your keyboard for the changes to take effect.
set as default
Taking into account that the navigation form is used as control panel or home page in a database, best for everyone would be for this to be displayed by default every time it starts the microsoft program as this will prevent the user from having to create it manually.
It should also be mentioned that panel access navigation cannot be used as a explorerso specifying a submission form default website It is a very important step when wanting create one web database.
According to all this, you just have to follow these steps so that you can set the navigation form as the default presentation form:
- To start this procedure, you need to go to the tab “File, Archive” and in the section “Aid” you must click on the “Options”.
- Now select the option “Current databases”.
- To be able to set the default form so that it appears automatically once it starts Access, it will be necessary to access “Application Options” and there you choose the option “Show form” in this way it will be appearing by default in the program.
Facebook Comments
Disqus