1 / 12

Why we need to use MS Access?

Most people belittle the capabilities of MS Access to develop complex databases due to its simplicity. Find out the reasons why database developers should use MS Access more often. Read More: http://accede.com.au/use-ms-access/

accedeholdings
Download Presentation

Why we need to use MS Access?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. As a database developer have you considered as your main tool?

  2. Why? If you haven’t, then it is about time here are the reasons:

  3. Easy to Create Data Tables

  4. 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.

  5. Easy to Generate Forms

  6. 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.

  7. Easy to Generate Reports

  8. 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.

  9. Easy to Run and Compile Queries

  10. 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.

  11. 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.

  12. 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

More Related