Access 2007 – The Navigation Pane Window View

This video tutorial is a good overview for those new to the Access 2007 screen and how objects are managed into groups and other filter views. It is a vast improvement from the previous database window (of earlier versions).

The Navigation Pane Window view contains all the Access objects stored as it is in one file. You can create, edit, open, delete, duplicate, search and maintain natural groups.

I like the quick ‘right’ mouse click on the ‘Navigation Pane‘ banner to set properties including showing and hiding system objects.

Here’s one of my shortcut tips; press the F11 function key from the keyboard to toggle the hide/show the Navigation Pane Window view instead of clicking the >> << chevron icons on the banner.

Microsoft Access Query Formulas Combining Fields, Calculation

Queries are the heart of any Access database and ms access query is typically utilised especially when wanting to calculate.
A common type of calculation is known as ‘Concatenate’ which is demonstrated here with the ‘FirstName’ and ‘LastName’ fields.
Also, this query uses the common ‘nz’ function to deal with null to zero calculations.

Note the naming conventions for fields i.e. no spaces but spaces are acceptable for aliases.

As a Thank You for Visiting!

Claim your free eBook NOW

Enjoy 🙂

Kind regards,

Ben Beitler-“Your Access Database Expert!

Microsoft Access Database 2007 tutorial

MS Access 2007 tutorialWhen Microsoft Access first appeared in the early 1990’s it revolutionized the desktop database market. Most versions have been similar to each other. Now with Access 2007 we see the most radical changes yet introduced by Microsoft. When working your way through an MS Access 2007 tutorial, a hardcore traditional user of MS Access is either going to love or hate these new changes.

So what is different about this new version? The interface is completely different and instead of menus and toolbars there is the Ribbon. The Ribbon is divided into sections and each section holds the relevant commands for designing and running a database. Continue reading “Microsoft Access Database 2007 tutorial”

How to set a Relationship in Access 2007 ?

This video from YouTube shows the basic way to set and join two tables together in the relationship window viewer tool.

This gives you a clear and simple step by step instructions on how to join two tables creating a global/permanent relationship. Access database then recongnises this setting and releases more functionality including the ability to expand and collapse related records in a table.

Planning an Access Database – Video

Learn access database,This video from YouTube takes you from the very beginning even before working with the actual database application which is often overlooked when designing and planning an Access database.

It’s a good guide to help relate how you actually would use and benefit from any database in the ‘real world’ making this a very human and user friendlier approach and best of all it’s ‘geek’ speak and jargon free!