Sams - Teach Yourself Microsoft Access 2000 in 24 Hours

Search Tips

Advanced Search

Sams Teach Yourself Microsoft Access 2000 in 24 Hours

by Timm Buchanan; Craig Eddy

Sams, Macmillan Computer Publishing

ISBN: 0672312891 Pub Date: 04/29/99

Search this book:

Table of Contents

What’s New in Access 2000

Although this book is intended for users who are new to Access 2000, chances are most people have heard

about some of the capabilities of previous versions of Microsoft Access. This section describes some the new

features brought to the table with Office 2000 in general and Access 2000 in particular.

Some of the new features include:

• Access Projects: Now you can use Microsoft Access as a front-end database development tool

without actually storing the data in the Access file. The Access Project file contains the forms, reports,

macros, modules and Data Access Pages. The file contains no tables, queries, or views. These are kept

in the back-end database.

• Choice of back-end database: With Access 2000, Microsoft has finally taken Access beyond the

realm of being simply a desktop database. As you’ll learn throughout this book, you can now use

Access to develop databases in a client/server environment such as Microsoft’s SQL Server. This opens

the Access developer to a whole new world of opportunities and capabilities. No longer is Access

relegated to the world of data suitable only for a stand-alone computer. You can now use Access as a

full-featured development tool for high-powered database platforms.

• Data Access pages: Data Access Pages are Web pages that you can create and link to an Access

database. These were described in an earlier section in this hour.

• Friendlier user interface in the Database window: The main window used in Access has been

made more user-friendly. For example, menus have been segregated into sets of commonly used and

less-used items. Also, you can have Access automatically move menu items you use most often to the

top of the menu.

• Subdatasheets: Using subdatasheets allows you to view data in a hierarchical mode. You can drill

down to related data. For example, when viewing orders in a datasheet, you can drill down to the line

items on the order within the same datasheet.

• Web Folders: This is a new feature of Office 2000 that allows you to link your Windows Explorer

file system to Web servers. If the Web server supports the FrontPage extensions, you can open and save

Access databases (and any other file) on a Web server easily using Web Folders.

• Office Clipboard: Using the new Office Clipboard, you can copy multiple items, at different times

and from different applications, and paste them all at one time.

Title

-----------