Using Databases
By Mike Chapple, About.com Guide to Databases
Databases offer a powerful, flexible way to manage your organization's data. In this section, we explore several popular database platforms: Microsoft Access, Microsoft SQL Server and MySQL, providing you with the information you need to get started and develop your database skills.
- Getting Started with Microsoft Access
- Advanced Topics in Microsoft Access
- Using Microsoft SQL Server
- MySQL: The Open Source Alternative
Getting Started with Microsoft Access
Microsoft Access provides users with one of the simplest and most flexible DBMS solutions on the market today. Regular users of Microsoft products will enjoy the familiar Windows "look and feel" as well as the tight integration with other Microsoft Office family products.
- Microsoft Access Fundamentals
- Access 2007 Tour: The New User Interface
- Create a Microsoft Access Database Using a Template
- Creating a Simple Query in Microsoft Access
- Converting an Excel Spreadsheet to an Access Database
- Creating Forms in Microsoft Access
- Microsoft Access Reports Tutorial
- Building an Access Database From the Ground Up
- Top 5 Microsoft Access Books for Beginners
- Adding Items to the Quick Access Toolbar in Access
Advanced Topics in Microsoft Access
Once you've mastered the basics of Microsoft Access, you're ready to move on to some more advanced topics. In these articles, you'll learn more about harnessing the full power of Microsoft Access to achieve your business goals.
- Creating an Access Database from Scratch
- Creating Database Relationships in Access
- Password Protect an Access Database
- Microsoft Access User-Level Security Tutorial
- Encrypting Access Databases
- Backing up an Access Database
- Access File Formats: ACCDB vs MDB
- How to Convert a Database to Access 2007's ACCDB Format
- Using Expression Builder in Microsoft Access
- Publishing Access Data on the Web
- Creating Dynamic Web Pages with Microsoft Access
- Splitting an Access Database, Step by Step
- Microsoft Access Function Library
Using Microsoft SQL Server
Microsoft SQL Server is an enterprise-class database designed for information-focused businesses. In this series of articles, you'll learn how to get started with SQL Server and leverage its power to meet your business needs.
- Introduction to Microsoft SQL Server 2005
- Introduction to SQL Server 2008: Choosing the Right Edition
- Creating Tables in Microsoft SQL Server
- SQL Server Data Types
- SQL Server Triggers
- SQL Server Stored Procedures
- Stored Procedures vs. User Defined Functions in SQL Server
- SQL Server Replication
- SQL Server Index Tuning
- SQL Server Disaster Recovery
- Transaction Isolation Models in SQL Server
- Partitioning SQL Server Tables
- SQL Server Backup Types and Scopes
- Choosing a SQL Server Authentication Mode
- Free and Low Cost SQL Server Options
- DEFAULT Constraints in Microsoft SQL Server
MySQL: The Open Source Alternative
Fed up with the world of commercial software licensing? Are you looking for a stable database platform for your organization but sweating at the hefty price tags attached to mainstream products from Microsoft and Oracle? MySQL may be for you!
