Creating a Database from Scratch

When none of the available databases that the wizard creates gives you what you need, you need to create a database on your own. To create a new database from scratch, follow these steps:

  1. Choose File | New.

  2. Select Blank Database from the list of options on the right-hand side of the screen.

  3. Select a drive and/or folder where you will place the database.

  4. Type a filename for the database.

  5. Click the OK button.

Access creates an empty database file. You can add the necessary tables, queries, forms, reports, data access pages, macros, and modules that comprise a functional application.


Database filenames must follow these rules:

  • Database names can contain up to 255 characters.

  • Database names can contain spaces, but you should avoid special characters such as asterisks.

  • Access assigns the extension .MDB to a databases that you create.

    Part III: Creating Your Own Database and Objects
    Part V: Advanced Topics