Brief introductionMicrosoft Office Access is a relational database management system that is released by Microsoft. It combines two features of the Microsoftjet Database engine and the graphical user interface and is one of the system programs for Microsoft Office. access is widely used in many places, such as small businesses, large corporate departments, and so on. access is used in two ways:One, for data analysis: Access has a strong ability to data processing, statistical analysis, access to use the query function, you can easily do all kinds of summary, average and other statistics. And the conditions of statistics can be set flexibly. Greatly improve the efficiency and work ability. second, for the development of software, such as production management, sales management, inventory management and other types of enterprise management software, its greatest advantage is easy to learn,Basic OperationsAdd a database passworddatabase security is important, so adding a password to a database can also be a skill that must be mastered. The following are the steps:1. Open the Access database, select Open, locate the database you want to add a password to, and open it exclusively.
2. Click on the file, information, and choose the password to encrypt.
3. Enter the password you want to set 4. This allows you to prompt for a password when you open the database.
generating a database with SQL scriptswhen we use an Access database, using SQL scripts to generate tables is very fast, so how do you run SQL script on Access? Please look. 1. After creating an empty access document, click Create-query Design
2. When you see this interface, just click Close.
3. Click SQL view in the upper-left corner.
.
4. See if it feels familiar here, yes, this is the same as the query parser in SQL Server. You can execute the SQL statement.
Here's to say, somehow, creating a table here can only write one SQL statement at a time and cannot be executed all at once. If you can find a way to share a method of execution.
Summary: Because the Access database is convenient and has been operated as an essential data management tool in a small system, familiarity with the Access database facilitates our future work and learning.
Access database from entry to door (i)
