Some summary of access learning

Access is a Windows-based desktop relational database management system (RDBMS, Relational Database Management System) launched by Microsoft. It is one of the Office series application software. It provides 7 objects, including tables, queries, forms, reports, pages, macros, and modules, for building database systems; it provides a variety of wizards, generators, and templates to integrate data storage, data query, interface design, and report generation. Wait for operations to be standardized. Microsoft Access is widely used in many places, such as small businesses, departments of large companies, and developers who love programming specifically use it to create desktop systems for processing data. It is also often used to develop simple WEB applications.

So, how to learn Access database? Let me summarize some tips for learning Access database so that you can learn more.

1. Access database is not difficult to learn at all

So, this article is to encourage all students. The core is one sentence: Access database is really not difficult at all. Not difficult.

I often say that learning Access database is like climbing a mountain. It is difficult at the beginning. When you get to the middle of the mountain, you are too tired to climb. But as long as you climb to the top of the mountain, the scenery is completely different. .

Climbing to the top of the mountain means that your Access learning has reached a new stage, which means that you have mastered the wheel of Access to a very proficient level. You can easily use Access to build a framework and build your own software.

Walking down from the top of the mountain is a very comfortable and pleasant journey. You have turned the Access database into a practical skill, just like cooking, stir-frying, and driving. You can customize it according to the ingredients at will. Make a meal and decide to drive there based on where you want to go.

So I am the one who helps everyone climb to the top of the Access database as soon as possible.

2. Learn the Access database as a university course

Based on my personal experience and feedback from friends, I estimate that the Access database is an introductory course. , a maximum period of no more than two months.

Two months is almost the time it takes to teach a professional course at the university. However, since Access learning tutorials can be more intensive and Access is not difficult, there may be plenty of time for two months.

When I started to learn the Access database by myself, I relied on my strong personal interest to get started. I basically started from scratch. It took about two months to design a basically complete personal work and mastered Access. The basic framework of the database has "climbed to the top of the mountain".

Of course, we encountered many difficulties during the development process, and we relied on constant searches on Baidu and professional forums to tide over the difficulties.

No matter how simple Access is, it is still a software development craft. There must be testing and iteration. For novices, trial and error is a completely unavoidable stage. Trial and error is the fastest way to learn.

I recall that the trial and error process was the learning method that made me the fastest progress.

It is entirely possible to complete the basic mastery of the Access database system in two months. We know that a course in college takes more than two months. Everyone starts from scratch and studies for two months and then takes the exam. Many students can score in the 90s or even full marks. So don't underestimate your abilities.

And within two months, I have mastered the basic development skills of Access. What a great value!

3. Don’t have too high expectations for free wheels

Another thing to note is that since the quality of Access wheels downloaded from the Internet is not high, so for free wheels Don't have high expectations.

Some wheels are too old and may be developed based on the Access2003 framework. Some do not support 64-bit operating systems and cannot be opened.

Some friends complained to me that Access kept reporting errors on their XP computers.

What I want to say is that if you use Win98 or Win2000, the error may be more serious.

So the best way to learn is to make your own wheels.

A simple framework like Access is naturally suitable for quickly building simple wheels.

In two months, you will have 60% of the development capabilities, and the remaining 40% will not be difficult. It is like climbing a mountain. After you reach the top, you will go down quickly. The time to correct difficulties and bugs will also become shorter and shorter.

4. Learn to grow and update yourself

To be honest with everyone, I also have difficulties and bottlenecks when doing Access development: I still have to explore business needs. Far from enough.

Because my personal business scope is relatively narrow after all: I am doing data analysis for central enterprises, and I only deal with ERP every day. I know very little about financial management, so I have recently been supplementing my knowledge of financial accounting. I hope Expand Access application areas based on positions.

Through teaching, I was also delighted to discover more business needs, such as banking business analysis. I solved the problem of data analysis for a friend working in a bank, and used Access to solve the problem that pivot tables are not easy to solidify the process.

Continuously promote the use of Access in personal positions. This is the correct way to use Access.

Discovering pain points in business needs and solving them is the direction I want to work towards. Pure technical learning is very important, but for individual users it seems that it is not the focus of Access applications.

I have always used Access as Excel. I am particularly disgusted that many people use Access as a professional software development tool and distribute permissions at every turn. It is true that it can develop software, but more value is reflected in daily applications. It directly creates value, rather than consuming our daily value. .

We are all ordinary office workers. Unless we switch careers to IT, professional software development is not our job, nor should it be our job.

In other words, Access is a machine, not a part. Access databases should be used directly.

Many people keep asking me: I want to use Access to make a software that can be used by multiple people. I need to set permissions, administrators, and a lot of network-level requirements.

I asked him, can you use Excel to achieve these functions?

Excel and Access are basically brothers of Office. Multi-person applications that Excel cannot implement cannot be implemented by Access.

Access has a front-end and back-end division, which can barely be used by a few people. However, it is difficult to guarantee performance after networking, and the user experience is even worse. But this does not mean that Access is weak.

You can't let an SUV go to the F1 track to compete with professional racing drivers, right? With different positioning and different usage scenarios, SUVs perform much better than F1 on dirt roads accessible to every village. In the same way, Access is much more powerful than other technologies for data analysis and personal software development.

What I really don’t understand is why many people never know the principle of “making the best use of everything”? Keep staring at the shortcomings of one thing every day.

Nothing in this world is perfect. If you look at it with a critical eye every day, then Steve Jobs would be stupid and Apple would be a piece of shit.

Having said so much, let me encourage everyone! Don’t have too high expectations for Access. If it can help our work, wouldn’t we have already made a lot of money?

PHP Chinese website, a large number of free Access introductory tutorials, welcome to learn online!

This article is reproduced from: https://www.jianshu.com/p/72e7da649f94

The above is the detailed content of Some summary of access learning. For more information, please follow other related articles on the PHP Chinese website!