"Follow an Access tutorial to help you step through one of many different tasks available..."

Some of the procedures will show how to use Access wizards and other tools will be a manual descriptive approach so users can obtain the best of the different methods in understanding Microsoft Access and its features.

If you haven't yet built a database, then creating an Access database using the wizard tool is recommended and if necessary experiment with different template examples the wizard offers to get a feel how an Access database works.

Alternatively, you may like to see how to create an Access database using the blank database option to allow you to start from a blank canvas approach.

Note: Depending which version of Microsoft Access you are working with, different screens will appear. Examples explained in the website will vary using two versions; 2003 and 2007.

Once you have created your database, you may need to create additional tables and define their data types to compliment the existing tables already defined from the template database chosen earlier.

At some point, you will need to consider creating other objects to help manage and control how users will operate your database.

For data management purposes and controlling functionality with an Access database, it is always useful to create an Access database form and restrict its use using the various methods available including wizards.

Additionally, start by learning about Access forms to master the components which can sometimes be a better approach for a good looking screen but more time intensive!

There are many types of queries that can be created and when combined together, provide a very powerful reporting tool answering any questions raised.

Once again, you will need to start from the ground up by looking at how to build and query Access database objects which covers the basic SELECT query and describes the design environment tools available.

Access queries allow you to perform calculations using formulae and functions to create additional information creating new fields for later use in forms and reports.

If you want to change from a detailed list query to a summary data list using functions like 'Sum' and 'Average', then creating groups and totals queries to understand to the do's and don'ts when applying the correct functions.

Please review Access Queries for a complete background and understanding of the most popular and more selective advanced queries.

Now that you have understood and created Access queries, you may wish to enhance the final results into a more presentable format. This is where learning about building reports using the wizard will the best place to start as it will reduce the learning time needed to generate a report.

Alternatively, you may want to review Access reports for a detailed description and understanding of the design tool environment.

There are plenty of Access tutorial links in this page and other parts of this website.

Note: You can download the database file of your version to test the examples explained and illustrated throughout this website.

Return from Access Tutorial to About Access Databases home page