MS Access Queries: How To Add An Ad-Hoc Linked Table To Your Query

MS Access Queries: How To Add An Ad-Hoc Linked Table To Your Query

How well do you know MS Access queries? Here’s another way you can communicate with a table that does not reside within the same database without the need to officially link a table using either the Linked table manager tool or via the Linked table method.

Some have said this is Microsoft Access queries on steroids! I think MS Access database is generally on steroids in any event especially when users want to know the difference between this powerful application and the more commonly used Microsoft Excel.ms access queries

It is very easy to Continue reading “MS Access Queries: How To Add An Ad-Hoc Linked Table To Your Query”

MS Access Databases Properties: How To Set It Using Access VBA And The DAO Object

MS Access Databases – Properties: How To Set It Using Access VBA And The DAO Object

As with most Microsoft Office applications, MS Access databases also have a properties feature that captures the basic file attributes like author, date and subject to name a few. There is also a custom tab to edit and add your own properties and is stored with the database file itself.

To know more about changing the built-in properties window, see view and change MS Office 2010 file properties. For the earlier versions (pre 2007), this feature can be found via the File menu.

ms access databases properties

In this article, I want to introduce some Access VBA code to manage and control custom properties instead which is Continue reading “MS Access Databases Properties: How To Set It Using Access VBA And The DAO Object”

MS Access Queries: The Cartesian Product Effect – Working With Non Table Joins in Access

MS Access Queries: The Cartesian Product Effect – Working With Non Table Joins in Access

If you ask an Access database developer what are the key strengths to this application and why don’t they use Microsoft Excel instead, you will probably hear at least two things. The first being MS Access queries and how flexible it is to ask questions of your data and the second would be how easy it is to take advantage of RDBMS (Relational Database Management System) or in other words, joining tables together.

In this post, I want to focus more on the latter and talk about table joins or to be more accurate non-table joins and why you may want to consider applying this infrequent technique.

ms access queries

The process of having two (or more) source files (normally being two tables) for a query that have no join between them is known as Continue reading “MS Access Queries: The Cartesian Product Effect – Working With Non Table Joins in Access”

How To Create A Microsoft Access Database

How To Create A Microsoft Access Database

The quickest way of creating an Access database is to use either the wizard or template approach (depending on which version you are using) both of which are a breeze!

Remember, you need to have some idea of what type of database you are going to end up with by planning your database first and to help with this preliminary step, take a look at how to prepare and design an Access database to understand the scope and key objectives before proceeding.

There is also another approach in how to create a Microsoft Access database which will require some more in depth knowledge of the tools and controls available starting from a blank canvas building your workflows from the ground up

how to create a microsoft access databaseHow To Create A Microsoft Access Database – Some Pointers

The first step is to create the database container (or shell) using the ‘file save-as’ action which will hold all objects including Continue reading “How To Create A Microsoft Access Database”

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”