Microsoft Access Database: What is… Some Popular Questions

Microsoft Access Database: What is… Some Popular Questions

Here are some questions I’ve been asked over the years regarding Microsoft Access databases which I thought you may want to review. 

Q: What features make Microsoft Access a valuable tool over say the more popular Excel spreadsheet or any other desktop software?

A: The key feature is the ability to “ask questions” and perform actions with large amounts of the data via Queries which is its real strength.  For the common MS Office user who doesn’t know anything about MS Access databases, this application can seem fairly user-friendly and most users tend to lean to a more comfortable environment, namely Excel.

microsoft-access-database-what-is-some-popular-questions

Q: What’s the best way to start learning Microsoft Access?

A: It all depends on how you best absorb information and learn new technologies. Some people prefer a book but that can be quite time consuming and hard to follow as most books tend to be Continue reading “Microsoft Access Database: What is… Some Popular Questions”

Building An Access Database: The Planning Stages

Building An Access Database: The Planning Stages

The quickest way the building an Access database application is to use the wizard and template tools available which are a breeze! But you need to have some idea of what type of database you are going to end up with a bit of planning first.

To help you along, I have written seven articles (courtesy of EzineArticles) to help explain the database methodologies further.

building an access database

Building An Access Database: The Planning Stages

Take a look at the Continue reading “Building An Access Database: The Planning Stages”

How Building An Access Database To Your Own Specification Will Help

How Building An Access Database To Your Own Specification Giving You Total Control

One of my main ‘day’ jobs includes building an Access database and this would typically cover a wide range of tasks including an add-on report to an existing system, adding a new form interface making it more user-friendly, repairing errors and creating a new database from the ground up.

When applying to tender for a database build, often clients like to see my portfolio work as a way to measure my credentials as an Access database developer. Since most of my clients have sensitive data and processes, I just could Continue reading “How Building An Access Database To Your Own Specification Will Help”

Access 2007: Get up to speed

microsoft access screeshot video

Watch video here

A great overview for new users to Access as wells as for users migrating from the earlier versions of Microsoft Access (2003, XP, 2000, 97!).

This video tutorial makes it look easy to create and manage an Access database because it really is easy to do so!

This quick guide can also apply to the later version of Microsoft Access (2010) though the ‘Office‘ button has now been replaced with a ‘File‘ tab taking you to the ‘Backstage‘ environment.

You will need to get up to speed on how to build more in depth tables, queries, forms and reports as well as understand database terminology and methodologies including how relational databases work (rdbms).

Take a look at my eBook offers.