【正文】
om Microsoft Access2020functions since most prehensive, Windows and the Inter more closely with the database software, is a very powerful, and simple, easytouse database management system (DBMS) that the database storage, processing and management system. Access2020 relational database management system is Microsoft Office Public automation software as an integral part. It can effectively organize, manage and share the information in the database, and database information with the Web together. Through the Inter to share database information with the basic platform. With the development of information technology. Information technology platform is often the choice of establishing or reestablishing applications of the key issues, the database is part of the need to make a choice as a key platform. Access2020 as a relational database management system small and medium sized information management system ideal development environment, the current database in the field, there are more and more people use. It is a powerful database management system MIS development tools. The database is stored together a collection of relevant data, the data is structured. The database is a data storage and data operation of the tool. The role of the database is to organize and present information, in short, the database is a collection of information. Computer database can be divided into two categories: nonrelational database (flat) and relational database (relational). Relational database contains a number of data tables, databases containing various parts of the terminology, like records. Relational database management system has the technological dominance of the mainstream, but this traditional database management systems by using twodimensional data model, and there are inherent limitations and restrictions. It difficult to adapt to today39。 in the table data for various screen and query operation。其實Access2020 的功能非常強大,而且超乎你的想象。伴隨著信息技術(shù)的發(fā)展,信息技術(shù)平臺的選擇往往是建立或者是重新建立應(yīng)用系統(tǒng)的重要問題,而數(shù)據(jù)庫正是它們要做出選擇的關(guān)鍵平臺。數(shù)據(jù)庫的作用就在于組織和表達信息,簡單來說,數(shù)據(jù)庫就是不同信息的集合。難以適應(yīng)現(xiàn)在迅速變化的業(yè)務(wù)需求,以及新技術(shù)的發(fā)展。而這些都不是傳統(tǒng)關(guān)系數(shù)據(jù)庫中,用二維表簡單結(jié)構(gòu)就可以滿足需要的。而且,Access2020 允許創(chuàng)建自定義的報表用于打印或者是輸出數(shù)據(jù)庫中的信息。在 Access2020 中,用戶具有的數(shù)據(jù)庫訪問權(quán)限有兩種類型:顯式權(quán)限和隱式權(quán)限。在 Access 數(shù)據(jù)庫中,對組和用戶訪問數(shù)據(jù)庫權(quán)限的設(shè)置工作,只能通過管理員來完成。關(guān)系型的數(shù)據(jù)庫由于它所用數(shù)據(jù)模型比較多,還可能會造成存儲空間的海量增加和大量的浪費,并且還會導(dǎo)致系統(tǒng)的響應(yīng)性能不斷的下降。除非增加更多的硬件投資,但這不能從根本上解決問題。關(guān)系型的數(shù)據(jù)庫系統(tǒng)支持關(guān)系模型的數(shù)據(jù)庫系統(tǒng),關(guān)系模型由關(guān)系數(shù)據(jù)結(jié)構(gòu)、關(guān)系操作集合和完整性約束三部分組成。通過 Access2020 功能強大的工具,用戶可以方便的使用和管理數(shù)據(jù)庫,如創(chuàng)建和編輯數(shù)據(jù)表、設(shè)計和使用各種查詢工具進行查詢操作、設(shè)計和使用窗體、制作和打印報表、設(shè)計和使用宏設(shè)計和使用 Web頁等。用戶只需要簡單的操作就可建立數(shù)據(jù)庫中所使用的各種基本表、窗體和報表。 Access2020 不僅可以處理自身的數(shù)據(jù)庫文件,還可以處理其它一些數(shù)據(jù)庫系統(tǒng)管理軟件所建立的數(shù)據(jù)庫文件,能識別 Base、FoxBASE、 FoxPro、 Paradox 等數(shù)據(jù)庫格式文件,并且支持開放式數(shù)據(jù)庫互連性標(biāo)準(zhǔn)( ODBC)的 SQL。 支持長文件名,并且可以在文件名里面加空格,使文件便于理解、查找。