Tag Archives: Microsoft Office Access

MS Access 2007 help

MS Access 2007 is the version of Access that changed everything. The interface is like no previous version and takes some getting used to. Instead of the classic toolbars and menus we now have what is known as ‘The Ribbon. It is easier to now create basic forms and reports. Unfortunately there is not a [...]

Read full storyComments Off

MS Access Macro – How To Open a Report

An MS Access macro is a great tool for automating our databases. We can use Microsoft Access macro actions for many tasks. In this demonstration I am going to open a report by using a macro. The MS Access macro designer has three main columns 1. Macro Name 2. Action 3. Comment Enter the name [...]

Read full storyComments Off

Working with Microsoft Access databases

One should always use the right tool for the right job. If you want to store large volumes of data and have many users then think if Microsoft Access databases are the best way to go. Microsoft Access databases tend to be better suited to small systems with around ten or less users. For anything [...]

Read full storyComments Off

Using Microsoft Access database queries

Entering data in a database is done through tables or forms, but when we want to get our data out we should use Microsoft Access database queries. A Microsoft Access database query can produce a complete or a subset of data. You can also choose to restrict the data returned based on criteria you feed [...]

Read full storyComments Off

Microsoft Access 2007 for dummies

The world’s most popular desktop database, Microsoft Access has seen many versions. The latest is known as Office Access 2007 and is the most radical release yet. It offers a wide range of features for beginners and seasoned users alike. There are many books on the market including “Microsoft Access 2007 for dummies” which will [...]

Read full storyComments Off

Advantages of using a Microsoft Access Database

In today’s information age we are becoming less reliant on paper. When keeping records, be it household or business, it is a good idea to keep our information using some kind of computer solution. A Microsoft Access Database provides the perfect solution to our problems. There are different approaches we can take. We could look [...]

Read full storyComments Off

What is a database?

A database is a collection of information. A Microsoft Access database provides a mechanism for storing, retrieving and manipulating that information.

Read full storyComments Off

How To Add A Spellchecker To An Access Database Form

When entering data one can occasionally misspell a word or two. We are all used to having a spell checker at hand when typing a Word document for instance. Why should a spell check be limited to Word documents? Surely it would be of benefit if we could incorporate something similar in an Access database. [...]

Read full storyComments Off
access2007-database-ribbon

Access Database Versions

Over the years MS Access has not changed much in terms of it’s interface and the basic building blocks it contains. I started off using Access version 2. This was a good version in many respects, but was prone to being unstable when handling large amounts of data or users. The Jet database engine has [...]

Read full storyComments Off

Microsoft Access 2007

Microsoft Access is alive and kicking and is available in it’s latest incarnation “Access 2007″. It is unclear just how many companies have switched to it or Office 2007 in general, but I suspect the take up is slow. Personally I am not keen on Access 2007 because it seems too much of a radical [...]

Read full storyComments Off