Once this system is in place, you can automate it by using macros and modules to simplify and streamline the processes involved in entering, storing and retrieving data. The queries often form the basis for reports, which will then allow you to view the information you requested. You can the use queries to pull specific information from the tables in the database. The data is then stored into these tables, which are related to each other as necessary. In general, you use forms to enter information into tables. Once that is done, the new blank database will appear in the main Access interface.Ī database should be simple, logical, and straightforward in its design.
![microsoft access database microsoft access database](https://flyawaysimulation.com/images/downloadshots/18750-douglas-c-47-royal-air-laozip-3-laos-033.jpg)
Then click the “Create” button to create the new database file. When you are ready, click the “OK” button to close the dialog box. Use this dialog box to give the new database file a name and also select where you want to save the file. If you want to change the default folder where the database file will be stored, you can click the small folder button at the right end of the “File Name:” text box in order to launch the “File New Database” dialog box.
![microsoft access database microsoft access database](https://flyawaysimulation.com/images/downloadshots/9825-b19alabxzip-6-b1900d-800-3.jpg)
In the “Blank Database” pane that appears at the right side of the screen, you can enter a name for the database into the “File Name:” text box. In Access 2007, you can create a new blank database by simply clicking the “Blank Database” button In the “New Blank Database” section of the “Getting Started with Microsoft Access” welcome screen. Then select the “Blank database” choice in the “Available Templates” section. In Access 2010, you can create a new database by clicking the “File” tab in the Ribbon. A new database is a container that will hold all of the tables, form, reports, queries, macros, and modules that you create.