Microsoft Access is an application used to create desktop database. Access is a very functional and powerful program, which allows you to create simple databases. It has always been better to use Access for databases with small amount of users, because if you plug in say 100 users, database will start having problems. Optimal amount of users is about 10 and if you need a lot more users, then it would be a good idea to switch to another professional database that can handle bigger number of users.
Access has experienced many editions, and it has evolved greatly over the years. Of course, there are still problems, but if you compare it to the earlier editions, you will see that it has become much better.
You can create different databases with Microsoft Access. It all depends on your skills, imagination and your business needs. It can be a simple data entry screen to store your book or DVD collection. Or you might need a more complex invoicing system with various screens for customers, purchasing, invoicing, delivery, orders, etc.
MS Access has proved to be a great and easy tool for simple databases. You can use a step-by-step wizard, which will guide you through the stages of creating a simple database. But, it might get complicated when you want to create a database to match your business needs. This is when you might need Microsoft Access support, which can be found in different forms. You might decide to contact Microsoft engineer and ask him to solve your problems. Or, you could also search for the solution to your problem in the Internet or buy a good book.
The level of Access support should depend on the complexity of the problem and its nature. If the problem is quite common, you shouldn’t have a lot of trouble finding the solution. But, if the problem refers to the system, you might consider posting your question to the MS Access forum. A lot of forums have experts posting on them, so you might get lucky and get the answer to your question almost instantly. Or you could even get the solution by email. But if you are creating a simple database with one table as a data source, you won’t probably encounter any problems. If you choose to move beyond creating database with a wizard, it might require further learning and support.
Before learning and using the Access database, think if it is even the right tool for your business to use. Maybe you will benefit more from using another application, even though Access has many advantages. And even though Access is considered to be one of the hardest databases to learn, you can still adjust it to your needs and skills.