【正文】
開(kāi)發(fā)工具,用戶(hù)可以方便的設(shè)計(jì)、修改、瀏覽一條記錄數(shù)據(jù)的基本表;可以在表數(shù)據(jù)中進(jìn)行各種篩選和查詢(xún)操作;可以設(shè)計(jì)和使用各種窗體以實(shí)現(xiàn)數(shù)據(jù)顯示和操作;可以根據(jù)表數(shù)據(jù)設(shè)計(jì)打印各種報(bào)表;可以設(shè)計(jì)和使用宏,對(duì)表進(jìn)行一系列特定的操作。并且在數(shù)據(jù)需要作報(bào)表輸出的時(shí)候,又要反過(guò)來(lái)將已經(jīng)分散設(shè)置的大量的兩維數(shù)據(jù)表,再利用索引的技術(shù)進(jìn)行表的連接后,才能找到我們所需要的數(shù)據(jù),而這又將會(huì)影響到應(yīng)用系統(tǒng)的響應(yīng)速度。 關(guān)系型數(shù)據(jù)庫(kù)管理系統(tǒng)本身固有的局限性,表現(xiàn)在以下三個(gè)方面: 關(guān)系數(shù)據(jù)庫(kù)所采用的兩維表數(shù)據(jù)模型,不能有效地處理在大多數(shù)事務(wù)處理應(yīng)用中,典型存在的多維數(shù)據(jù)。 Access2020 是一種關(guān)系型的數(shù)據(jù)庫(kù)工具,關(guān)系數(shù)據(jù)庫(kù)是已經(jīng)開(kāi)發(fā)的最常用的數(shù)據(jù)庫(kù)之一。這樣一個(gè)變化給數(shù)據(jù)庫(kù)技術(shù)帶來(lái)了巨大的挑戰(zhàn),數(shù)據(jù)庫(kù)管理的對(duì)象已經(jīng)不再局限于文本數(shù)據(jù)等一些簡(jiǎn)單的數(shù)據(jù)類(lèi)型,而是需要描述和保存大量多媒體非結(jié)構(gòu)化的復(fù)雜數(shù)據(jù),以及數(shù)據(jù)之間的關(guān)系。它是一個(gè)功能非常強(qiáng)大的數(shù)據(jù)庫(kù)管理系統(tǒng)的 MIS 系統(tǒng)開(kāi)發(fā)工具。 Data tables can design various print statements。s mandate. If a user with the same time these two powers, the right set of user security database for a visit, then He had such authority is the intersection of the two powers. The Access20202020database, the group of users’ access to the database and the authority set up work, pleted only through the administrator. Set up the authority include: Open/Run, read design, design modifications, management, read data, update data insertion and deletion of data. Relational database management system inherent limitations in the following three aspects: Relational database used in the twodimensional table data model, can not effectively handle the majority of business applications, Typical of multidimensional data. Its inevitable result is that in plex ways, the interaction of the dramatic increase in the number of tables, not very good but also to provide realistic simulation of the data model. Relational database as they use more data model, which might lead to a massive storage space and wasting a lot of increase, and cause the system to respond to the declining performance. Furthermore, the data in reality, there are many types of relational database is not well addressed. Static applications such as report generation, and the design of the relational database management system after no response and efficient business processing for the optimization process. The result is often some relational database products, in the GUI and Web Services processing, not achieved the desired results. Unless additional hardware investment, but it does not resolve the fundamental problem. Relations with the twodimensional database table data model can deal with the majority of business application of a typical multi dimensional data, but the results are often the establishment and use of a large amount of data forms, it is difficult to establish a simulation of realworld data model. And the need for data output statements when they, in turn, would have dispersed the large number of twodimensional data tables. Reuse indexing technology linking the table in order to find all the necessary data, this, in turn, is bound to affect the use of the response speed. Database v