As a database developer have you considered as your main tool?
Why? If you haven’t, then it is about time here are the reasons:
Easy to Create Data Tables
Even non-programmers can create a simple database structure using MS Access. However, it can only store smaller amounts of data ex: 20mb or 25000 records. Don't worry because in case you go big, you can link it to larger databases such as MS SQL to have the power, speed and storage you will need.
Easy to Generate Forms
With MS Access, you can easily create forms from scratch as they have Automatic Form Tools along with the program. Since their form generator is GUI-based, you can drag and drop text box and objects to create a form. You can also download form templates online to guide you in form design.
Easy to Generate Reports
Access has its own report generator to view and print out information in your database. You can also choose to write your reports from scratch or use other report generators such as Crystal Report writer. Access' report generator is GUI based making it flexible and easy to use.
Easy to Run and Compile Queries
Access makes you run simple queries like information displaying and functions thanks to it's GUI features. These queries can also run stored procedures from remote databases. Queries can also be compiled since MS Access uses VBA or Visual Basic as its base programming language.
Since it is included in the Microsoft Office family, you don't need to pay for a separate license to use it. It has loads of features that you just need to take time discovering. Access might look easy with its GUI features but you are able to create interesting and complex database or forms if you will learn how to code. MS Access also creates fastest and cheapest Rapid Application Development to prove and test your database theories.
Special Thanks to the following: • CateSchafing of Accede.com.au (read her article at http://accede.com.au/use-ms-access/) • incompetech.com for Background music • rptsoftware.com for Access Table images • microsoftaccesspros.com for Access Form/Reports images • fmsinc.com and yevol.com for query and compile images