However, it may be easier to understand the relational model of data storage by contrasting it with another method of storage that you may be more familiar with: the ‘flat-file’ method. So what does the term relational mean, and how is this important? The term relational describes the method used for storing data within the database tables. This is the main reason that you use databases: to enter, store, and retrieve data.Īccess is a relational database application. 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. 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. 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.
0 kommentar(er)
