Microsoft Office gave us many useful applications and Access is probably the hardest one to master. It is the application that often requires outside training in order to use it effectively. It is not that hard to use Word, Excel or other MS Office applications, but even if you are an experienced computer user, you [...]
Visual Basic for Applications or VBA is a programming language driven by event. It can be used in Microsoft Access application and can help you control your database even more. It is great to use VBA, when you work with dialogue boxes or custom forms. With VBA you can create forms with much better interface [...]
After you finish your Microsoft Access training, you return to your work place, confident in your skills to create a powerful database, which will help you perform your job easier. But very soon you find out that working with the database in the classroom and at your work place is completely different and that it [...]
Microsoft Access has many useful objects and one of them is macro. Macro adds more functionality and control to your Access database. You can create macros to perform almost any task in your database and it is not that hard. Using macros is the next step of using building and designing your database after mastering [...]
If you want to create the best possible Microsoft Access database, then this article might be useful to you. The items described in this article have been proved to be the main causes of slow performance, user difficulties, errors and data corruption in databases. Avoiding these mistakes will help you prevent minor or major database [...]
Sometimes medical office database installation can be a real pain for physicians and not because they don’t want to store their medical records electronically, but because most database software packages are very expensive and too hard to understand. But it doesn’t have to be this way. You can create medical office database system, which is [...]
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 [...]
