The essence of access is not in VBA

Source: Internet
Author: User
Tags data structures

Access Enthusiasts are proud of VBA. I think this is not a good phenomenon. VBA is only a subset of VB, there are many limitations, such as not support inheritance, not support pointers, do not support child type, etc. Using VBA to manipulate data structures outside of the Office family is very difficult. VBA is just an attribute of access. In fact, no VBA Microsoft can sell access as usual. With VBA, you just make access more personalized. Do not add too much functionality to VBA, although it can be implemented, you will be very tired. If you're not just an access enthusiast, or a programming enthusiast, you should also learn another language (Pascal or C or assembler) in addition to VBA, and you'll find a very wide World open to you.

The essence of access is its ability to quickly frame database applications, and a skilled access user can complete a small, complete database application in a single day, from tables to forms to reports to menus. In fact, you can also find that the code inside the Northwind is very small.

The most common in our daily life is the Micro database, the number of records does not exceed millions. In this small system, security, concurrency, and so do not have too many requirements, the most need to focus on is time and cost. and access happens to be able to frame this kind of system very quickly, saving time and money. Getting Started with programming (http://bianceng.cn)

If you really want to learn VBA, I suggest you do not start from access, but learn from VB.

The most important thing to learn about access is to learn how to develop a miniature database system as quickly as possible without VBA.

In addition, I find it necessary to extend the Access Form Wizard and Report Wizard to help access users develop quickly. This is my future to do access development of the main direction, I hope more experts can add in.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.