You can create powerful Access databases with no programming code at all. There may be a situation though when you do need some specialized functionality and then you will have to create a VBA Access database. The programming language used in all the MS Office products is VBA which stands for Visual Basic for Applications. [...]
Tag Archives: Access Database
MS Access 2007 help
MS Access 2007 is the version of Access that changed everything. The interface is like no previous version and takes some getting used to. Instead of the classic toolbars and menus we now have what is known as ‘The Ribbon. It is easier to now create basic forms and reports. Unfortunately there is not a [...]
Read full story •
Comments Off
How to use the autoexec macro
The autoexec macro is used to run actions when the database is opening. For example, you may wish to perform a data update before the system becomes active. You can do a similar thing with the start up options, but the autoexec macro will allow you to run more than one action. Lets look at [...]
Read full story •
Comments Off
Working with Microsoft Access databases
One should always use the right tool for the right job. If you want to store large volumes of data and have many users then think if Microsoft Access databases are the best way to go. Microsoft Access databases tend to be better suited to small systems with around ten or less users. For anything [...]
Read full story •
Comments Off
Using Microsoft Access database queries
Entering data in a database is done through tables or forms, but when we want to get our data out we should use Microsoft Access database queries. A Microsoft Access database query can produce a complete or a subset of data. You can also choose to restrict the data returned based on criteria you feed [...]
Read full story •
Comments Off
Microsoft Access 2007 for dummies
The world’s most popular desktop database, Microsoft Access has seen many versions. The latest is known as Office Access 2007 and is the most radical release yet. It offers a wide range of features for beginners and seasoned users alike. There are many books on the market including “Microsoft Access 2007 for dummies” which will [...]
Read full story •
Comments Off
Advantages of using a Microsoft Access Database
In today’s information age we are becoming less reliant on paper. When keeping records, be it household or business, it is a good idea to keep our information using some kind of computer solution. A Microsoft Access Database provides the perfect solution to our problems. There are different approaches we can take. We could look [...]
Read full story •
Comments Off
Discovering the Microsoft Office Access database
Microsoft Office has been around for many years and includes at its core Access, Word, Excel, PowerPoint and Outlook. Microsoft Office is the world’s most popular office suite and is used on millions of PC desktops. The application used for storing and retrieving large volumes of data is the Microsoft Office Access database. Previously it [...]
Read full story •
Comments Off
What is a database?
A database is a collection of information. A Microsoft Access database provides a mechanism for storing, retrieving and manipulating that information.
Read full story •
Comments Off
How To Add A Spellchecker To An Access Database Form
When entering data one can occasionally misspell a word or two. We are all used to having a spell checker at hand when typing a Word document for instance. Why should a spell check be limited to Word documents? Surely it would be of benefit if we could incorporate something similar in an Access database. [...]
Read full story •
Comments Off
