Creating a New Database
In generic terms, a database stores a collection of information. Access databases are composed of tables, queries, forms, reports, data access pages, macros, and modules. Each table within a database should contain information about a particular subject. You use queries to extract specific information from one or more tables. The forms, reports, and data access pages provide a means of displaying your data. Finally, macros and modules allow you to build an integrated application.Chapter 1 entitled "How Do I Get Started Developing an Access Application?" covers these initial steps. After you have a design document in place, you are ready to build the Access database. You can complete this process either using a wizard, or by building the database yourself from the ground up. The text that follows covers both of these options.
Creating a Database Using a Wizard
You can use the Database Wizard to create a new database based on a template (setting up a Customer database, for example). You can select options provided by the Wizard to make the database suit your specific needs. After you have completed the process of running the wizard, you can then modify the design of all of the objects that the wizard creates. To create a new database using a wizard, follow these steps:
Figure 2.1. To create a new database with a wizard, select On My Computer from the list of Templates.

Figure 2.2. Microsoft provides several database templates that you can use to get started.

Figure 2.3. The wizard provides you a list of suggested tables and fields.

Figure 2.4. You can select from a list of optional fields to include in your tables.

Figure 2.5. The Database Wizard creates an application switchboard.

Figure 2.6. The Database Wizard adds the necessary tables to the database.

The database the wizard creates contains a switchboard that will allow you to very easily add data to tables, view the data entered, and run reports. After the wizard is complete, it is up to you to add new objects, and to customize the existing objects to your liking.
Creating a Database from Scratch
When none of the available databases that the Wizard creates gives you what you need, you will have to create your own database. To create a new database from scratch, follow these steps:
Access creates a new blank database.Database filenames have the following rules:
- Database names can contain up to 255 characters.
- Database names can contain spaces, but avoid special characters like the asterisk, semicolons, commas, and so on.
- Access will assign the extension .MDB to the databases that you create.