en uk

Creating a database from scratch Microsoft Access 2007

    Access can create a blank database or a database using one of many tem­plates available from the Microsoft Web site. No matter how you create a database, you will likely need to modify it to customize it for the type of data you want to store.

    To create a blank database, follow these steps:

    1. Click the Office Button and choose New.

    The Getting Started with Microsoft Access screen appears.

    2. Click the Blank Database icon.

    The File Name text box appears in the right corner of the screen, as shown in Figure 16-2.

    3. Type a descriptive filename for your database.

    You may want to click the Browse icon to specify a different folder or drive to store your database.

    Creating a database from scratch Microsoft Access 2007

    Figure 16-2:

    When you create a blank data­base, you can give it a descriptive filename.

    4. Click Create.

    Access displays a blank table and an Add New Field text box, as shown in Figure 16-3. Displaying your database in rows and columns is Datasheet view.

    When you create a database, Access automatically creates a special ID field to help you sort and organize your data. (You don't have to use this ID field if you don't want to.)

    Creating a database from scratch Microsoft Access 2007

    Figure 16-3:

    To design a database, you need to define all the fields used to store information in a table.


Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.