MS Access 2000 Upgrade

MS Access 2000 Upgrade ... application as the front end of high-end database engines such as Microsoft SQL Server. It is also easier to use than its predecessors.

Based on the threshold you define, Access 2000 will automatically compact your databases when you close them, preserving disk space. The database window has been changed to accommodate new Access 2000 objects and make the program easier to use. With Access 2000, you can drag and drop Access objects into Microsoft Excel for further analysis. You can also create desktop shortcuts by dragging and dropping objects to the desktop. With picture-in-picture views, you can focus on and edit related data in the same window. Save your database for an earlier version of Access so that it's easier to share with users of earlier versions. Name AutoCorrect relieves the headaches you may have encountered after renaming a database object. In Access 2000, your change is automatically made elsewhere as needed. For instance, if you change the name of a field, Name AutoCorrect updates dependent objects, such as queries and forms, accordingly. Now you can change most form properties within Form View and see the effect immediately, rather than having to switch back and forth between Form View and Design View. Using Print Relationships Wizard you can print a copy of the Relationships windows, a visual diagram of how your database is structured. To make changes quickly and efficiently to controls, you can group them and manipulate them all at once. Access 2000 supports negative and positive numbers, and less-than, greater-than, between, and equal-to values. Also, you can set font, styles, banners, and colors based on values.