How to learn access by yourself

As more and more students learn access, people often ask how to learn access. I also expressed my personal opinion. I was really busy today so I took the time to write a note.

First of all, access development does not require anything, just thinking is enough.

# Those who do not have any development foundation must be familiar with the process, that is, the use of the software design interface of the development platform, the use of the VBA programming language and the use of the database query language . (Recommended study: web front-end video tutorial)

For the use of the development interface, first understand what access has (forms, tables, reports, etc.) and what it can do ( Forms are used for display and operation, tables are used to store data, and reports are used for printing), and how to use them to achieve the effects you want

For VBA programming, you only need to master the basics of programming, such as objects and properties. , how to declare objects, and familiarity with several functions commonly used in VBA, you can basically use VBA programming

For querying, you need to have a concept of the database and the basic statements to query the database

For students with previous experience

Getting started quickly, mainly how to use the access development platform, the subtle differences from other platforms, and the differences between VBA programming and other language programming .

Personally, I think that before you use something, you must first know what it can do, what its advantages and disadvantages are compared to other similar things, the components of this thing and the functions of each part. I spent five days To understand these, I didn't do any coding or interface design, and then I learned by following examples. I just talked about the login function of a system, which already includes most of the functions.

Then you will understand the function you need to implement and what parts can be used to achieve it, so that you will not be a bald donkey two feet tall and scratching your bald head. In fact, I hate development work, but I can barely accept it since I came into contact with access.

Finally, for us developers, we will encounter many problems during learning, ranging from difficult to super simple. Of course it is good to ask others, but we must learn to do it ourselves. To solve the problem, the access official website is a good resource, and the staff on the official website are also very good and know everything.

Of course this is not their job. We should know and be grateful after telling us, not endlessly asking for answers (there is no need to advertise their company, it is just a fact). Two other good methods are Baidu and access help, especially acces help.

As a senior or smart developer, you will make good use of help documents. If the problem that has been entangled for a long time has not been solved in the end, it is best to ask everyone for advice. Mr. Mai once told me, "It is better to teach a man to fish than to teach him to fish." This is the truth that I also use to guide newcomers.

The above is the detailed content of How to learn access by yourself. For more information, please follow other related articles on the PHP Chinese website!