What do you like best?
Microsoft Access is what our company uses for our vast database management system. Repetitive tasks can be automated with a variety of point-and-click options. We can create tables, forms, reports and email, print or export them.
We have over 200 dance competitions throughout North America and during the busy season have 32 weekend events in the USA and 28 in Canada. Access allows us to create and dive deep into the financials, preparation and organization of each event. This includes sales, videographer and photographer contact info, pay, accommodations, event details, notes regarding the event, variety of billing reports and much more.
Access can be placed on our server and multiple people and share and update data without overwriting someone else's work.
What do you dislike?
-It often crashes
-Many bug reports
-Often users have to exit for administration updates
-Using Access is different than knowing have to program Access. Need programming knowledge.
Recommendations to others considering the product
Leave the programming of the database to an expert because using is different than creating. I personally cannot re-create our company's database but i know how to use, and manipulate it.
-Always close Access when your done. The bigger the database and the longer it is open (overnight) the more it tends to crash.
-Keep two backups of your databases in two different locations.
What business problems are you solving with the product? What benefits have you realized?
-Past, present and future reports, bills, statistics, problems, solutions
-Contact information updating