Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

From the introduction to Zero Foundation of Access Database to Chinese programming Software Development part 1

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report