Microsoft Access 2000
Find Out About Access 2000 Features . . .
. . . Newer Versions Of Access Replace Or Upgrade Much of Access 2000
What's New About Data Access Pages
Note: Access 2010 Does Not Use Data Access Pages
A data Access page is a Web page that you can use to add, edit, view, or manipulate data in a Microsoft Access database or a SQL Server database.
Note: Data Access pages were eliminated in Access 2007. We present this material for informational purposes only.
- You can create pages that are used to enter and edit data, similar to Access forms. You can also create pages with records displayed hierarchically, like MS Access reports.
- You can collect and distribute data in several ways with data Access pages. In addition to using them within an Access database or Access project, you can use them on the Internet or on an intranet, and you can send them in e-mail.
- Group records can be interactively viewed. By grouping pages, you can view only the details you want by expanding and collapsing group headers. You can also sort and filter records.
- You can analyze data and make projections. By using a PivotTable list, you can organize data in different ways to make projections and do complex calculations with a spreadsheet control, and you can view data graphically in a chart.
- You can display HTML text. You can store HTML code in fields in your database and display it as formatted HTML text on the page. For example, if a value in a field includes the HTML tag that formats text as italic (such as text), you can use a bound HTML control on the page to display the value as text.
- You use familiar design tools. In Design view, you can create pages using toolbars, the toolbox, themes, and other features that are similar to the tools you use to create forms and reports.
What's New in a Microsoft Access project
A Microsoft Access project (.adp) is a new Access filetype that uses OLE DB architecture to open an MS SQL Server database. Using an Access project, you can develop a client/server application.
- Working with a Microsoft Access project is very similar to working with an Access database. The process of creating forms, reports, data Access pages, macros, and modules is the same. Once you connect to a SQL Server database, you can create and view as well as delete or modify views or tables as well as stored procedures, or database diagrams by using Design Tools in Microsoft SQL Server.
- Access projects use a new technology named Microsoft Data Engine or MSDE, that is used for local data storage that will also work with MS SQL Server version 7.0. MSDE could be thought of as a client/server data engine alternative to the file server Microsoft Jet database engine. It is designed and optimized for use on smaller computer systems, such as a single-user computer or a small workgroup server.
- You can scale up data and objects by using the Upsizing Wizard. The Upsizing Wizard converts a Microsoft Access database (.mdb) to a new or existing Microsoft SQL Server 6.5 and 7.0 database or new Microsoft Access project (.adp) by scaling up the data and data definitions and migrating database objects.
What's New About Working on the Internet or Intranets
Microsoft Access 2000 provides new features designed to help you easily use the Internet. You need a Web browser, such as Microsoft Internet Explorer, and a modem, intranet connection, or other network connection to Access the Internet and take advantage of these new features.
- You can create data Access pages as described in "What's New About Data Access Pages" earlier in this article. Create Web pages that you can use to add, edit, view, or manipulate current data in a Microsoft Access database or a Microsoft SQL Server database.
- You can collaborate over an intranet or the Internet. Use Microsoft NetMeeting to collaborate with others on a Microsoft Access database or Microsoft Access project.
- You can assign hyperlinks to toolbar buttons or menu commands. This provides easy Access to a location on your computer, a network, an intranet, or the Internet.
What's New About Working with Data and Database Designs
Microsoft Access 2000 provides many new features that make working with data and designing a database even easier.
- You can use record-level locking. A Microsoft Access database now supports record-level locking, in addition to page-level locking (which locks all records on a 4 KB page). You enable the locking level with the new database option, Open databases using record level locking. To view this option, click Options on the Tools menu, and then click the Advanced tab. The actual level that is used depends on how the Access database is programmed.
- You can find and replace data more flexibly. You can now move freely between the Find and Replace dialog box and the data in the view or window.
- You can view related data in a subdatasheet. Use a subdatasheet to view and edit related or joined data in a table, query, or form datasheet, or in a subform all from the same view.
- You can automatically fix errors caused by renaming fields. Some common side effects that occur during renaming of forms reports, queries, fields and tables are corrected automatically with the Name AutoCorrect feature.
- You can take advantage of Unicode to use the characters of any language that Unicode supports in your data. Unicode compression can offset the effect of Unicode's increased storage space requirements.
- You can take advantage of dual-font support by specifying a substitute font that you can use in addition to your default font to display all of the characters in your data properly.
- You can work with the euro. To display euro amounts easily with other currencies, you can use the euro setting (#,###.##) of the Format property to indicate a euro amount. Alternatively, you can enter the euro symbol (€) by pressing ALT+0128 on the numeric keypad with NUM LOCK on. When you paste or import data that contains the euro symbol (€) from Microsoft Excel 2000 into Microsoft Access 2000, Access stores the euro symbol regardless of the currency symbol defined in Regional Settings in Windows Control Panel. Finally, you can use the EuroConvert function to convert one currency to another by using the euro as an intermediary.
- You can print a report showing the relationships in your Access database as they appear in the Relationships window.
- You can use the keyboard to manage relationships by creating, editing, and deleting relationships and joins.
- You can use Microsoft ActiveX Data Objects (ADO) to Access and manipulate data in a database server through any OLE DB provider.
What's New About the Database WindowThe Database window in Microsoft Access 2000 provides a variety of options for viewing and manipulating database objects.
- You can use the Database window toolbar to find commands quickly for creating, opening, or managing database objects.
- You can use the Objects bar to view database objects; its vertical orientation makes it easier to use.
- You can organize database objects into groups. Click the Groups bar to view your groups, which can contain shortcuts to database objects of different types.
- You can use new object shortcuts. In the Database window, you can quickly create a new database object by using a wizard, or open a new database object in Design view.
- You can customize how you select and open objects in the Database window. If you want, you can change the default behavior so that you select a database object by resting the pointer over it, and open an object by single-clicking it.
- You can select an object by typing its name. For example, click the Shippers table while viewing the list of table objects by typing Sh.
Go to page 2 for more information about MS Access 2000.