"The quickest way of building a database is by using the 'create database wizard' feature installing the key components for you..."
The quickest way to create an Access database is to use the database wizard and/or template tools available which are a breeze! But you need to have some idea of what type of database you are going to end up with by planning your database first.
To help with this preliminary step, take a look at
how to prepare and design an Access database
to understand the scope and key objectives before building the new database which follows on from here.
Creating a database process is covered illustrating two versions of Access (2003 and 2007).
Click here to review Access 2007 process
Creating a new database using version 2003 (or earlier)
Step 1: Start Microsoft Access and you will see a 'Getting Started' window pane (located to the right hand side of the screen) and then either click 'Create a new file...' hyperlink provided or from the keyboard choose CTRL+N.
Step 2: The window pane switches to 'New File' view where you can choose from one of several hyperlink options. We are interested in the templates category and can view either online or offline (On my computer) templates. Choose 'On my computer'.
Alternatively, you may want to review
creating Access database using the blank database option
to allow you to start from a blank canvas approach.
Step 3: You will now see a screen with two tabs. Choose the 'Databases' tab where the database wizard icons appear for each type of process available. Choose your desired template, I'm going for 'Inventory Control' and click OK.
Step 4: The next step requires you to name the database and location which is in effect 'Save As'. Rename the file (make sure it includes '.mdb' file extension if visible) and click 'Create'.
Fact: The reason you are prompted to save now when creating an Access database 'mdb' 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 5: Follow the six screens which step you through the Access database wizard creation process. You will be asked for table and field choices, choosing form and report style layouts and give a title for your new database.
The final screen will require you to click 'Finish' for the system to build the database for you. (This will take a few minutes to complete).
You will see a progress bar building the objects for your chosen database and in my example be prompted to enter company information like name and address details for various reports.
Complete all the prompts where necessary and the final screen will be the 'Main Switchboard' where the system is ready for data processing by following the navigation buttons provided.
Congratulations! The database is now ready to use and the system has generated over twenty different objects across Tables, Forms and Reports setting the best properties and data types for the process. You can still modify any existing object or add new objects via the Database Window.
This is just a head start to creating access database process!
Back to Top
Creating a new database using version 2007 (and later versions)
Step 1: Start Microsoft Access and you are presented with a starting screen interface. On the left hand side, you have a 'Template Categories' pane which divides up the many templates available.
As you choose a category, from the main area (the middle section), pick the template of your choice. In my example, I've opted for the 'Education' category and chosen 'Student Database' template.
Step 2: You will need to give your database a name which is carried out in the right hand side Window pane. Rename the file (make sure it includes '.accdb' file extension if visible) and click the 'Download' button.
Fact: 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: The download process will take a few seconds and then two things happen as the database wizard does its job. A 'Getting Started with Students' form opens up with some leading links about the selected template. The other is an additional Access help file pops up for more assistance.
Read the additional help screen and then close it leaving you with the welcome window.
Step 4: After closing the welcome screen, you are actually done and have access to any of the objects from the Navigation pane (normally located on the left hand side of the screen). In my example 'Student' database, it generated 6 Tables, 5 Queries, 8 Forms, 11 Reports, 3 Macros and a Module.
Double-click on the first table and the datasheet view (looks like a grid worksheet) is ready for data entry.
Step 5 (optional): Be aware that as part of the database setup process, some macros and pre-defined code is generated for you and in order for the procedures to work, you may need to enable the security warning module depending on where your database file (accdb file) was stored.
Make sure you enable the code by clicking on the 'Options...' button from the security warning banner (just below the Ribbon Bar if visible). Change to the option 'Enable this content' and click OK button.
Back to Top
Congratulations! You are ready to go and take the development process to the next level.
Creating Access using the database wizard and template options couldn't be easier and will give a huge step up onto the first ladder of developing an Access database.
Return from Database Wizard to Tutorials page
Return from Database Wizard to About Access Databases home page