File Recovery

Quick tips to create Tabbed forms in Ms Access

The Ms Access application today is frequently used to run line of business applications which often have complicated data entry and access requirements. While you can design forms to perform such activities, placing too many fields or buttons on a form can clutter the user interface. So when you are looking to create detailed data entry and access forms, opting for tabbed forms would be a better choice. Take the example of a sales form where you include the details of a sale to a client....

Read more »

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 »