Database: Access: Creating a new database

Before starting, you should have a good idea of what you want in each table.
  1. Create database. After starting MS Access, you will get a dialog box. Select the top radio button ("Blank Access database"), and click OK (or Cancel and select File > New). Microsoft Access databases have a .mdb extension. Choose a name for it and save it somewhere you can get it later.
  2. Create table. You will then see a Database Window like the following:

    Because we're only going to deal with SQL, the only two elements along the left side that you need to use are Tables and Queries. For the purposes of these notes you can ignore Forms, Reports, Pages, Macros, Modules, Groups, and Favorites.

    You will come back to the Database Window continually, since the new tables (queries, ...) that you create will be listed here.
  3. Use design view. Click on "Create Table in Design View". Design View is used to create the fields that we'll have in a table. Data View will be used later to enter data into the table.
  4. Define fields. The design view that comes up has three columns. Fill them in.
  5. Indicate primary key. Choose a primary key by right clicking the field or selecting the field and clicking the key on the toolbar.
  6. Save the design view. Save the table and give it a good name (plural noun is good). Close the design view window, and you'll be back at the dialog above, but one important difference - your new table will be listed in the right pane.
  7. Data view. In the Database Window double click the table name that you just created, or right click it and select Open. This data view will let you enter data for each of the fields. You can easily switch between design and data view with the leftmost toolbar icon.