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.