ACCESS的知识体系
很多非IT专业的朋友想学习Access, 对个人来说，能过Access的应用可以对日常工作起很大的帮助。 但对于准备学习，或者已经开始学习Access有朋友来说，如何通过系统的学习来成为一个高水平的Access设计者？ 下面列出我个人认为的Access的知识体系。 ACCESS 由
很多非IT专业的朋友想学习Access, 对个人来说，能过Access的应用可以对日常工作起很大的帮助。 但对于准备学习，或者已经开始学习Access有朋友来说，如何通过系统的学习来成为一个高水平的Access设计者？
下面列出我个人认为的Access的知识体系。
ACCESS 由一个桌面型数据库和其开发环境组成。 由于其高效的搭建模型速度，帮很多人喜欢用它来做模型与用户进行交流以确认设计的准确性。
ACCESS = ACCESS 操作 + VB + RDB(不是RDBMS，因为个人认为ACCESS还不能算一个数据库管理系统)
Access 操作
- 有关ACCESS应用程序的基本操作，比如建表，查询向导，报表向导，等
VB
- 高级语言程序设计 (变量声明，分支，IO处理，基本函数 ...）
- VBA开发环境 (VBE, 编写， 调试，...)
- ACCESS 对象模型 (access.application等)
- 数据库访问接口 (ADO / DAO)
- 操作系统访问接口 (API)
- ....
RDB
- 实体-关系设计 (ER,3NF)
- SQL语句 (DDL,DML)
- ....
以上是相关ACCESS的一些知识基础，当然开发的基础的80%还是对业务的理解能力，建模能力，软件工程能力。
一些资料
首次使用数据库的用户的入门方式 http://office.microsoft.com/zh-cn/access/HP051864092052.aspx
关于设计数据库 http://office.microsoft.com/zh-cn/access/HP051891362052.aspx
VisualBasic程序设计教程(学校教材) http://www.access-cn.com/thread-68269-1-1.html
ACCESS 微软自带帮助文档 http://www.access-cn.com/thread-68256-1-1.html
ActiveX 控件手册 - MSDN http://msdn.microsoft.com/en-us/library/aa338166(VS.60).aspx
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to use sql if statement
Apr 09, 2025 pm 06:12 PM
SQL IF statements are used to conditionally execute SQL statements, with the syntax as: IF (condition) THEN {statement} ELSE {statement} END IF;. The condition can be any valid SQL expression, and if the condition is true, execute the THEN clause; if the condition is false, execute the ELSE clause. IF statements can be nested, allowing for more complex conditional checks.
Unable to log in to mysql as root
Apr 08, 2025 pm 04:54 PM
The main reasons why you cannot log in to MySQL as root are permission problems, configuration file errors, password inconsistent, socket file problems, or firewall interception. The solution includes: check whether the bind-address parameter in the configuration file is configured correctly. Check whether the root user permissions have been modified or deleted and reset. Verify that the password is accurate, including case and special characters. Check socket file permission settings and paths. Check that the firewall blocks connections to the MySQL server.
What are the benefits of multithreading in c#?
Apr 03, 2025 pm 02:51 PM
The advantage of multithreading is that it can improve performance and resource utilization, especially for processing large amounts of data or performing time-consuming operations. It allows multiple tasks to be performed simultaneously, improving efficiency. However, too many threads can lead to performance degradation, so you need to carefully select the number of threads based on the number of CPU cores and task characteristics. In addition, multi-threaded programming involves challenges such as deadlock and race conditions, which need to be solved using synchronization mechanisms, and requires solid knowledge of concurrent programming, weighing the pros and cons and using them with caution.
How to avoid third-party interfaces returning 403 errors in Node environment?
Apr 01, 2025 pm 02:03 PM
How to avoid the third-party interface returning 403 error in the Node environment. When calling the third-party website interface using Node.js, you sometimes encounter the problem of returning 403 error. �...
How to configure zend for apache
Apr 13, 2025 pm 12:57 PM
How to configure Zend in Apache? The steps to configure Zend Framework in an Apache Web Server are as follows: Install Zend Framework and extract it into the Web Server directory. Create a .htaccess file. Create the Zend application directory and add the index.php file. Configure the Zend application (application.ini). Restart the Apache Web server.
How to solve the 'Network Error' caused by Vue Axios across domains
Apr 07, 2025 pm 10:27 PM
Methods to solve the cross-domain problem of Vue Axios include: Configuring the CORS header on the server side using the Axios proxy using JSONP using WebSocket using the CORS plug-in
How to efficiently obtain component_verify_ticket in EasyWechat 5.5?
Apr 01, 2025 pm 12:42 PM
Get ComponentVerify in EasyWechat5.5...
Summary of phpmyadmin vulnerabilities
Apr 10, 2025 pm 10:24 PM
The key to PHPMyAdmin security defense strategy is: 1. Use the latest version of PHPMyAdmin and regularly update PHP and MySQL; 2. Strictly control access rights, use .htaccess or web server access control; 3. Enable strong password and two-factor authentication; 4. Back up the database regularly; 5. Carefully check the configuration files to avoid exposing sensitive information; 6. Use Web Application Firewall (WAF); 7. Carry out security audits. These measures can effectively reduce the security risks caused by PHPMyAdmin due to improper configuration, over-old version or environmental security risks, and ensure the security of the database.
