Office File Recovery

Including a Calendar in Ms Access – A Primer

The Ms Access application is teeming with a host of features that makes it an extremely versatile product. In some cases you need to enter date into a specific record in Access. Now if you are looking to input the date data in the text format, there is a chance that different users may choose a different format. The solution lies in using a calendar popup which users can browse through and select the date. Let’s look at how this can be achieved in Ms Access.   Avoid endless...

Read more »

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 »