Step One - Creating a Database

Once Access is up and running you need to tell it whether you are opening an existing Database or creating a new one. In this example we are creating a new one so on the task pane click as per the example below click Blank Database: (if the task pane is not open click FILE>>NEW)

Selecting Blank Database will create a new database in the location that you specify and proceed to the Access main window.

Selecting Open an Existing Database allow you to open a database that has been already created. The bottom part of the window will list the most recent databases that have been used. To open one, double click the file name or click the file name once and click the OK button. If the file is not in the list, double click "More Files . . ." and the Open dialog window will open allowing you to switch to appropriate drive and directory where the database is stored.

We are going to select Blank Database and click the OK button.

The Open dialog window appears:

We are going to create this on the d: drive.

  1. In the Save in: box, click the down arrow and select the entry where the line ends in "(D:)".
  2. For the File Name box, highlight the entry (db1.mdb) and type in "market".
    (you can leave the .mdb extension off and Access will add it for you automatically)
  3. Click the OK button.

The database has now been created in the D: drive. The main window for Access should now be showing.


Tip: Even though you have not done anything with your database yet, a new file has been created. This means if you decided that you did not want to continue with this database, you should go in to the Windows Explorer and delete the market.mdb file.

 

[Back]

[Home]

[Forward]

edited by U.A.C Media