Home » MS Access » Creating a database in Access

Creating a database in Access

Creating a database in Access

Here’s an extraction taken from one of my eBooks,

Here’s a quick overview to get you started and apply some if not all the above concepts discussed (from earlier chapters).

Creating a new database in Access

Step 1 – Start Microsoft Access and you are presented with an interface where you can choose from a number of different templates. The screen shot presented below shows a few template examples:

Creating a database in Access

If you are going to select one of the options (refer to Options), you will be taken to an interface (refer to Categories) where you’ll see the templates that are specific to that category.

Creating a database in AccessCreating a database in Access


Step 2 – You will need to give your database a name. To do that, click on file (located on the top left of the interface) and then click ‘save as’. You will then see two command options to ‘Save Database As’ or ‘Save Object As’ as shown in the image below.

Creating a database in Access

You then need to select a file type. The default file type is ‘accdb’ or you can select to save it as a database template which you can give a unique template name of your choice. Then click the ‘Save As’ icon button to save it.

Fact: Remember, the reason you are prompted to save now when creating an Access database ‘accdb’ file instead of at any point is because when you add, modify or delete records, Access automatically saves to disk and therefore requires a filename and location.


Step 3 – After saving, you can double click the newly saved database file to view it. When you open the database file you will see a security warning just like what is shown below:

Creating a database in Access

Be aware that as part of the database setup process, some macros and pre-defined code is generated for you. Click on the white rectangle where is says ‘Enable Content’ in order for the procedures to work.

This is just a head start to the creating a database in Access process!

Tags: , , ,