Access Database Systems

WelcomeBlog

Are your business objectives being met?

Do you need specialised Access database consulting or an Access database solution? Our software is dedicated to providing assistance toward increasing efficiency and productivity of the small or medium sized business.

If you do not have the resources or time to develop software for your business, you may find something of interest here.

Posts Tagged ‘Microsoft Access 2007’

Microsoft Access course

Monday, February 8th, 2010

There was a time when Microsoft provided book type manuals with their software. This is no longer the case and we really have to hunt around for the information we need or attend some kind of Microsoft Access course.

Of course there is the online help, but this may not be suitable for everybody. We learn and retain information if different ways. I personally prefer to have a book that I can refer to wherever I am.

The alternative is to attend a Microsoft Access course, but this could involve travel and may not always fit into everyone’s schedule.

Fortunately there is an answer in the form of the Microsoft Access Power Mastery course.

Microsoft Access course

This course is available on this website and you can either watch the tutorials online or on a pc playable DVD.

The course is very comprehensive and many students have given great feedback about it.

It is now in its second version and even better than before. You get a ton of Access 2007 tutorials in the form of videos and cheat sheets to take you from beginner to power master.

It’s like having a teacher there with you guiding you each step of the way. Learn at your own pace – skip, pause, rewind, replay any part of the tutorials.

So skip the online information hunt and take charge of your future now.

Give yourself a head start and get on board this Microsoft Access course.

Tags: , , ,
Posted in Microsoft Access course | No Comments »

MS Access 2007 help

Saturday, February 6th, 2010

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 lot of MS Access 2007 help available at this stage and it is important to get the correct training as soon as possible.

How much MS Access 2007 help needed will vary from person to person. Some need more training than others. We all learn differently and there are aspects of MS Access which are complicated.

Take for example database relationships – these are the backbone of any good MS Access database and it is useful to have a good understanding.

On this site I have created a great MS Access 2007 help product. Students have got great value from it and now it is available online or on DVD.

Tags: , , , ,
Posted in Microsoft Access 2007, Microsoft Access General Stuff, Microsoft Access How To | 3 Comments »

Microsoft Access 2007 for dummies

Sunday, January 3rd, 2010

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 aid understanding of this powerful database software.

Some may take offence at being referred to as a dummy however and may seek out alternative means to learn. I believe this is a wrong attitude to take. It’s just a title after all and a catchy one at that.

Although MS Access is easy enough for beginners to start creating databases, there is more to consider if you want to build powerful systems. Sometimes a simple form is not going to cut it and you may soon find you want to add more features. How will a book help? It will present database theory and will certainly aid understanding, but is no substitute to having a tutor talking to and guiding you.

I have to admit to using dummies books myself in the past and have found them to be very informative. I recall starting off with both the MS Dos and Windows dummies books and learning a great deal this way. The books are fun to read and make the subject entertaining.

Lets face it, many of us dread having to learn new things as we get older and technology for some proves difficult. I have not used Microsoft Access 2007 for dummies, but if it is as good as other books in the series then it will certainly benefit the reader.

We always learn by doing. Sure it is possible to read endless text on a subject, but it all comes down to taking action and putting into practice what we have learnt. Mistakes will be made, but that is always a big part of the learning process. An Access database is no different to any other subject. It takes time and effort to build good systems.

The best way to learn is to pick a tutor that breaks the subject down into its easiest format. It should start at the begininng and should not overwhelm the pupil with computer jargon and theory. Whether you use a course or a book, seeing your Access database results take shape can be a pleasure in itself.

Tags: , , ,
Posted in Microsoft Access 2007 | No Comments »

Discovering the Microsoft Office Access database

Sunday, January 3rd, 2010

Microsoft Office has been around for many years and includes at its core Access, Word, Excel, PowerPoint and Outlook. Microsoft Office is the world’s most popular office suite and is used on millions of PC desktops.

The application used for storing and retrieving large volumes of data is the Microsoft Office Access database. Previously it was called Access, but this changed with Access 2007 and it now has the name ‘Office Access’. There are good alternatives on the market now, but Microsoft Office Access is still the leader.

The great thing about applications in the MS Office suite is that they can all talk to each other and this is no different with the Microsoft Office Access database. You may find you want to transfer records from your Microsoft Office Access database into Microsoft Excel. Because these packages can communicate this task is easily achievable.

You may also find you want to create mailing labels in Microsoft Word for example. You could use the Microsoft Office Access database to transfer its records into MS Word which would then use them to merge into mailing labels.

Some considerable changes have been made to the Microsoft Office Access database. It now has a new look interface for instance. Also the ability to set up users and groups is no longer there. Security is now mainly done via a password.

Creating forms in the new Microsoft Office Access database has become easier and there are now different form options. One example is the split form.

The Microsoft Office Access database is a great addition to the MS Office suite and delivers on both power and user friendliness.

Tags: , ,
Posted in Microsoft Access 2007 | 1 Comment »

Microsoft Access 2007

Tuesday, December 9th, 2008

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 change from what we have been used to in the past. No doubt the introduction of the ribbon type toolbar is the way forward for MS Office products, but it can be frustrating to use.

It is not clear where the save button is for instance. Where is the undo command? Others have told me they don’t like the new security model or lack of one. I probably need to explore Access 2007 more and get used to it all though.

HOW ARE YOU USING ACCESS IN YOUR BUSINESS?

I find it amazing that some companies are still using or supporting application written in Access 2.0. If budgets allow you should aim to upgrade to a newer version as Access 2.0 was never the most reliable of versions.

USE THE RIGHT TOOL FOR THE RIGHT JOB

If you need to perform calculations and do forecasting, use Excel not Access. If your database needs to cater for more than 5 or so users or even if it will be handling large volumes of information, consider using something such as SQL Server. Don’t try to make Access do too many things and stuff it with form after form. Keep your Access databases light and simple.

PLAN OUT WHAT YOU WANT YOUR SYSTEM TO DO

If you get it right or near enough from the beginning then it will pay dividends for you in the long run.
Here is how I plan out a system

Tags: , , , ,
Posted in Microsoft Access 2007 | No Comments »