Here’s a brief history of Microsoft Access

Here’s a brief history of Microsoft Access just in case you wish to step back and reminisce

A brief history of Microsoft Access

Late 1992, Microsoft released the first version of Access (version 1.0) desktop database application for the Windows operating system and was shortly replaced with version 1.1 in mid 1993 to incorporate better compatibility with other Microsoft Office products of that time and more importantly introduce the ability for programmers to code this application using Access BASIC.

Version 1.1 was buggy! and had performance issues and in the same year Microsoft released Windows 3.1 operating system along with Microsoft Office 4.3 Pro (suite of applications including Excel, Word, PowerPoint with Access – version 2.0) as it required the improved hardware, software memory and the power supported by Windows 3.1.

This was an ideal desktop database application tailored to the small to medium sized business that required a low cost database. At that time, the capacity of a disk hardrive was less than 100 MB (mega bytes) and typical document file sizes were in the 100’s of bytes. Continue reading “Here’s a brief history of Microsoft Access”

‪Microsoft Access 2010 – How to Create a Navigation Form‬

This video is a good advert that shows some of the new features – adding a navigation form with tabs that allows you to move between other forms replacing the conventional menu manager tool from previous versions.

It also gives you a quick overview of how sleek looking this version is compared to earlier versions (not so much Access 2007 but earlier) and how interactive the Ribbon Bar is to the selected item (object) with dynamic previews when formatting the components.

New users to Microsoft Access will find this a pleasing application to work with but be warned the learning curve is a little steep at first but with determination and persistence, you will be able to master this application much quicker than perhaps its predecessors.

By the way! You can always engage in a training session (or two) with me to learn Microsoft Access in quick time.

Structuring Queries In Access 2007

People prefer to keep complex data sets in databases rather than in flat files because data can be found and grouped more precisely when it is stored in a database. The ability to draw data out of a database depends upon the ability to structure queries, or requests that define specific records. Structuring queries in Access 2007 is relatively easy because Access is designed to handle many different types of operators.

An operator is a special symbol or reserved word that triggers the database to act in a certain way. Access 2007 recognises several types of operators, including comparison operators, arithmetic operators, logical operators and special expressions such as like, between..and, in, and is null. You may also use combinations of these types of operators when structuring queries in Access 2007.

Comparison operators ask Access 2007 to perform a comparison between two values. In a query, a comparison operator can locate all records where a field value is greater than, less than, equal to, not equal to, greater than or equal to, or less than or equal to a specified value. Comparison operators can be applied to all fields that contain a literal value. A literal value is a value that has been directly entered into the field. Access recognizes four literals: text, numbers, dates and times, and constants.

Continue reading “Structuring Queries In Access 2007”

Microsoft Access Databases – Learning the Fundamentals

The Access database application provides a rich set of powerful tools ranging from a simple database design model to the multi-user network version using Access’s administrative tools at all levels which include the Relationship Window, Database Splitter, Linked Manager Tool and Access Security module to name but a few.

If you have wondered where you start to learn about Microsoft Access the quickest and simplest way, then welcome as I will step you through and guide you to learning Access the easy way!

Access beginners sometimes find this application overwhelming as there are a lot of objects and components to an Access Database. I am going to start by de-mystifying some of these objects and introduce you to Access Terminology first and foremost.

Getting to grips with some of the Access terminology will serve as a useful glossary for learning and mastering this application and any supporting resources you may use.

Continue reading “Microsoft Access Databases – Learning the Fundamentals”

Access 2007 – The Navigation Pane Window View

https://www.youtube.com/watch?v=7GRii_sTa6M&feature=youtu.be

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 this 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.

Microsoft Access 2007 New Look Tutorial

When 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.

Creating forms has become easier and there are some new forms to choose from. One example is the split form. The database window has also been replaced with the navigation pane. This offers more features and is not as easy to use as the old database window.

As part of the MS Access 2007 tutorial you should expect to learn about trusted locations. When loading a database you will get a warning that it may not be trusted. You can eliminate this warning by assigning a folder to become trusted. If you store your database in that folder then the warning will no longer show.

Creating tables has also become easier. When creating tables as part of your MS Access 2007 tutorial course, you may use one of the easy creation methods, such as creating columns in datasheet run mode. However, it is better to look at using the design view to create tables as this will give you a better understanding of columns and data types.

The built in wizards will only get you so far. They are great starting points, but if you want to become a master then it is better to try and create the database components manually. By doing this you will learn the intricacies of why things are done. For example, there are reasons why you need to save the ID of a drop down list of data rather than the data itself.

Hunting around the internet for bits and pieces to help you learn is not the way to go. There has to be some structure to the learning and it is better to start from the ground up. There is little point in trying to run before you can walk.

When looking for a good MS Access 2007 tutorial, make sure it covers all you want to learn and you gain a good all round understanding of the important concepts and components to creating a working database.

Let’s recap what we’ve learned in this article:

Access 2007 has a new look interface
There are new form types available
Learning Access 2007 should be done from a structured tutorial series

To get started with an MS Access 2007 tutorial , check out the best Microsoft Access training available at http://access-databases.com/ms-access-tutorial/

Article Source: http://EzineArticles.com/?expert=Paul_Roger_Barnett

This article gives a clear and concise overview of what’s new in Access 2007 and how the newer and richer features makes it very easy to create tables, queries, forms and reports with simple click and go actions using the predefined templates. Those migrating from earlier versions may feel a little dis-orientated at first especailly the Ribbon Bar but it won’t take that long to familarise yourself with this version.

Remember, always have a clear plan when designing a database before creating the objects using the templates.

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 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

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!