Basic operations of access database

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"

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.

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

3. Enter the password to be set

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

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

     

2. Just click Close after seeing this interface.

         

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

.

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.

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!