Practical tips for Table Design and Optimization

The Ms Access application has enough versatility in it to be used as a backend for a multiuser line of business application in a small business setup. However if you are looking at receiving quick responses and avoid bloating up the Access database, certain best practices need to be followed. Let’s look at some practical tips to keep in mind when we are creating structures in the Access database and while working on it.   Avoid Creating too many Indexes In case you have a table...

Read more »

Key Benefits of Using a Switchboard in Ms Access

The Ms Access application can be used to store a huge array of information ranging from financial data to inventory lists. Some small businesses choose to store their entire business data in Access and also develop forms and modules for specific business functions. In addition reports and queries too may be created for quick viewing of data. Now if you happen to manage the Access database you would know from where you can access a particular data or report. However an employee in your firm who...

Read more »

Dealing with an Ms Word Document from within Access

One of the key advantages of using the Ms Office application suite relates to the flexibility of including data from one application into another. For example you can include an excel table in a PPT or a word document with ease. Similarly in Access too, you can include Ms Office data files like a word documents by using the OLE field type. There maybe many scenarios where you may need to include a world file in an Access database. Imagine you are creating an employee database and wish to...

Read more »