In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Access is a very important part of the office office suite, and now it has become the most popular desktop database management system. This course is the first part of a series of courses on Access database knowledge (please pay attention to the following courses). The course objective: to learn Access database quickly with simple examples, and the database format is mdb format.
This course chapter schedule:
Chapter 1: Overview of Access Database
1. Overview of Access database
Chapter 2: download and installation of Access database installation files
1. Download and install Access database installation files
Chapter 3: creating database tables
1. Create a table using the table wizard
2. Create a table using the table designer
3. Learning skills
Chapter 4: the basic operation of fields
1. Add, delete, and change mobile fields
2. the properties and functions of fields.
3. Primary keywords and indexes
Chapter 5: creating relationships between tables
1. Relationship type
2. Create and use table relationships
Chapter 6: creating subdatasheets
1. Create a child data table of the current table
2. Display appearance of Datasheet view
Chapter 7: encrypting the database
1. Set the database password
2. Set up database security mechanism
3. Analysis of the advantages and disadvantages of two encryption methods.
Chapter 8: creating a query
1. Query overview, query type
2. Use the wizard to create a query
3. Create a query using Design View
4. the basic operation of query and the rules of query optimization.
Chapter 9: shortcuts to query programming and generating query statements
1. A preliminary understanding of Chinese programming
2. Shortcuts to generate query statements
Chapter 10: summary of Access database
1. Summary of Access database
Course video material address: http://edu.51cto.com/course/17061.html
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.