Databases Sitemap - Page 4 2014-12-18

View the Relationship Diagram
You'll now see the blank relationship diagram, as shown in the image above. Notice that there are no lines joining the tables; this indicates that you do not yet have any relationships between those tables. In our example, we'll be creating a relationship between the Routes table and the Runs table. As you can see above, we've added both of those tables to the diagram. Page 4.

Create the Relationship Between the Tables
It's showtime! In this step, we create the relationship between the two tables. Page 5.

View the Completed Relationships Diagram
Finally, review the completed relationships diagram to ensure that it correctly depicts your desired relationship. Page 6.

Microsoft Access User-Level Security Tutorial
If you’re a Microsoft Office power user, you might be familiar with the encryption features of Word, PowerPoint and Excel. These programs all allow file owners to easily apply encryption. Unfortunately, Microsoft Access doesn’t offer similar functionality, but it still has relatively powerful security functionality. In this article, we’ll take a look at Microsoft Access user-level security, a feature that lets you specify the level of access to grant each individual user of your database.

Creating a New Workgroup Information File
Creating a New Workgroup Information File. Page 2.

Providing a Name and Workgroup ID
Providing a Name and Workgroup ID. Page 3.

Selecting the Security Scope
Selecting the Security Scope. Databases. Page 4.

Selecting User Groups
Selecting User Groups. Databases. Page 5.

Permissions for the Users Group
Permissions for the Users Group. Databases. Page 6.

Adding Users
Adding Users. Databases. Page 7.

Assigning Users to Groups
Assigning Users to Groups. Databases. Page 8.

Creating a Backup
Creating a Backup. Databases. Page 9.

Collecting Information for an Access Database by E-mail
Microsoft Access allows you to collect information from individuals and update your database automatically based upon their replies. Access includes a wizard designed to facilitate this task. In this tutorial, we walk through the process of populating an Access table with user-provided information.

Choose an HTML form for your message
Access 2007 supports two types of form: HTML forms and InfoPath forms. Generally speaking, you'll want to use an HTML form because almost any e-mail user can read and use this type of form. InfoPath forms, on the other hand, require that all users have both Microsoft Office Outlook 2007 and Microsoft Office InfoPath 2007 installed on their systems. Click the radio button next to the HTML form option and click the Next button to continue. Page 2.

Choose to collect new data or update existing data
Office forms provide two data collection options: Collect new information from users that adds new records to your database Update existing data in your database. This option is useful if you wish to send recipients an e-mail message providing them with their current information and allowing them to make corrections. In this example, I'm asking users to add new records to a database, so I'll choose the

Select the fields you wish to collect
In the next wizard screen (shown above), you'll see a listing of available fields. Use the arrow buttons to move the fields you wish to collect from the left side of the window to the right side. If you wish to use the existing field name in the form, you do not need to make any changes. However, if you wish to use a user-friendly name, you may provide it in the

Automatically process e-mail replies in your database
On the next screen, you may choose to have Access automatically read e-mail replies and update your database accordingly. Simply check the box marked

Choose e-mail recipients
The next screen of the wizard asks you to select the way you will identify e-mail recipients. Your first option is to manually enter the addresses in Outlook. Obviously, that's not practical for a large database. I recommend using the second option whenever possible: using e-mail addresses stored in the database table. Click the

Customize the e-mail message
In the next step, you'll be able to provide a customized e-mail message designed to provide your recipients with introductory information. You may customize the e-mail subject, the introductory text and the field where you include the recipient's address. Page 7.

Send the e-mail message
Finally, you may review the list of recipients, as shown above, and remove individual recipients by unchecking the box to the right of their e-mail addresses. After reviewing the recipient list, click the Send button to send your message. Page 8.

Review the message
After clicking the Send button, Access will automatically send your messages using Outlook. An example form appears above. When users fill out your form, Outlook will automatically send the replies to Access, which will use them to automatically update your database. Page 9.

Select the Pages tab
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process. Page 2.

Start the Data Access Page wizard
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process. Page 3.

Select the desired data source.
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process. Page 4.

Select the fields to include.
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process. Page 5.

Choose any desired grouping levels
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process. Page 6.

Select the sort order
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process. Page 7.

Give the page a title
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process. Page 8.

Review the Finished Product
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process. Page 9.

Creating a Publication in SQL Server
Once you've created a published/distributor, you can then use SQL Server Management Studio to create publications that subscribing servers may receive. Each publication contains a collection of database objects that will be replicated to all subscriber servers. Page 2.

Creating a Publication in SQL Server
Once you've created a published/distributor, you can then use SQL Server Management Studio to create publications that subscribing servers may receive. Each publication contains a collection of database objects that will be replicated to all subscriber servers. Page 3.

Creating a Publication in SQL Server
Once you've created a published/distributor, you can then use SQL Server Management Studio to create publications that subscribing servers may receive. Each publication contains a collection of database objects that will be replicated to all subscriber servers. Page 4.

Creating a Publication in SQL Server
Once you've created a published/distributor, you can then use SQL Server Management Studio to create publications that subscribing servers may receive. Each publication contains a collection of database objects that will be replicated to all subscriber servers. Page 5.

Creating a Publication in SQL Server
Once you've created a published/distributor, you can then use SQL Server Management Studio to create publications that subscribing servers may receive. Each publication contains a collection of database objects that will be replicated to all subscriber servers. Page 6.

Starting the Database Maintenance Plan Wizard
Starting the Database Maintenance Plan Wizard. Page 2.

Name the Database Maintenance Plan
Name the Database Maintenance Plan. Page 3.

Schedule your Database Maintenance Plan
Schedule your Database Maintenance Plan. Page 4.

Select the Tasks for your Maintenance Plan
Select the Tasks for your Maintenance Plan. Page 5.

Ordering the Tasks in the Database Maintenance Plan
Ordering the Tasks in the Database Maintenance Plan. Page 6.

Configure the Plan's Task Details
Configure the Plan's Task Details. Page 7.

Choose Maintenance Plan Reporting Options
Choose Maintenance Plan Reporting Options. Page 8.

dBase
What is dBase? Find out here! Databases.

Delphi
What is Delphi? Find out here! Databases.

FoxPro
What is FoxPro? Find out here! Databases.

PHP Definition
What is PHP? Find out here! Databases.

Ingres
What is INGRES? Find out here! Databases.

MySQL
What is MySQL? Find out here! Databases.

Data
What is data? Find out here! Databases.

Index
What is an index? Find out here!

The Rational Guide to Microsoft Office Access 2007 Templates
Zac Woodall's book provides an excellent introduction to creating and sharing Microsoft Access database templates. It's a wonderful reference for anyone who needs to occasionally or regularly design or develop Access templates.

Resource Governor Definition
Looking for a definition of Resource Governor? Check the About.com Databases Glossary!

SQL Server 2012: Top Five New Features in SQL Server Denali
Microsoft recently released the first Community Technical Preview (CTP) of the newest version of SQL Server, code-named Denali. Three years after the release of SQL Server 2008, this new version of the popular database platform promises several exciting new features.

Access Hacks: Tips and Tools for Wrangling Your Data
If you're an experienced Access user, there's no doubt you'll find something useful in this book. It's packed full of so many useful tips and techniques that there's guaranteed to be something you don't already know!

Snapshot Replication Definition - About Databases Glossary
What is snapshot replication? Find out in the About Databases Glossary

10 Time-Saving Tips for Microsoft Access 2007
Looking to shave some time off your daily Microsoft Access administration and design tasks? There are many great, little-known features of this program that you can use to improve the efficiency of your database experience. I've put together a collection of ten tips that will improve your Microsoft Access experience.

Time-Saving Tips for Microsoft Access 2010
Looking to shave some time off your daily Microsoft Access administration and design tasks? There are many great, little-known features of this program that you can use to improve the efficiency of your database experience. I've put together a collection of ten tips that will improve your Microsoft Access experience.

Application Programmer Interface (API)
Looking for a definition of Application Programmer Interface (API)? Find it here!

How to Change the Default Database Format in Access 2010
Access 2010 uses the ACCDB format by default. In this article, we walk you through the process of changing this default setting for newly created databases.

How to Change the Default Database Format in Access 2007
Access 2007 uses the ACCDB format by default. In this article, we walk you through the process of changing this default setting for newly created databases.

Subscribing to a SQL Server Publication
Once you've configured a distributor and created a publication, the last step in configuring SQL Server replication is to create a subscriber who will receive publication updates from the publisher. In this tutorial, we walk through the process of subscribing to a publication, step-by-step.

Database Engine Tuning Advisor (DETA): Tuning Your SQL Server Database
Database Engine Tuning Advisor (DETA) allows you to optimize your SQL Server database configuration based upon the unique business requirements of your organization. It analyzes your database workload and uses that information to make recommendations about hte physical structure of your database and then allows you to actually implement the recommendations within DETA.

Snapshot Replication: Creating a Distributor in SQL Server 2008 for use with Snapshot Replication
SQL Server's snapshot replication technology allows you to automatically transfer information between databases to keep them synchronized. In this article, we look at the first step of the snapshot replication process: creating the replication distributor.

Using SQL Server 2008 Upgrade Advisor
Microsoft provides the SQL Server 2008 Upgrade Advisor to help you detect upgrade issues before they occur. This tool examines your SQL Server 2000 and SQL Server 2005 databases and checks for any potential conflicts.

How to Create a DMF Policy
Policy objects specify the conditions you wish to enforce against database targets using the Distributed Management Framework (DMF). In this tutorial, we create a DMF policy that enforces the stored procedure naming convention condition we created together in the previous step.

Verifying DMF Policy Compliance
The On Demand Execution Mode of SQL Server's Declarative Management Framework allows you to manually test whether a DMF target complies with a policy. This is a great way to test a policy-based management strategy prior to deploying an automated policy.

Manually Enforcing Policies in SQL Server 2008
The Declarative Management Framework allows you to manually reconfigure policy targets so that they comply with some policies. It is important to note, however, that this manual reconfiguration cannot resolve all policy compliance issues. SQL Server will be able to modify database settings, reconfigure permissions and perform similar tasks but it cannot, for example, change the name of a stored procedure without administrator intervention.

Encrypting SQL Server Database Connections
Encryption helps you prevent unauthorized access to information when individuals try to bypass your database security controls. For example, someone with a computer on your network might try to use a packet sniffer to monitor connections made by users to a database. Fortunately, database encryption allows you to protect the data sent over those connections from prying eyes.

Configuring Log Shipping in SQL Server 2008
Log shipping allows you to keep two SQL Server databases synchronized for high availability. In a log shipping relationship, the primary server transfers copies of its transaction logs to the secondary server on a periodic basis. The secondary server receives those logs and uses them to update its copy of the database so that it is then in the same state as the database on the primary server.

Microsoft SQL Server Database Maintenance Plans
Database Maintenance Plans allow you to automate many database administration tasks in Microsoft SQL Server. You can create maintenance plans using an easy wizard-based process without any knowledge of Transact-SQL.

Access 2007 Tour: The New User Interface
If you’re switching to Microsoft Access 2007 from an earlier version, you’re bound to immediately notice some major changes in the user interface. Microsoft modeled the Access 2007 look-and-feel after the Windows Vista model, providing the application with a clean, high-tech look that could dramatically alter your workflow. In this article, we walk through the new interface. We’ll explore the Ribbon, the Microsoft Office button, the Navigation Pane and other features of Access 2007.

Learning SQL E-Course
The Structured Query Language (SQL) forms the backbone of all relational databases. This language offers a flexible interface for databases of all shapes and sizes and is used as the basis for all user and administrator interactions with the database. In this course, you'll learn the basics of using SQL to store, retrieve and manipulate information in a database.

Database Design From the Ground Up
Database Design From the Ground Up

Building an Access Database From the Ground Up
Building an Access Database From the Ground Up

Microsoft Access Fundamentals
Want to learn how to use Microsoft Access? Find out on the About.com Databases site!

Databases Glossary
Glossary of database related terms from your About.com Guide to Databases

Sybase
The Net’s best collection of Sybase database product links from your About.com Guide to Databases.

Insert
What is the INSERT SQL command? Find out here!

SQL Server
What is SQL Server? Find out here!

Transaction
What is a database transaction? Find out here!

Trigger
What is a database trigger? Find out here!

eXtensible Markup Language
What is XML? Find out more about the eXtensible Markup Language here!

FileMaker Pro
What is FileMaker Pro? Find out here!

Expert Oracle
Review of Thomas Kyte's Expert One-on-One Oracle from Wrox Press

Paradox Definition
What is Paradox? Find out here!

Postgres Definition
What is Postgres? Find out here!

MySQL: The Complete Reference
Vikram Vaswani's book MySQL: The Complete Reference is a wonderful technical reference for this popular open-source database platform. It's comprehensive enough for seasoned MySQL users yet clear enough for the newcomer.

Fourth Normal Form (4NF)
What is Fourth Normal Form? Find out here!

Column
What is a database column? Find out here!

Database Consistency
What is Consistency? Find out here!

Determinant
What is a determinant? Find out here!

Durability
What is Durability? Find out here!

Entity
What is an entity? Find out here!

Field
What is a Field? Find out here!

Form
What is a database form? Find out here!

Database Normalization
What is database normalization? Find out here!

Record Definition
What is a database record? Find out here!

Row Definition
What is a database row? Find out here!

Table
What is a database table? Find out here!

Tuple
What is a tuple? Find out here!

Absolute Beginner's Guide to Access 2002
Review of the Absolute Beginner's Guide to Microsoft Access 2002 by Susan Sales Harkins and Mike Gunderloy.

Enterprise
What is an enterprise? Find out here!

Cursor
What is a Cursor? Find out here!

Database
What is a database? Find out here!

Isolation
What is isolation? Find out here!

Join
What is a database join operation? Find out here!

Key
What is a database key? Find out here!

Lock
What is a database lock? Find out here!

NULL
What is a NULL database value? Find out here!

Replication Definition
What is database replication? Find out here!

Report Definition
What is a database report? Find out here!

Repository Definition
What is a repository? Find out here!

Rollback Definition
What is rollback? Find out here!

Structured Query Language
What is the Structured Query Language? Find out here!

Two Phase Commit
What is two phase commit? Find out here!

View
What is a database view? Find out here!

Data Mining
What is data mining? Find out here!

Data Warehouse
What is a data warehouse? Find out here!

Knowledge
What is knowledge? Find out here!

DB2
What is IBM DB2? Find out here!

Open Database Connectivity (ODBC) Definition
What is Open Database Connectivity (ODBC)? Find out here!

Online Transaction Processing (OLTP) Definition
What is Online Transaction Processing (OLTP)? Find out here!

Active Server Pages
What are Active Server Pages (ASP)? Find out here!

Cold Fusion
What is Cold Fusion? Find out here!

Commit
What does it mean to commit a database transaction? Find out here!

Online Analytical Processing (OLAP)
What is Online Analytical Processing (OLAP)? Find out here!

Data Manipulation Language
Looking for a definition of data manipulation language (DML)? Find it here in the About Databases glossary.

Log Shipping Defined
What is Log Shipping? Find out in the About Databases glossary.

Merge Replication Defined
What is merge replication? Find out in the About Databases glossary!

NOT NULL Constraints - About Databases Glossary Definition
Looking for a definition of NOT NULL constraints? Find it in the About Databases glossary!

Object
Wondering what an object is in database terms? Find out here!

Transactional Replication Definition
What is transactional replication? Find out in the About Databases glossary

Unique Constraints - About Databases Definition
Looking for a definition of unique constraints in databases? Find one in the About Databases glossary!

Classification (Data Mining) Definition
What is classification? Learn about this data mining term here.

Regression (Data Mining) Definition
What is regression? Learn more about this data mining term here.

PL/SQL
What is PL/SQL? Find out in the About Databases glossary!

Book Review: Access Database Design and Programming
A great introductory text for Access users looking to become developers. If you're already programming with Access, you might want to find a more comprehensive volume.

Microsoft Access 2007
Microsoft might be competing against Oracle for market share in the server database category, but they maintain a clear lock on desktop databases with Microsoft Access 2007. The price tag may be a bit steep, but you won't find a more functional product anywhere. New bells and whistles in this version include a set of ready-to-go database templates to help you get a quick start and a vastly improved user interface that does away with the traditional toolbars and menus.

Access 2003 Visual QuickStart Review
Steve Schwartz's Microsoft Access 2003 Visual QuickStart offers a great introduction to Microsoft Access for beginners who prefer to learn by example rather than reading user manuals. It provides over 110 illustrated examples of tasks ranging from the basics of navigating Microsoft Access to more advanced topics like working with Pivot Tables.

Book Review: Hands-On Microsoft Access
Bob Schneider's Hands-On Microsoft Access takes an entirely different approach to learning Access. Rather than treating it as a product to be conquered through a series of mouse clicks and

ACCDB File Format
The ACCDB database file format was introduced with the release of Microsoft Access 2007 to replace the older MDB file format. The use of ACCDB format allows users to leverage enhanced functionality in Access, including the use of multivalued fields and strong cryptography.

MDB Definition
MDB is the file format used by Microsoft Access XP and earlier versions. It was replaced by the ACCDB format with the release of Microsoft Access 2007.

Multivalued Fields
Multivalued fields in Microsoft Access offer you the opportunity to allow users to select one or more options for a field value by using checkboxes.

User Level Security
User level security in Microsoft Access allows you to control the types of data that a user might access and the actions they can perform.

Database Concurrency
Looking for a definition of database concurrency? Find it here!

Designing Data Access Pages
Want to design a Data Access Page using Access 2000? This step-by-step tutorial walks you through the process.

Database Engine Tuning Advisor (DETA)
What is Database Engine Tuning Advisor? Find out in the About Databases glossary.

SQL Profiler
What is SQL Profiler? Find out in the About Databases glossary.

Transact-SQL Definition
What is Transact-SQL? Find out in the About Databases glossary!

SQL Server Security Book Review
SQL Server Security by Chip Andrews, David Litchfield and Bill Grindlay offers practical security advice with a hands-on perspective. It's ideal for SQL Server 7.0 and SQL Server 2000 administrators of all experience levels.

Creating a Publication in SQL Server
Once you've created a published/distributor, you can then use SQL Server Management Studio to create publications that subscribing servers may receive. Each publication contains a collection of database objects that will be replicated to all subscriber servers.

Choose Your DMF Condition
Conditions are the clauses that you may use to create DMF policies on a management facet. Examples of conditions are usernames, account creation dates and password complexity policies. In this example, we will create a DMF condition that enforces a stored procedure naming policy that requires all stored procedures begin with the

SQL Visual Quickstart
This software-independent book takes a hands-on approach to learning SQL. After some brief introductory material, it dives right into developing SQL queries designed to meet specific goals. It's a great reference for those who occasionally use SQL and forget the details.

Self Joins: About Databases Glossary Definition
Looking for a definition of self-join? Find it in the About Databases Glossary!

Book Review: SQL Cookbook
O'Reilly's SQL Cookbook is the best reference I've seen for skilled SQL developers. Modeled after a true cookbook, it offers many short snippets of SQL code designed to solve specific problems. You can pick and choose the ingredients you need to help complete your SQL project.

Object Oriented Databases
Looking for a definition of Object Oriented Databases? Find it here!

Compound Key: About Databases Glossary Definition
What is a compound key? Find out in the About Databases glossary!

Default Values in Databases
Looking for a description of default values and constraints in databases? The About Databases Glossary provides an easy to understand description.

Many-to-Many Relationships in Databases
Looking for a definition of many-to-many database relationships? Read our definition in the About Databases glossary!

Inference
What is inference in databases? Find out in the About Databases glossary.

SQL Injection Defined
What is a SQL injection attack? Find out more in the About Databases glossary.

Book Review: High Performance MySQL
High Performance MySQL is a wonderful reference for database administrators migrating to the MySQL platform, particularly in enterprise deployments.

Decryption
Decryption is the process of converting encrypted ciphertext into the original plaintext using a password or other key.

Encryption
Encryption is the process of converting plaintext into ciphertext with an encryption algorithm using a password or other key. Encryption prevents unauthorized individuals from viewing the contents of a file.

Learning SQL
The Structured Query Language (SQL) forms the backbone of all relational databases. This language offers a flexible interface for databases of all shapes and sizes and is used as the basis for all user and administrator interactions with the database.

Using 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.

Concatenation: About Databases Glossary Definition
Interested in the definition of concatenation? Find out in the About Databases glossary!

Get Lost Lessons for Building an Access Database From the Ground Up
Building an Access Database From the Ground Up

Integrating Databases with the Web
The Net’s best collection of database web integration links from your About.com guide to Databases.

FoxPro Programming Language
The Net’s best collection of FoxPro links from your About.com Guide to Databases.

Creating Dynamic Web Pages with Microsoft Access
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Database Design Book Review - Databases
Review of Database Design by Ryan K. Stephens and Ronald R. Plew, from your About.com Guide

Database Design Book Review - Databases
Review of Database Design by Ryan K. Stephens and Ronald R. Plew, from your About.com Guide

Blank1


Perfect Strangers
Stephen Poliakoff's latest TV play Perfect Strangers

Cold Fusion Database Programming
The Net's best collection of Cold Fusion links from your About.com Guide to Databases.

Get Lost Lessons for Database Design From the Ground Up
Database Design From the Ground Up

Get Lost Lessons for Learning SQL E-Course
The Structured Query Language (SQL) forms the backbone of all relational databases. This language offers a flexible interface for databases of all shapes and sizes and is used as the basis for all user and administrator interactions with the database. In this course, you'll learn the basics of using SQL to store, retrieve and manipulate information in a database.

How To Performance Tune SQL Server 7.0
Quick tips for performance tuning SQL Server 7.0.

How To Install the Northwind Sample Database in Microsoft Access
Learn how to install the Northwind sample database in Microsoft Access.

How To Convert an Access 2.0 Database to Access 97/2000
Wondering how to convert an Access 2.0 database to Access 97 or Access 2000? Follow these easy steps!

How To Create an Adobe PDF File From an Access Database
Step-by-step instructions on creating an Adobe Acrobat .PDF file from your Microsoft Access database

Databases - TopPicks
An index of TopPicks for the Databases guide site.

Database Certifications
The Net's best collection of database certification links including Oracle's OCP program, Microsoft's MCDBA and more!