MSAccess -node-net database design

Microsoft Access makes it easy to get the information you need and provides powerful tools that help you organize and share your database so you and your team make better decisions. Quickly find answers that count, share information over intranets, and build faster and more effective business solutions.

Build Powerful Business Solutions More Easily and Find Answers Faster
Enable Web collaboration and improve productivity with new tools in Access. Make data immediately available to any coworker. Update sales figures from the road or quickly check on customer details. Customize your views and formats to show precisely the information you need. And use built-in Microsoft SQL Server™ integration to create a scalable database that can grow with your business.

Manage and Share Information Over the Web
Seamless integration between your data source and interactive Web pages makes building and sharing a Microsoft Access database easier than ever. Use Web technology to get information fast and tailor it to your specific purpose. Add Office Web Components to visually analyze data in your Web browser.

View, Edit, and Analyze Data in a Browser Window
New, interactive Data Access Pages are Access forms and reports designed for the Web. They enable any employee to easily open, view, and update live data within the browser. Illustrate a Data Access Page with an interactive chart, then post it or attach it to e-mail. You and your coworkers will always have the latest information—in the office or on the road.

Add Interactive Reporting to Your Intranet
Link multiple tables into a single, interrelated view, called a Grouped Data Access Page. This way, you can create a hierarchy that groups records from general categories to specific details. For example, to analyze employee sales by region, first focus on all sales for a region. Then, drill down on results and bios for several sales reps in one state. You can interactively view, filter, and sort all kinds of information—from one page.

Drag Live Data onto a Web Page
Easily add to a Data Access Page by dragging from the field list. The form fields are directly bound to the database, so the information is always up-to-date.

Streamline the Way You Work
Good information leads to better decisions and improved productivity, and Microsoft Access 2000 makes information easier to find and use. Quickly analyze details and see vital relationships. Take advantage of new tools for customizing forms and reports. Turn numbers into answers—fast.

Take Advantage of Interface Improvements
The Access database window makes it easier to work with components of your databases. Use the vertical Objects bar to switch between forms, tables, and reports. Organize database objects into groups, and create shortcuts to frequently used items.

Browse Related Records in Datasheet View
Access gives you a picture-in-picture view of all related data in one window—without requiring you to perform a query. Instantly view relationships among tables to quickly make informed decisions. Expose deeper levels of information to visualize the relationships between records. Simply click the record you want to expand.

Apply Special Formatting to Selected Records
Change the appearance of fields based on their content so users can, for example, instantly identify high-sales customers or low-inventory items in a table or report. Set fonts, styles, colors, and banners according to numerical values or custom criteria you define.

Seamless Integration with SQL Server
Microsoft Access includes built-in Microsoft SQL Server™ integration that brings the power of high-end database management to the familiar Access environment. Take advantage of scalable SQL Server technology to create enterprise-level databases whenever you need them. This way, your system can expand with your business, with one database scaling to accommodate your changing business needs.

Expand Your Database with Your Business
Extend your Access skills to the client/server world by creating a SQL Server database from within Access. New Access Database Projects allow Access users to create true client/server applications using the familiar Access interface. Easily convert an Access file to a full SQL Server database using the built-in Upsizing Wizard—with no programming required.

Manage a SQL Server Database Using Access
You don't have to be a programmer or database administrator to take advantage of the advanced SQL Server reliability and scalability. Use Project Design Tools to powerfully manage the content and structure of a SQL Server database, without being a SQL Server professional. Use the Access Design View to work with server-side tables, procedures, and diagrams. Perform common SQL Server administration tasks such as replication, backup, restore, and security from inside Access.