Even though Microsoft Access makes it easy for many users to develop applications, very often you need to develop something more robust and go beyond the database basics. MS Access has special wizards and design tools, which you can use to create some simple and fairly nice applications. But if you are looking for more [...]

Many Access database users consider creating a form quite easy. But, unfortunately, not every user is aware that each form also has property settings, which we can changed to control form’s look and behavior. In this article you will find out how to manage form’s properties from a property sheet. You will also learn some [...]

Any software can have problems from time to time. And it is not rare to have problem for Microsoft Access either. The MS Access database gets corrupted, damaged or some files become inaccessible due to different reasons. And one of the most frequent reasons for MS Access database inaccessibility is a damaged or improper MS [...]

Microsoft Access database has many tools and objects for performing different tasks. One of the main objects in Access database is a table. Access tables are used to hold data. Each table is made up of columns, which can be also called fields or attributes. Each of the fields has a particular data type defining [...]

You don’t necessarily have to use programming to make MS Access more automated. You can create an Access macro in order to automate a lot of database tasks, which will add much more functionality to your Access database. MS Access allows you to assign a macro to a command button instead of using a toolbar [...]

Microsoft Access database has lots of useful features and one of them is combo boxes. Using combo boxes will improve the look and feel of your Access forms. In order to understand the work of combo boxes, let’s consider the example of countries.
Access forms may require different information like name, address or country. And [...]

There are many database systems available, but one application has been the most popular for a very long time and it is probably going to keep its popularity. This database application is Microsoft Access. If you consider taking the Microsoft Access training, you should think how it might affect you personally as well as your [...]

It used to be that spreadsheets were enough for storing and managing large amounts of data the many company employees used for their job. But today, most companies are faced with the need of managing a lot more data that is why spreadsheet is not a suitable option for many staff members. Instead, a lot [...]

After you have been using Microsoft Access database for a while and master all of its basic functions, you can move on to using some of its more advanced tools. If you want to use Access database more effectively, you can apply VBA code for automating your applications.
You are able to create customized desktop [...]

The smallest storage area in MS Access database is a page. All changes performed in Access database should be done by temporarily locking all the database pages. Locking the pages will help avoid corruption, because all the users might not be able to modify the data at the same time. But if the pages stay [...]