How to build a microsoft access database

What you are doing when using this type of database is recording a single piece of information, like the вЂњFirstName,вЂќ вЂњLastName,вЂќ or вЂњAddress,вЂќ about a single entity- in this example, a customer. Assume it looks like the following example.ДЇor many types of databases, the structure shown on the previous page would work well. You can then list each customerвЂ™s information in the rows underneath the columns, creating a basic table. Perhaps you could create a table in an application like Microsoft Excel where you can create columns for each piece of information that you wish to record. You may want to record customer information like the вЂњfirst name,вЂќ the вЂњlast name,вЂќ the вЂњcompany name,вЂќ and other relevant pieces of information. You would begin by listing the different attributes of the customer that you wish to record.

Information is frequently stored in large вЂflat-files.вЂ™ For example, assume that you want to create a database file that stores your companyвЂ™s customer information. 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.

How to build a microsoft access database