Why Use Microsoft Access Database Forms

Microsoft Access forms allows data to be presented, managed and controlled in a user-friendly environment making your database system more intuitive to use.

Designing Access forms is critical especially for other users who will be responsible for the day-to-day running of a database and who have very little knowledge of the structure of an Access database or any of its background processes.

This type of object is deemed Continue reading

Posted in Forms, MS Access | Tagged , , , | Leave a comment

Using Pivot Tables to View Data in Access 2007

A good overview and introduction to using Access database pivot tables. This video tutorial gives you enough to get you going and experiment with the flexible options of a pivot table and is clearly explained - hence the 10 minute video.

The key thing to remember is that you need to think about the grouping and analysis of the data required for this type of report which probably means a query and not a table in which your pivot table will be based.

Using the RDBMS (see my eBook offers for more help) is ever more present and important here too to help collate the correct field arrangement.

Finally, users tend to lean towards using Excel pivot tables (because they are used to it)  but Access is generally much better!

Posted in Database Theory, MS Access, Queries, Tables | Tagged , , , , | 1 Comment

Access Database – Top Value Query

Using Access database queries really control the reporting aspects of your data; asking those questions. It is the heart of any well designed database system.

There are many types of queries and one in particular can serve you well especially if you are wanting to create a league table, prioritise records or suppress the ‘lesser’ recordset.

If you want to create for example a top 10 league table using a Top Value query is the way forward.

Using a simple query and sorting by a key field Continue reading

Posted in MS Access, Queries, Reports | Tagged , , , , | Leave a comment

Using Access 2010 – 5 Quick Tips

Whether you are a newbie or seasoned Access database user, it’s always useful to know some quick tips to help navigate and control the application’s environment.

Here are 5 quick tips to using Microsoft Access 2010 (some are exclusive to this version!):

1. The Ribbon Bar

This is great for the new user but for those who have migrated like myself became a little dissorientated. Two little tips here; Get to know the Ribbon Bar it is reasonably well organised and in most cases logically placed and to help you along the way, you can always download a great little Flash application (Click to download Interactive Command Reference tool for Access) which is free.

The other tip is Continue reading

Posted in Forms, MS Access, Queries, Reports, Utilities | Tagged , , , | Leave a comment

Access 2007 Demo: Use the Expression Builder

An excellent video tutorial on how to use the Access database Expression Builder tool. It clearly explains the features of this powerful and useful tool making good use of the terminology with ‘jargon’ free explanations.

This tool can be used in a query, form, report, macro and to a lesser extent tables too and applies to all versions of Microsoft Access (as far back as you really need to go!).

Here’s a tip to bear in mind (especially when using this tool for a query). Before utilising the expression builder tool in a query, first save the query as it will not show all the fields for an unnamed query object limiting the flexibility of this tool.

In Access 2010, this tool has been updated and has a different look and feel to it but essentially can be used in the same way.

Posted in Forms, Macros, MS Access, Queries, Reports, Tables, Utilities | Tagged , , , , | Leave a comment

Microsoft Access Database Design – Step 3 of 7

The next step is the Data Design Field for Your Microsoft Access Database.

From your reports, break down into natural units that will be the foundation for your Access database design. In simplified terms, an orders database system might consist of many tables but a core process like an order transaction could be made up from five tables (as described further in this article).

The Data Design (your fields) should start to get a little easier to complete this task providing you have spent enough time on the previous two steps of this series. This step handles Continue reading

Posted in Database Theory, MS Access, Tables, Utilities | Tagged , , , , | Leave a comment

Parameters in queries and reports Access 2007

A quick and easy to follow video tutorial example of how to create a parameter query which reduces the number of stored (repetitive) queries in your database.

A parameter prompts you for a value and passes it into your query during the run-time (execution) of the query which makes it a more flexible query as it is now a variable value which is passed and not a fixed value within the design of the query (SQL statement).

This can then serve your forms and reports which in turn triggers the prompt. You can have more than one parameter too to make extra flexible and it applies to all versions of Microsoft Access (not just 2007)!

Posted in MS Access, Queries | Tagged , , , , | Leave a comment

Multi-Table Queries in Access 2007

Access 2007 enables you to create multi-table queries that can help you make sense of information you have stored in related tables in your database. When you create a multi-table query, you can join together related information that resides in different tables and make queries that produce efficient, logical and useful results. Ultimately, you can use your multi-table queries to create multi-table reports in Access 2007.

To create a multi-table query Continue reading

Posted in Database Theory, MS Access, Queries, Tables | Tagged , , , , | Leave a comment

Microsoft Access Database Design Concept – Step 2 of 7

This is the most important step and is the process I refer to as Reverse Engineering!

The best way to build the Access database architecture correctly is start with the end result The Reports! by sketching out what reports you want to end up with. After all, database systems are there to serve and we want information please!

As an exercise, if you were migrating from a paper based system or an older database system Continue reading

Posted in Database Theory, MS Access, Utilities | Tagged , , , , | Leave a comment

Introducing the Microsoft Access 2010 Hybrid Application

This is a longer than normal video tutorial that I typically post on my blog but this is an important introduction for developers (and end-users too of course!) who are considering building an Access database for deployment over the internet as well as managed via the native application objects of Microsoft Access.

You will need SharePoint Services 2010 or an Access hosting service to handle ‘live’ web application’s objects and with Access 2010, simple tools to help check, manage and publish to the web.

Be patient, stick to the full video demonstration and get a feel for the true power of Microsoft Access 2010.

At the end of the day, you still need to know the objects of ‘native’ Access and the main objects which will mean learning about the Tables, Queries, Forms, Reports and RDBMS (Relational Database Management System).

Perhaps my eBooks would be a good start?

Posted in Database Theory, Forms, MS Access, Queries, Reports, Tables, Utilities, Web | Tagged , , , , | Leave a comment