Databases Sitemap - Page 4 2014-04-17

Music Collection Database Template
This music collection database template from Microsoft's Office Community allows you to track your music collection by recording name, artist, genre, label,

Refreshing the Access 2007 GUI
In a recent forum posting, Brainhose wrote: I sometimes run code to maintain data which deletes tables or queries and then recreates them. The Access 2007

Video Collection Database Template for Microsoft Access
The video collection database template, available for free from Microsoft, allows you to track your entire video collection. It includes fields for program

Credit Card Security for Databases (PCI DSS)
The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit or

Creating Database Links in Oracle
Many times, database administrators find it necessary to link two remote databases to each other for the purpose of sharing data. Oracle provides database

Testing Web Applications for SQL Injection Vulnerabilities
SQL Injection attacks pose tremendous risks to web applications that depend upon a database backend to generate dynamic content. In this type of attack,

Creating Relationships in Microsoft Access 2007
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t

Matrix Data Storage in Microsoft Access
In a recent forum posting, Rjones_17 wrote: I’m new to Microsoft Access and need some advice. I’m currently attempting to map out the offsets of ships,

Slowly Changing Dimensions in SQL Server 2005
In a recent article on SQL Server performance, Dinesh Asanka provides a helpful introduction to the use of slowly changing dimensions (SCD) in SQL Server 2005.

Streaming Media Database
In a recent forum posting, krnoble wrote: We recently changed the format on a commercial radio station that we operate. The previous format was wildly

Top Ten Things to Do While Waiting for SQL Server 2008
Are you tired of waiting for SQL Server 2008? I just posted a list to my Amazon Author's Blog of the Top Ten Things to Do While Waiting for SQL Server 2008.

Forms in Access Databases
In a recent forum posting, Priya_23 wrote: I'm pretty new to using Access. I have just created a database in access by importing the data on my excel

Access 2007 Compatibility Issues?
In a recent forum posting, Sue Hopkins wrote: I created a database using Access 2003. When a user opened it with Access 2007, most of the switchboard was

Additions to Access Function Library: Hex(), Hour() and IIf()
We've added information and examples of three new functions to our Microsoft Access Function Library. Check out the new pages on: Hex() Hour() IIf()

Free Databases: Too Good to be True?
In a recent forum posting, Dan wrote: It seems a lot of the information I've come across says that server database can run an expensive bill. But, I was

Using the Ribbon in Access 2007
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

Too Many Reports and Queries in Access
In a recent forum posting, Emilia wrote: I seem to have too many reports and queries. For example, I have several reports each slightly different with its

Using TRY…CATCH to Handle SQL Server Errors
The TRY…CATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the

Credit Card Security for DBAs (PCI DSS)
The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit

Access Database Copying Itself!
In a recent forum posting, Beth wrote: I have a Access database loaded on a company shared folder and when my end user closes the database a new one is

Oracle Database Pricing
Oracle recently announced new U.S. price lists for commercial and government customers of the following products: Oracle Technology Products Oracle

SQL Database Normalization
If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you Is that database normalized?

Conditional Triggers
In a recent forum posting, Mustafa wrote: I have a checkbox and button on my form and a Trigger(for insert) on one of my database tables called Table1. If

SQL Server Replication Scenario
In a recent forum posting, RAS wrote: We connected two SQL Server Standard Edition servers using replication. Let me call the first one as the Main Server

Bookmarks Database Template for Microsoft Access
The Bookmarks Database Template for Access 2007 allows you to easily organize, rate and categorize websites for future reference. It's available for free from

Joining Data from Three or More Tables with an SQL INNER JOIN
You can use SQL JOIN statements to combine data from three or more tables. In an earlier article, we took a look at using inner joins and outer joins to combine

Accounting Ledger Database Template for Microsoft Access
The Accounting Ledger Database Template for Access 2003 allows you to create a basic chart of accounts and transaction ledger. It's available for free from the

Patient Database
In a recent forum posting, mbuffet wrote: I have a PatientID field in 2 different tables (General Information and Diagnosis) so that I can make a

Variable Types for SQL Server Databases
Selecting appropriate data types is one of the most important considerations when designing a SQL Server database. Choices you make in the database design phase

Merging Access Databases
In a recent forum posting, Sam wrote: Is it possible to merge lots (200 or more) of individual Access files into one single file? Each one will contain an

Sorting out SMALLDATETIME, DATETIME and TIMESTAMP in SQL Server
SQL Server 2005 offers three different data types that all sound like likely candidates for storing time values: DATETIME, SMALLDATETIME, and TIMESTAMP. Here's

Upsizing from Access to SQL Server
In a recent forum posting, Data Analyst wrote: I am trying to use the upsizing wizard to upsize an Access database to an SQL Server database. However, the

PDF Reports from an Access Database
Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access

Creating a Mailing List in Microsoft Access
One of the most common uses of a Microsoft Access database is generating labels for mass mailings. In this tutorial, we examine the process of creating mailing

Microsoft Certified Application Specialist (MCAS) Program Requirements
If you use Microsoft Access 2007 as a regular part of your job, or you hope to gain employment in the field of user-level databases, you may wish to consider

Help with the MAX() function
In a recent forum posting, aoneistheman wrote: I'm a SQL newbie, and am creating this crazy view of other views. I need help using the MAX() function. I

Oracle 11g Certification Programs
In this article, we'll take a brief look at the Database Administrator track and the three possible certifications you can earn on your way to Master status.

Access to SQL Server Replication
In a recent forum message, ICCLEARLY wrote: We are looking for a way to set up replication between several remote MS Access databases and a central MS SQL

Highlight Search Results in Access 2007
Allan Browne recently posted an Access form he developed that allows users to search for data within a database and then highlight the results, Google-style.

Developing Access Programs in C and C++
Are you a software developer interested in leveraging the database capabilities of Microsoft Access in your programs? A recent white paper by Microsoft's

Creating a Backup of an Access Database
In a recent forum message, cscheible wrote: Hello -- I am needing to backup Microsoft Access 2002 database before I upgrade it to Access 2007. I have never

Call for Proposals: MySQL Conference and Expo
Done something interesting with MySQL recently? Want to share your experiences with the MySQL community? The 2009 MySQL Conference and Expo may be the perfect

Constraints in Microsoft Access
In a recent forum message, TJ McDevitt asks: I am using Microsoft Access to build a database that will store employee data. I am using VBA to write macros

Isolation Models in Microsoft SQL Server
Normally, it's best to allow SQL Server to enforce isolation between transactions in its default manner; after all, isolation is one of the basic tenets of the

Tracking Employee Training in a Database
In a recent forum posting, Doc wrote: I am new to the forum and a greenhorn at access. I have tinkered with it some but see it is a powerful tool. I am

Ten Commandments of Microsoft Access
Have you read the Ten Commandments of Microsoft Access? This collection of gems from Dev Ashish includes such pearls of wisdom as: Thou shalt choose a

Multiuser Databases in Microsoft Access
In a recent forum posting, blewis70 wrote: I am very new to using Access but have created a database that I would like to use at the office. There are

Microsoft SQL Server 2008: Choosing the Correct Edition
SQL Server 2008 is the latest release in Microsoft’s enterprise relational database platform series. In this substantial upgrade, they've packed the new

Oracle Enters the Hardware Market
At OpenWorld, Oracle CEO Larry Ellison announced that Oracle is partnering with HP to enter the hardware market with two new products: the Database Machine and

Access Field and Database Sizes
In a recent forum message, Keval wrote: I am trying to import data into an existing access table. For one of the columns the field size is 25 but I am

Table Partitioning in SQL Server
Looking to optimize the performance of your SQL Server database? If your database contains very large tables, you may benefit from partitioning those tables

Virtualization and SQL Server 2008
Many organizations (my own included) are turning to virtualization as an effective way to save money, consolidate resources and conserve precious rack space.

SQL Server Disaster Planning
After completing the process of installing and configuring Microsoft SQL Server, any database administrator is entitled to sit back and take a well-deserved

E-R Diagramming Discussion Continues
The discussion on E-R Diagrams continues in our forum. Justroy recently wrote: First, ER Modelling is not essentially a database design approach, it is a

SQL Server 2008 for Dummies is out!
As many of you know, I've been working for about a year on SQL Server 2008 for Dummies. Well, I'm pleased to report that the book is finally available in

Home Inventory Database
If you're looking to create an inventory of your possessions for insurance purposes, this home inventory database template provides an excellent starting point.

Merge Replication Filters in SQL Server
In a recent forum message, pezi179 wrote: I just started using the filters for my merge replication and now I'm confronted with a problem. I'd like to

Using SQLCMD: Microsoft SQL Server's Command Line Utility
Microsoft SQL Server provides users with a variety of rich graphical user interfaces to retrieve and manipulate data and configure SQL Server databases.

Using the Northwind Sample Database in Microsoft Access
Looking for a copy of the Northwind sample database for Microsoft Access? This database provides you with a great opportunity to practice your database skills

Building a Newspaper Database
In a recent forum message, Curatorial Assistant asks: I'm trying to make a database of a set of newspaper articles. Each newspaper article has already been

Creating PDF Reports in Microsoft Access
Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access

Report Builder 2.0 Released!
If you've been awaiting the release of Report Builder 2.0, you can exhale! The product, originally expected to be released with SQL Server 2008, is now

Oracle in the Cloud
SearchOracle features an interesting article on cloud computing this week: Are Oracle's SaaS and cloud computing efforts all over the sky? Chris Maxcer points

Scheduling Access Reports
In a recent forum message, Veviana wrote: I have learned a bit about MS Access and have developed a fairly decent database. I am very keen to understand

CHECK Constraints in Microsoft SQL Server 2008
CHECK constraints allow you to limit the types of data that users may insert in a database. They go beyond data types and allow you to define the specific

Understanding the ACCDB Microsoft Access File Format
The release of Access 2007 brought us a new file format. The MDB database files we’ve known for over a decade are now slated to become historical relics. While

MS Access User Permissions
In a recent forum message, Hugo wrote: I have an Access Database with some different users. Some of these users are declared as users that can only read the

Bug in Chinese Full-Text Search?
In a recent forum posting, Deng wrote: Hi everyone, I have a table with a varchar column, which contains Chinese sentences (Simplified Chinese character).

New Oracle Performance Tuning Certification with Exam Discount
Oracle recently announced the new availability of the Oracle Database 11g Performance Tuning Certified Expert credential. This certification program is

Front Ends, Back Ends and Dashboards, Oh My!
In a recent forum message, John K. wrote: Due to a sudden downsizing of the firm I work for, I've gone from a data-entry and report function to the database

Unique Constraints in Microsoft SQL Server
UNIQUE constraints allow SQL Server administrators to specify that a column may not contain duplicate values. When you create a new UNIQUE constraint, SQL

Creating NOT NULL Constraints in Microsoft SQL Server
NOT NULL constraints in Microsoft SQL Server allow you to specify that a column may not contain NULL values. When you create a new NOT NULL constraint on a

SQL Server Constraints
SQL Server constraints allow you to enforce rules in your database. These rules may affect business logic, database integrity and/or table structures. Each one

Modifying an Access Database Template
In a recent forum message, Porta wrote: I want to make modifications to the Access 2007 Student database template. Specifically, I want to modify the form

Dog Rescue Database
In a recent forum message, Pat wrote: I work with a non-profit organization (dog rescue). I know nothing about databases. What we need is something to keep

PCI DSS Database Security Requirements
The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit

Migrating from Access 2003 to Access 2007
In a recent forum message, Dan Scanlon wrote: I need to migrate multiple Access 2003 databases to Access 2007. Can anyone tell me if software exists that

Data Mining Software
Data mining products are taking the industry by storm. The major database vendors have already taken steps to ensure that their platforms incorporate data

Grocery Lists in Microsoft Access
In a recent forum message, GJMonty wrote: I'm trying to find a way to organize/track groceries in my house. I would like to create a database to help me

Database Normalization Concepts
If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you Is that database normalized?

Forms Problem in Microsoft Access
In a recent forum message, NSmith326 wrote: I'm having problems referencing a subform control from a main form. Here's the syntax that I've been using:

Pattern Matching in SQL Server Queries
You may often need to create a SQL Server query that performs inexact pattern matching through the use of wildcard characters. The use of wildcards allows you

Attaching Files to an Access Database
Microsoft Access allows you to include attachments in database tables. You may store photos, graphics, documents and other files in your Access database using

Weight Loss Tracking Database in Microsoft Access
The nutrition database allows you to use Microsoft Access to track your dietary and exercise habits, track and chart your weight over time and plan your meals.

Validation Rules in Microsoft Access?
In a recent forum message, DW wrote: I am trying to create a simple validation rule that divides one column by another. In Excel, this is very simple. I am

Dates and Times in Microsoft SQL Server
With the introduction of SQL Server 2008, Microsoft answered the pleas of many database professionals by introducing revamped date and time . These new data

Bug Tracking Database in Microsoft Access
The bug tracking database allows you to use Microsoft Access to track open and closed bugs in a software development project. Download the Bug Tracking

Writing SQL Cursors
In a recent forum message, JohnnyBoy72 wrote: I’m relatively new to writing sql queries and I’m running a query to look for patterns in stock trading. Two

Free Learning SQL E-Course Now Available
The Structured Query Language (SQL) forms the backbone of all relational databases. This language offers a flexible interface for databases of all shapes and

Concatenating Text Fields in Microsoft Access
In a recent forum message, SmallTownDreamer wrote: I'm trying to create an expression in a report which will concatenate some text fields. Unfortunately, as

Timestamps In Microsoft Access
There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It’s

Sequential Numbers in VBScript
In a recent forum message, JustNS11 wrote: I currently have a form where the fields are Part No. StepID#, Step# and Operation ID. The primary key is the

Counting Records in a SQL Database
SQL provides the COUNT function to retrieve the number of records in a table that meet given criteria. We can use the COUNT(*) syntax alone to retrieve the

Using Views to Control Database Access
Database views allow you to easily reduce the complexity of the end user experience and limit their ability to access data contained in database tables by

Checkboxes Greyed Out in Microsoft Access
In a recent forum posting, Barbara wrote: I am using check marks as values for nine fields which are based on a query from two tables. The check marks are

Updating 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

Charitable Contributions Database
In a recent forum message, Darlene wrote: I have created an access database for a non-profit company that collects donations consisting household items to

Top Ten Frequently Asked Questions about SQL
Looking for advice on using the Structured Query Language? The About Databases SQL FAQ provides answers to the most frequently asked questions about SQL and

Backing Up Multiuser Databases
In a recent forum message, Jonas wrote: I have developed a database in Access 2003, designed as a typical frontend/backend setup as proposed for multi-user

Preparing to Upgrade to SQL Server 2008
Microsoft provides the SQL Server 2008 Upgrade Advisor (SSUA) to help you detect upgrade issues before they occur. This tool examines your SQL Server 2000 and

Top Five Things Beginners Need to Know About Databases
Just getting started with databases? Here's a rundown of the top things that I wish I knew before I got started in the field. These facts are guaranteed to make

Joins In Microsoft Access
In a recent forum message, Gary asked: I have a database which is Oracle, with an Access front end. I'm trying to determine if I can join multiple tables

Microsoft Access 2010: What's Coming with Office 2010?
Microsoft announced yesterday that the next release of the Office suite will occur in 2010. News out of Redmond indicates that this release will place a heavy

Tracing Database Activity with SQL Server Profiler
Traces allow you to track the specific actions performed against a SQL Server databases. They provide valuable information for troubleshooting database issues

Greyed Out Checkboxes in Microsoft Access
In a recent forum message, Connie wrote: I am using check marks as values for nine fields which are based on a query from two tables. The check marks are

User Level Security in Microsoft Access
User-level security is quite powerful. It allows you to control the types of data that a user might access (for example, prohibiting sales personnel from

Combining Query Results with SQL's UNION Statement
SQL’s UNION command allows you to combine the results of two or more database queries that are not necessarily linked through a database relationship. For

Changing Tab Location with VBA
In a recent forum message, Justin wrote: I currently have a form where you enter the steps required to make a product. The user would select the operation

Access 2007 Service Pack 2 (SP2) Released
Microsoft released Service Pack 2 for the Office 2007 Suite last week. In addition to numerous bug fixes and updates, this service pack provides the

SQL Joins Across Multiple Tables
In a recent forum posting, Kit2009 wrote: I read your tutorial on multi-table SQL joins. What I want to do, however, is to create a query where one of the

Contact Databases in Microsoft Access
In a recent forum message, Judy wrote: I am new to Microsoft Access. Love the tutorial on about.com. However, after importing my Excel spreadsheet, I do

What Are You Looking for in Access 2010?
I've been receiving a lot of e-mail about my recent blog post on Microsoft's pending release of Access 2010. Most of these have been thoughts about what

Using the bcp Utility to Import and Export Data
The bulk copy (bcp) command of Microsoft SQL Server provides you with the ability to insert large numbers of records directly from the command line. In addition

Calculating Totals in SQL
In a recent forum message, AK177 asks: Hi, I am trying to write SQL for a complex sum query. I have a dataset with many columns, including PRECIP

Beta Testing Begins for New “Program with PL/SQL” Certification Exam
Oracle recently announced the beginning of beta testing for the Program with PL/SQL Exam. This exam (#1Z1-144) is only $50 during the beta period and covers

Access 2000 and Windows XP
In a recent forum message, Job_Searching wrote: I have an XP system that is about 2+ years old. I used to work with Access 2000 on my old Windows 98 system.

k-means Clustering: Data Mining with the k-means Algorithm
k-means clustering is a data mining/machine learning algorithm used to cluster observations into groups of related observations without any prior knowledge of

Data Access Pages in Access 2007
In a recent forum posting, Andrew wrote: I need to create a web page that I can edit a MS Access 2007 database from. I understand that I need to use a Data

SQL Injection Tests
SQL Injection attacks pose tremendous risks to web applications that depend upon a database backend to generate dynamic content. In this type of attack,

Getting Started with Databases
In our Databases for Beginners section, we provide a series of articles introducing you to the basic principles of relational databases. You'll learn how to

Classroom Management Database in Microsoft Access
In a recent forum post, Sherald2000 wrote: I'm using the 2003 Classroom Management template converted to 2007. Everything works fine, but I do not

Recurring Billing Database
In a recent forum message, Marilena wrote: I have created a database for new orders and recurring invoicing. The problem is I've tried many ways and I

Wrestling Database
In a recent forum message, Russ wrote: I have been a professional Wrestling fan for many years and over that time collected thousands and thousands of

Export Data from Microsoft Access 2007 to Microsoft Excel
It’s often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel’s

Additions to Access Function Library: IsArray(), IsDate() and IsEmpty()
We've added information and examples of three new functions to our Microsoft Access Function Library. Check out the new pages on: IsArray() IsDate()

Creating Tables in Microsoft SQL Server
SQL Server databases rely upon tables to store data. In this tutorial, we explore the process of designing and implementing a database table in Microsoft

Variables in SQL Server
Selecting appropriate data types is one of the most important considerations when designing a SQL Server database. Choices you make in the database design phase

Primary Keys and Foriegn Keys in Databases
As you may already know, databases use tables to organize information. (If you don’t have a basic familiarity with database concepts, read What is a Database?)

Grouping Levels in Access Reports
In a recent forum message, Beth in Minneapolis asks: In the Report Wizard, Access only allows for 4 grouping levels. How can I get around that? Do you

Automating SQL Server Administration with SQL Server Agent
SQL Server Agent allows you to automate a variety of administrative tasks. In this tutorial, we walk through the process of using SQL Server Agent to

Microsoft Access Mailing Lists and Form Letters
One of the most common uses of a Microsoft Access database is generating labels for mass mailings. In this tutorial, we examine the process of creating mailing

Validation Rules in Microsoft Access
In a recent About Databases forum message, me_udi asks: I tried these validation rules in Access: 1) Validating an e-mail address: Is Null OR ((Like

Mailing Lists in Microsoft Access
One of the most common uses of a Microsoft Access database is generating labels for mass mailings. In this tutorial, we examine the process of creating mailing

Maximum Size of Access Forms
In a recent message board post, Joel from Texas wrote: I'm trying to create an Access Form to add data to a database that contains 12 tables, and each table

Selecting a Database
Database management systems (or DBMSs) can be divided into two categories -- desktop databases and server databases. Generally speaking, desktop databases are

Creating a SQL Server Database Maintenance Plan
Database Maintenance Plans allow you to automate many database administration tasks in Microsoft SQL Server. You can create maintenance plans using an easy

Automatically Transferring Data Between Microsoft Access Tables
In a recent forum message, Sam wrote: I am fairly new to Microsoft Access and need to create a database for tracking the progress of students submitting

Marching Band Database
In a recent forum message, TGDavidson wrote: Setting up an Access 2007 database to track fundraising for a HS marching band (I didn't duck fast enough). In

Comparing Microsoft SQL Server 2008 Editions
SQL Server 2008 is the latest release in Microsoft’s enterprise relational database platform series. In this substantial upgrade, they've packed the new

Additions to Access Function Library: IsError(), IsNull() and IsNumeric()
We've added information and examples of three new functions to our Microsoft Access Function Library. Check out the new pages on: IsError() IsNull()

E-mail Data Collection with Microsoft Access
Microsoft Access allows you to collect information from individuals and update your database automatically based upon their replies. Access includes a wizard

Common Data Between Tables
In a recent forum message, Polyspace wrote: I have two two tables with data that has one variable in common. After pulling the required data from the

Linking a Stored Procedure Recordset to a Table
In a recent forum message, Raul Lopez wrote: I have a recordset returned from a stored procedure. I have a table that I need to link the column of the

Choosing the Correct Edition of Microsoft Office for Your Needs
There are at least eight different versions of the Microsoft Office suite, making it difficult to choose the correct one for your needs. If you choose a

Binary Data Type
In a recent forum message, Gerald wrote: I am working with an existing database that has a field defined as 'data type = binary(8). The field in existing

Disaster Preparedness with SQL Server 2008
After completing the process of installing and configuring Microsoft SQL Server, any database administrator is entitled to sit back and take a well-deserved

Creating a Snapshot Replication Distributor
SQL Server's snapshot replication technology allows you to automatically transfer information between databases to keep them synchronized. In this article, we

Keeping Access Database Connections Open
In a recent forum message, Richard Martin wrote: I have a program which consists of functions within a dll which sits on another package. I use an Access

Backing up a SQL Server Database
One of the major advantages that enterprise-class databases offer over their desktop counterparts is a robust backup and recovery feature set. Microsoft SQL

Writing SQL Queries in Access 2007
In a recent forum message, BooIsMyCat wrote: I have a table named tblantennadatanodups that has fields tagid, date, time and number of fish. I

SQL Server Transaction Log Management
The transaction log plays a critical role in a SQL Server database: it maintains an ongoing record of database activity crucial for the restoration of recent

NOT NULL Constraints in Microsoft SQL Server
NOT NULL constraints in Microsoft SQL Server allow you to specify that a column may not contain NULL values. When you create a new NOT NULL constraint on a

Third Normal Form
In a recent forum message, Wolfman wrote: We have a large form based application. The form has several sections which the user fills in and they have a vast

VBA Causes Microsoft Access to Crash?
In a recent forum message, Jay S wrote: Does anyone know why MS Access closes whenever you try to work in the VBA module? I tried reinstalling it but

Relationships in Microsoft Access 2007
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don't

Access 2007 on the Web
In a recent forum message, Sam Eskridge wrote: I have an Access 2007 database for student registration and tracking that would ideally be run from the web

Snapshot Replication in Microsoft SQL Server
SQL Server's snapshot replication technology allows you to automatically transfer information between multiple SQL Server databases. This technology is a great

What's New in Access 2010?
Microsoft recently released the beta version of Office 2010, including Microsoft Access 2010. This release places a heavy emphasis on web services, filling a

Tablet PC Pen Input to Microsoft Access
In a recent forum message, CitiPool wrote: I am creating electronic medical records application for a small medical office using Access 2007. I found out

Publishing an Access Database Online
In a recent forum message, LModern wrote: I would like to make an Access database (less than 10,000 entries) available online for editing by 5-10 users. I

Auditing in SQL Server 2008
SQL Server's auditing capabilities were significantly upgraded with the release of SQL Server 2008, to the great relief of database administrators and

Relationships Between Database Tables
In a recent forum message, DDKitty wrote: Can anyone break down how to create relationships with tables? I've read googled, binged and watched demo's on it,

Database Normal Forms
If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you Is that database normalized?

Copying Access Forms
In a recent forum message, DajuParker wrote: I have created a complex form in Access under a particular table. How can I copy/duplicate that form into a

Database Certification Spotlight: OCA
The Oracle Certified Database Administrator (OCA) credential is an entry-level certification designed to serve as a stepping-stone to the more advanced Oracle

SQL Server Recovery Models
In the event of a database failure, you have the most flexibility restoring databases using the full recovery model. In addition to preserving data

Preventing Rounding in SQL Server
In a recent forum message, jyoung100 wrote: I am using the sum function in Microsoft SQL Server to add 3.0 and 1.5, but the answer keeps coming out as 5.

ZIP Code Database in Microsoft Access
This free Access database of ZIP codes provides database designers with a valuable tool to assist in mapping ZIP codes to a city/state pair and even provides

Preventive Maintenance Database
In a recent forum message, Dakota wrote: I track equipment preventative maintenance schedule. We usually do a PM on the equipment every 30 days. I am

Database Constraints
SQL Server constraints allow you to enforce rules in your database. These rules may affect business logic, database integrity and/or table structures. Each one

Medical Clinic Database
In a recent forum message, John wrote: Hello all. I am new to this forum. Thank you in advance for your responses. I am volunteering at a Free Medical

Counting Records in SQL
The COUNT() function in SQL allows you to count database records based upon a variety of criteria. You can use it to count all records in a table, count unique

Normalizing Microsoft Access Databases
If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you Is that database normalized?

Printing Database Records
In a recent forum message, Don wrote: I am in the process of creating a client intake database based upon an extensive 5-page form that covers everything

Getting Started with Data Mining
Data mining products are taking the industry by storm. The major database vendors have already taken steps to ensure that their platforms incorporate data

Drop-down Menus on Database Forms
In a recent forum message, Kimmy wrote: Can anyone help me with creating drop down menus on forms that pull from tables with corresponding information

SQL Server Stored Procedures
Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable

Free Personal Budgeting Database
This personal financial planning database allows you to track income and expenses against your budget targets using Microsoft Access. Download the Microsoft

SQL Injection Attacks Against Web Applications
The vast majority of databases in use today have some form of web interface, allowing internal and/or external users easy access through familiar browser

Passwords for Microsoft Access Databases
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of

Free Online SQL 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

Database Client Synchronization
In a recent forum message, kpalser wrote: I need some recommendations for software to develop a database with good client GUI synchronization, i.e: a

Storing Binary Files in an Access Database
Microsoft Access allows you to include attachments in database tables. You may store photos, graphics, documents and other files in your Access database using

Declarative Management Framework in Microsoft SQL Server 2008
SQL Server's Declarative Management Framework (DMF) allows you to proactively regulate the configuration and operation of your SQL Server databases. You may

SQL Server Developer Permissions
In a recent forum message, William Rich wrote: I'm a Visual Basic / SQL Server developer who recently changed jobs. In the past, the SQL Server DBA would

Regular Expressions in SQL Server Queries
You may often need to create a SQL Server query that performs inexact pattern matching through the use of wildcard characters. The use of wildcards allows you

Data Mining Applications in Business
Through the use of automated statistical analysis (or data mining) techniques, businesses are discovering new trends and patterns of behavior that

CASE Statements in SQL Queries
SQL includes a CASE statement that allows you to return varying results based upon the evaluation of expressions. You can use a CASE statement anywhere within a

Creating 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

Help With Database Joins
In a recent forum message, Mark wrote: Hope someone can offer some advice here, I'm starting out in RDMS's and learning some SQL at the moment. All going

Query Views in Microsoft Access
In a recent forum message, Carmen asks: How can you make a query give you the results in a form rather than a data-sheet window? Do you have any advice

Count Database Records Matching Your Criteria
SQL provides the COUNT function to retrieve the number of records in a table that meet given criteria. We can use the COUNT(*) syntax alone to retrieve the

Conflict Resolution in Database Replication
In a recent forum message, Renu wrote: How can I resolve conflicts between two different subscribers? For example: Subscriber 1- enters a row in 'info'

Manual Policy Verification with DMF
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

Access Ribbon Troubleshooting
In a recent forum message, Climora wrote: After obtaining Access 2007, I ran my Access 2000 applications with 2007. Everything ran fine, except that the new

Timestamping Microsoft Access Database Records
There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It's

SQL FAQ
Looking for advice on using the Structured Query Language? The About Databases SQL FAQ provides answers to the most frequently asked questions about SQL and

Access 2003 Database Backup
In a recent forum message, Mr. H wrote: I have developed a substantial database for work but am really inexperienced having learned what I need to get a job

Top 5 Things Beginners Need to Know About Databases
Just getting started with databases? Here's a rundown of the top things that I wish I knew before I got started in the field. These facts are guaranteed to make

UNION Queries in SQL
SQL's UNION command allows you to combine the results of two or more database queries that are not necessarily linked through a database relationship. For

The ACID Model of Database Transactions
The ACID model is one of the oldest and most important concepts of database theory. It sets forward four goals that every database management system must strive

SQL Server 2008 Upgrade Advisor
Microsoft provides the SQL Server 2008 Upgrade Advisor (SSUA) to help you detect upgrade issues before they occur. This tool examines your SQL Server 2000 and

Compact and Repair Access Databases
Over time, Microsoft Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in

Importing Data with SQL Server Integration Services (SSIS)
SQL Server Integration Services (SSIS) allows you to import and export data from SQL Server databases using an easy-to-navigate graphical interface. It

Form Doesn't Exist in Microsoft Access
In a recent forum message, mbocho wrote: I created a new form in design view. Access gave it the name 'Form1'. Then I added a control in the form (a combo

Relationships in Access 2007
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don't

PCI DSS Database Security
The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit or

Using the INSERT INTO Statement
In a recent forum message, VTHOME2009 wrote: I would like to use the INSERT INTO SQL statement to export data from a temporary table in Access to the

Securing an Access Database
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of

Forms in Microsoft Access 2007
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn't always an appropriate tool for every data entry situation.

Database Professional Development
In a recent forum message, Scottees3 wrote: I am a basic MS Access user with decent VB and SQL skills as well. I am interested in moving my database skills

Searching through MS Access Records
In a recent forum message, GBENJAMAR wrote: I am new to ms access and have been having a some challenge with getting my search record combo box to work.

Storing Outlook Contacts in an Access Database
In a recent forum message, Trish wrote: I work for a medical facility in a specialized area and we provide services to an array of companies in the area.

Relational Database Normal Forms
If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you Is that database normalized?

SQL Server 2008 R2
With the May 2010 release of SQL Server 2008 R2, many database professionals wondered why Microsoft didn't increment the product's name to SQL Server 2010.

Multiple Row Subqueries
In a recent forum message, macvidur asked: In Multiple row sub queries we use IN, ANY and ALL. ANY and ALL both seem to compare each and every value in the

Working with SQL Queries in Microsoft Access
Did you know that you can view and edit the SQL statements that drive every Microsoft Access database query? In this article, we take a look at the process of

Sharing Access Databases Online
In a recent forum message, Norma asked: I own a small business (staffing agency) run out of my home. I have one associate besides myself. We are using MS

Adding Pictures to an Access Database
In a recent forum message, Andrew wrote: I have been trying to achive something for some time now and was wondering if anyone could help out. I have a

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

Multivalue Fields in Reports and Forms
In a recent forum message, Sam Eskridge wrote: Can anyone suggest some good references on how to use multivalue fields on reports and forms in an Access

Microsoft SQL Server Agent Tutorial
SQL Server Agent allows you to automate a variety of administrative tasks. In this tutorial, we walk through the process of using SQL Server Agent to

Introduction to Database Keys
As you may already know, databases use tables to organize information. (If you don't have a basic familiarity with database concepts, read What is a Database?)

Access 2010 Tour
If you're switching to Microsoft Access 2010 from an earlier version, you're bound to immediately notice some changes. If you've been using Access 2007, the

Counting and Grouping Data in Microsoft Access
In a recent forum message, luzhen 88 wrote: I have a MS Access Database file. In my query, I would like to group all of the Company Names and count them. I

Export Data from an Access 2007 Database to an Excel Spreadsheet
It's often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel's

Identifying a Database
In a recent forum message, nybor_yam wrote: I'm a recent grad and have been trying to help (volunteer position to help gain experience) a division of the

Using SQL Server Table Designer
SQL Server databases rely upon tables to store data. In this tutorial, we explore the process of designing and implementing a database table in Microsoft

Adding Tables to a Split Access Database
In a recent forum message, carmencha wrote: I have a database application developed with Access 2007. I have split the database application and latter,

Exporting Data from Access 2010 to Excel
It's often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of

PDF Reporting with Microsoft Access
Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access

Splitting Database Tables By Year
In a recent forum message, Michael wrote: I need to create a partitioned table per year and per month, something like this: 2010 January

Showing or Hiding Tabs in Access 2010
Access 2010 uses the tabbed document format found in other Microsoft Office products. In some cases, you may wish to hide these tabs to change the look and feel

Default Yes/No Values in Microsoft Access Databases
In a recent forum message, CARMENCHA asks: I am using Access 2007. I have defined a field as Yes/No and I need to have this field default to Yes (e.i.

SQL Server Table Partitioning
Looking to optimize the performance of your SQL Server database? If your database contains very large tables, you may benefit from partitioning those tables

SQL Help: Learning SQL for Beginners
Most large-scale databases use the Structured Query Language (SQL) to facilitate user and administrator interactions. This language offers a flexible interface

How Important is Database Design Theory?
In a recent forum message, Amy wrote: i) How important is it to have a good knowledge and understanding of conceptual database design? ii) Do you think

Isolation Modes in SQL Server 2008
Normally, it's best to allow SQL Server to enforce isolation between transactions in its default manner; after all, isolation is one of the basic tenets of the

Editions of Microsoft SQL Server 2008
SQL Server 2008 is the latest release in Microsoft's enterprise relational database platform series. In this substantial upgrade, they've packed the new

Formatting Access Reports in Excel
In a recent forum message, Raul asked a question about exporting Access reports to Excel while preserving formatting. Are you interested in this topic?

Functions vs. Stored Procedures
SQL Server user-defined functions and stored procedures offer similar functionality. Both allow you to create bundles of SQL statements that are stored on the

PHP and SQL
In a recent forum message, Msugar wrote: I am trying to use php coding inside and HTML page to input data on screen using the following HTML syntaxes:

Creating an Access 2010 Database from a Template
Microsoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. In this tutorial, we'll walk

Database Normalization Example
In a recent forum message, Tbruwer wrote: I am having a problem understanding how database normalization works. I have an example database table from excel

Using E-mail to Update an Access Database
Microsoft Access allows you to collect information from individuals and update your database automatically based upon their replies. Access includes a wizard

Database Error Message
In a recent forum message, Cimoka asks: Does anyone knows what this error message refers to: Microsoft Visual Basic ERROR ACCESSING FILE. NETWORK

Creating Relationships in Access 2010
The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users

Data Entry Forms
In a recent forum message, Nayer wrote: I have a data entry form with several boxes, one Save and one Exit button, when I save the data, it clears all the

Microsoft Office 2010 Editions
There are many different versions of the Microsoft Office suite, making it difficult to choose the correct one for your needs. If you choose a version that's

SQL Server Business Continuity and Disaster Recovery
After completing the process of installing and configuring Microsoft SQL Server, any database administrator is entitled to sit back and take a well-deserved

IT System Inventory Database
This IT Inventory database template for Microsoft Access 2007 will help you organize your business' computer inventory. It includes tables for tracking

SQLCMD: SQL Server at the Command Line
Microsoft SQL Server provides users with a variety of rich graphical user interfaces to retrieve and manipulate data and configure SQL Server databases.

Create a Microsoft Access 2010 Database from Scratch
In an earlier article, we reviewed the process for creating an Access database from a template. While this is certainly an agreeable, easy approach to building

SQL Server Publications
Once you've created a publisher/distributor, you can then use SQL Server Management Studio to create publications that subscribing servers may receive. Each

What is Referential Integrity?
Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table,

Microsoft Access File Error
In a recent forum message, Cimoka wrote: Does anyone knows what this error message refers to: Microsoft Visual Basic ERROR ACCESSING FILE. NETWORK

SQL Server Subscriptions
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

SQL Server Alerts
SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour

SQL Server Certifications: MCTS
The Microsoft Certified Technology Specialist program provides database professionals with an opportunity to showcase their SQL Server skills. If you'd like to

Password Protecting an Access 2010 Database
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of

Displaying an Hourglass in Microsoft Access
In a recent forum message, CarmenCha wrote: I have an application on Access 2007. How do I start an hourglass at the beginning of a BVA program? I have

SQL Server Auditing
SQL Server's auditing capabilities were significantly upgraded with the release of SQL Server 2008, to the great relief of database administrators and

Using Expression Builder in Microsoft Access 2010
Have trouble remembering function names or arguments in Microsoft Access 2010? We all do! Access 2010's Expression Builder is a great tool that walks you

Default Values in SQL Server
DEFAULT constraints allow you to specify a value that the database will use to populate fields that are left blank in the input source. They're a replacement

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

Concatenating Fields in Excel or Access
In a recent forum message, Nayer_sh wrote: I have 2 fields that need to be merged, one is Date/Time type with short time format (3:17), I don't see it as

SQL Server NOT NULL Constraints
NOT NULL constraints in Microsoft SQL Server allow you to specify that a column may not contain NULL values. When you create a new NOT NULL constraint on a

SQL Server Full Recovery Model
In the event of a database failure, you have the most flexibility restoring databases using the full recovery model. In addition to preserving data

Merging Excel Spreadsheet Columns
In a recent forum message, BUCLEX wrote: I have two spreadsheets that have two similar columns of data that I would like to merge into one. For instance,

SQL Server Log Shipping
Log shipping allows you to keep two SQL Server databases synchronized for high availability. In a log shipping relationship, the primary server transfers copies

Persons and Organizations in a Client Database
In a recent forum message, DanTee wrote: I am in the process of designing an MS Access database for a law office that has CLIENTS that may be a PERSON or an

Grouping SQL Query Results
You may use basic SQL queries to retrieve data from a database but this often doesn't provide enough intelligence to meet business requirements. SQL also

Printing Mailing Labels with Access 2010
One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft

Google Contacts Database Schema
In a recent forum message, Pytrex asks: I'm new to DB design and was wondering about how google created their contacts to allow unlimited Phone numbers,

Counting Database Records
The COUNT() function in SQL allows you to count database records based upon a variety of criteria. You can use it to count all records in a table, count unique

Microsoft Access Database File Format
The release of Access 2007 brought us a new file format. The MDB database files we've known for over a decade are now slated to become historical relics. While

Converting a Microsoft Access Database to SQL Server
Is your Access database growing too large or unwieldy? Perhaps you need to allow more robust multiuser access to the database? Converting your Access

Tough Database Question
In a recent forum message, XANARCHY wrote: I have a database in Microsoft Access. I want to know how to look up a singular datum from a reference table

SQL Server Change Data Capture
With the release of SQL Server 2008, Microsoft included Change Data Capture (CDC) functionality for the first time. This highly anticipated feature provides

Splitting an Access 2010 Database
You might wish to share data with users in your organization who may, in turn, wish to create their own forms and reports. While you may want them to have the

Text Size in Access Forms
In a recent forum message, Nayer asked: I have a form which has several text boxes for data entry. What is the maximum size that text box can hole, I mean

Website Login Process
In a recent forum message, GiftDragon asks: Im new to database an would like to understand how large websites like Facebook and Google handle login for

Regular Expressions in SQL Server Databases
You may often need to create a SQL Server query that performs inexact pattern matching through the use of wildcard characters. The use of wildcards allows you

Data Mining for Business Intelligence
Through the use of automated statistical analysis (or data mining) techniques, businesses are discovering new trends and patterns of behavior that

Password Security in Microsoft Access
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of

Household Budget Database
This personal financial planning database allows you to track income and expenses against your budget targets using Microsoft Access. Download the Microsoft

Access 2010 Backups
Protecting the integrity of information stored in a database is one of the most important responsibilities of a database administrator. One task associated with

Using the SQL CASE Statement
SQL includes a CASE statement that allows you to return varying results based upon the evaluation of expressions. You can use a CASE statement anywhere within a

What is a Database Parameter?
In a recent forum message, praepipossum wrote: I have stupidly deleted a record in a table. Now when I open the form to enter data in that table, I am asked

Adding Timestamps to Access 2010 Databases
There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It's

Task and Meeting Management Database
The Meeting Tracker sample database for Microsoft Access 2007 allows you to track all of the details associated with your meetings. It includes the ability to

Trouble Ticket Database
Looking for a database to track service calls for your business? Microsoft offers a free Service Call Management Database Template for users of Access 2003 (or

SQL Frequently Asked Questions
Looking for advice on using the Structured Query Language? The About Databases SQL FAQ provides answers to the most frequently asked questions about SQL and

Manual Enforcement of SQL Server Policies
The Declarative Management Framework allows you to manually reconfigure policy targets so that they comply with some policies. It is important to note, however,

DISTINCT Queries in SQL
The DISTINCT keyword in SQL allows you to select only those records that contain unique values for the columns requested in a SELECT statement. Duplicate values

Free Practice Test for Microsoft MCTS Exam 70-433
Free Practice Test for Microsoft MCTS Exam 70-433

Using Access for a Complex Database
Using Access for a Complex Database

UNION Database Queries in SQL
SQL's UNION command allows you to combine the results of two or more database queries that are not necessarily linked through a database relationship. For

Range Queries in SQL Server
In a recent forum message, PRANAV28 wrote: I have to select data between a date range of 01-09 to 28-02 where the financial year will vary (e.g. financial

bcp: SQL Server Command Line Import/Export
The bulk copy (bcp) command of Microsoft SQL Server provides you with the ability to insert large numbers of records directly from the command line. In addition

Adding Images to a Database
In a recent forum message, Frank wrote: I was wondering if anyone could assist by advising the best way of producing a database which would display an image

Sample Access Database: Countries, Provinces and Cities
This Microsoft Access sample database provides tables containing information on the world's countries, cities and provinces. It is used to illustrate examples

Fixing a Damaged Access Database
Over time, Microsoft Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in

PCI DSS Database Security Requirements
The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit or

Should I Normalize My Database?
Database normalization is one of the sacred cows of application development. Every undergraduate programming course you've taken or book you've read likely

Data Entry with Access Forms
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn't always an appropriate tool for every data entry situation.

Storing Images in a Database
In a recent forum message, Frank asked: I was wondering if anyone could assist by advising the best way of producing a database which would display an image

Error Including PDF Files In An Access Database
In a recent forum message, CES1949 wrote: I have a 2007 Access database running on a standalone desktop (ie not networked) which includes an OLE field to

Stored Procedures in Microsoft SQL Server
Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable

Database Normal Forms
If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you Is that database normalized?

Password Protection for Split Access Databases
Password Protection for Split Access Databases

Recording Elapsed Time in an Access Database
Recording Elapsed Time in an Access Database

Setting Up Alerts in SQL Server
Setting Up Alerts in SQL Server

Creating SQL Server 2008 Accounts
Creating SQL Server 2008 Accounts

Securing SQL Server Connections
Securing SQL Server Connections

Sorting List Boxes in Access Forms
Sorting List Boxes in Access Forms

Free Practice Test for Microsoft MCTS Exam 70-432
Free Practice Test for Microsoft MCTS Exam 70-432

Primary and Foreign Keys in Databases
Primary and Foreign Keys in Databases

Modifying an Expense Tracking Database
Modifying an Expense Tracking Database

Access 2010 Product Walkthrough
Access 2010 Product Walkthrough

SQL Server Database Maintenance
SQL Server Database Maintenance

Saving Access Reports as PDF Files
Saving Access Reports as PDF Files

Database Relationships Explained
Database Relationships Explained

Working with Access 2010 Tabs
Working with Access 2010 Tabs

Table Partitioning in SQL Server
Table Partitioning in SQL Server

Movie Collection Database
Movie Collection Database

Charitable Contributions Database
Charitable Contributions Database

SSMS Custom Folder Add-In
SSMS Custom Folder Add-In

Pivot Tables in Google Spreadsheets
Pivot Tables in Google Spreadsheets

Adobe Livecycle Designer and Microsoft Office
Adobe Livecycle Designer and Microsoft Office

Pivot Tables in Excel 2010
Pivot Tables in Excel 2010

Introduction to Pivot Tables
Introduction to Pivot Tables

Printing Barcodes
Printing Barcodes

Learning SQL Commands: A Collection of Tutorials and Introductions
Learning SQL Commands: A Collection of Tutorials and Introductions

SQL Server Versions
SQL Server Versions

What File Format Does Microsoft Access Use?
What File Format Does Microsoft Access Use?

Transferring Data Between Access and Excel
Transferring Data Between Access and Excel

SQL Server 2008 Replication
SQL Server 2008 Replication

Sending E-mail from a Microsoft Access Form
Sending E-mail from a Microsoft Access Form

Microsoft Access 2010 Fundamentals
Microsoft Access 2010 Fundamentals

Access Error: The Search Key is Not Found in Any Record
Access Error: The Search Key is Not Found in Any Record

SQL Server 2008 Database Auditing
SQL Server 2008 Database Auditing

Access 2010 Database Passwords
Access 2010 Database Passwords

What is an MDB File?
What is an MDB File?

Access 2010 Database Templates
Access 2010 Database Templates

MAX and SUM Aggregate Functions
MAX and SUM Aggregate Functions

Converting a Database to Access 2010
Converting a Database to Access 2010

SQL Server 2008 Log Shipping
SQL Server 2008 Log Shipping