【正文】 . Advanced word processing software lets you define templates and macros to automate document creation, but it’ s not designed to handle plex transaction processing. In a spreadsheet,you enter formulas that define what automatic calculations you want performed. If you’ re an advanced spreadsheet user, you might also create macros or Visual Basic procedures to help automate entering and validating data. If you’ re working with a lot of data, you’ ve probably figured out how to use one spreadsheet as a “ database” container and use references to selected portions of this data in your calculations. Although you can build a fairly plex application using spreadsheets, you really don’ t have the debugging and application management tools you need to easily construct a robust data management application. Even something as simple as a wedding guest invitation and gift list is much easier to handle in a systems are specifically designed for application development. They give you the data management and control tools that you need and also provide facilities to catalog the various parts of your application and manage their interrelationships. You also get a full programming language and debugging tools with a database system. When you want to build a more plex database application, you need a powerful relational database management system and an application development system to help you automate your tasks. Virtually all database systems include application development facilities to allow programmers or users of the system to define the procedures needed to automate the creation and manipulation of data. Unfortunately, many database application development systems require that you know a programming language, such as C or Xbase, to define procedures. Although these languages are very rich and powerful, you must have experience before you can use them properly. To really take advantage of some database systems, you must learn programming, hire a programmer, or buy a readymade database application (which might not exactly suit your needs) from a software development pany. Fortunately, Microsoft Access makes it easy to design and construct database applications without requiring that you know a programming language. Although you begin in Access by defining the relational tables and the fields in those tables that will contain your data, you will quickly branch out to defining actions on the data via forms, reports, data access pages, macros, and Microsoft Visual Basic. You can use forms and reports to define how you want the data displayed and what additional calculations you want performed— very much like spreadsheets. In this case, the format and calculation instructions (in the forms and reports) are separate from the data (in the tables), so you have plete flexibility to use your data in different ways without affecting the data. You simply define another form or report using the same data. When you want to automate actions in a simple application, Access provides a macro definition facility to make it easy to respond to events (such as clicking a button to open a related report) or to link forms and reports together. When you want to build something a little more plex, you can quickly learn how to create simple Visual Basic event procedures for your forms and reports. If you want to create more sophisticated applications, such as contact tracking, order processing, and reminder systems , you can employ more advanced techniques using Visual Basic and module objects. Access 2020 includes features to make it easy to provide access to your data over your pany’ s local intra or on the Inter. You can create data access pages that allow users to view and browse the data in your Access database from Microsoft Inter Explorer. You can share and link to data on a Microsoft SharePoint Team Services site. You can also export selected data as a static HTML Web page or link a Microsoft Active Server Page from the Web to your database. Access provides advanced database application development facilities to process not only data in its own database structures but also information stored in many other popular database formats. Perhaps Access’ s greatest strength is its ability to handle data from spreadsheets, text files, dBASE files, Paradox and FoxPro databases, and any SQL database that supports the ODBC standard. This means you can use Access to create a Windowsbased application that can process data from a work SQL server or from a mainframe SQL database. For advanced developers, Access provides the ability to create an Access application in a project file (.adp) that links directly to Microso