Home  >  Article  >  Topics  >  Basic operations of access database

Basic operations of access database

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-06-17 11:31:0414239browse

Microsoft Office Access is a relational database management system released by Microsoft. It combines the two features of MicrosoftJet Database Engine and graphical user interface, and is one of the system programs of Microsoft Office.

Access is widely used in many places, such as small businesses, departments of large companies, etc.

Related recommendations: "python Video"

Basic operations of access database

The use of Access is reflected in two aspects:

1 , Used for data analysis: Access has powerful data processing and statistical analysis capabilities. Using the query function of Access, you can easily perform various types of summary, average and other statistics. And the statistical conditions can be flexibly set. Greatly improve work efficiency and work ability.

2. Used to develop software, such as production management, sales management, inventory management and other types of enterprise management software. Its biggest advantage is that it is easy to learn and

Basic operations

Add database password

The security of the database is very important, so adding a password to the database is also a skill that must be mastered. The specific steps are as follows:

1. Open the Access database, select Open, find the database to which you want to add a password, and open it exclusively.

Basic operations of access database

2. Click File, Information, and choose to encrypt with password.

Basic operations of access database

3. Enter the password to be set

Basic operations of access database

4. This will prompt you when opening the database Password entered.

Basic operations of access database

Use SQL script to generate database

When we use Access database, it is very fast to use SQL script to generate tables. , so how to run SQL scripts on Access? Please take a look.

1. After creating an empty Access document, click Create - Query Design

Basic operations of access database      

2. Just click Close after seeing this interface.

Basic operations of access database          

3. Click the SQL view in the upper left corner.

Basic operations of access database.

4. Do you feel familiar when you see this? Yes, this is the same as the query analyzer in SQL server. SQL statements can be executed.

Basic operations of access database

Summary: Access database has become an indispensable data management tool in small systems because of its convenience and ease of operation, so being familiar with Access database will be beneficial to our future work and study .

The above is the detailed content of Basic operations of access database. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn