Office File Recovery

Developing a Form in Design View in Ms Access

The Ms Access database is known for its overall ease of use. You can create tables and queries in it through the Wizard functionality with minimum effort. Similarly the Form Wizard can be used to create forms in quick time. However the Wizard has certain limitations and at certain point of time you may wish to design forms manually. Especially when you are looking to create custom forms or nested sub-forms; using the design view is a more apt choice. Let’s look at how you can quickly create...

Read more »

A Quick Lowdown on key Queries in Ms Access

One of the biggest benefits of using a relational database system like Ms Access relates to the ease with which data can be accessed and modified. Typically this is achieved with the help of queries which can glean relevant information from a huge data repository. In other words queries can give you a truncated view of the entire database, with only the relevant records getting showcased. Queries can also be used to perform a variety of actions such as updating data or deleting records when...

Read more »

Understand the Scenarios where you should opt for Ms Access instead of a spreadsheet

In case of nearly every other small business, spreadsheets such as Ms Excel are typically preferred to store business data. While a section of small businesses do graduate to Ms Access over a period of time, a large section still tends to remain stuck with spreadsheets. As the business grows and number of different activities need to be captured, a whole array of spreadsheets are created. In a matter of years, such a business may be looking at a large set of Excel files, which are not...

Read more »