Databases Sitemap - Page 1 2016-09-26

Microsoft Access
The Net’s best collection of Microsoft Access resources from your About.com guide to Databases.

Learn the Fundamentals of Microsoft Access
Want to learn how to use Microsoft Access? Find out about the fundamentals with this introduction.

Access 2010 FAQ - Front-End and Back-End Database Components
Want to share data on Microsoft Access 2010 with others, but make it so they can't change your interface? This step-by-step article explains how.

Start the Database Splitter wizard
From the Tools menu, choose Database Utilities and then Database Splitter, as shown in the image above. If you haven't used the Database Splitter wizard before, you may see a message stating

Split the database
Next, you'll see the wizard screen above. It warns you that the process may take a long time, depending upon the size of the database. It also reminds you that this is a risky procedure and that you should make a backup of your database before proceeding. (This is certainly good advice. If you haven't already made a backup, do it now!) When you're ready to begin, click the

Choose a location for the back end database
You'll next see the familiar windows file selection tool, shown above. Navigate to the folder where you wish to store the back-end database and provide the filename you wish to use for this file. As a reminder, the back-end database is the shared file that will contain the data used by all users.

Database splitting complete
After a period of time (which varies depending upon the size of your database), you'll see the message above. When you see this, the splitting operation is complete. Your back-end database is now stored using the name you provided. The original MDB file contains the front-end portion of the database. Congratulations, you're done!

Data Mining and Data Warehousing
The Net’s best collection of data mining and data warehousing links from your About.com guide. From data mining tutorials to data warehousing techniques, you’ll find it all!

Microsoft SQL Server
The Net’s best collection of SQL Server links from your About.com Guide to Databases.

Entity-Relationship Diagram Definition
An entity-relationship (ER) diagram is a specialized graphic that illustrates the relationships between entities in a database.

Building an Access Database in Office 365
Looking for an easy way to move your Microsoft Access database to the cloud? Microsoft's Office 365 service provides a central location.

Database Dependency: Functional, Transitive, Mutivalued
Database dependencies are a topic that often confuses both students and database professionals alike. Fortunately, they are not that complicated.

Using bcp to Import and Export Data From SQL Server
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.

Building an Access Database From the Ground Up
In this series of Microsoft Access tutorials, we follow the database admins for Patrick's Widgets as they build a Microsoft Access database.

Recommended Books on SQL (Structured Query Language)
Looking for a book to help you get started with Structured​ Query Language? Need a new reference book for your shelf? Check out my favorite SQL books.

Install Northwind Sample Database in Microsoft Access
The Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it.

Inner Joins in SQL - Joining Data from Multiple Tables
You can use SQL JOIN statements to combine data from three or more tables. Here you'll see how to accomplish this goal for an inner join.

The Basics of Database Normalization
Database normalization can save storage space and ensure the consistency of your data. Learn the basics in this introductory article.

Facts vs. Dimensions: Business Intelligence
Facts and dimensions form the core of any business intelligence effort. In this article, we look at the development and use of facts and dimensions.

What Is Referential Integrity? - Definition & Examples
Referential integrity is a database concept that ensures that relationships between tables remain consistent. Find more information here.

Primary Key Definition - Databases
What is a primary key? What is it for and how is it used? This article provides a definition of the term as well as examples.

Before You Buy a Database
Buying a database product is a serious decision. Do you have all the information you need?

Deleting Data from an SQL Table
The SQL DELETE command allows the removal of some or all of the data stored in a relational database table.

We Talk About MS Access, SQL Server and More
We review database products such as MS Access, SQL Server, FileMaker Pro and more. We'll show you how databases can help improve your business.

Spreadsheets vs. Databases
Should you use a spreadsheet or a database? Learn more in this article!

Microsoft Access Database Templates
These database templates will help you kick-start your database development. Why reinvent the wheel when you can begin your project using a pre-built template?

Microsoft Access Function Library
Detailed descriptions of functions available within Microsoft Access. Each entry contains the function's purpose, usage, return values, examples and special cases.

Building an Access Database From the Ground Up
In this series of ten Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.

IBM DB2 Database Links
The Net’s best collection of IBM DB2 links from your About.com Guide to Databases.

dBase Database Links
The Net's best collection of dBase links from your About.com Guide to Databases.

FileMaker Pro
The Net’s best collection of FileMaker Pro links from your About.com Guide to Databases.

Sample Microsoft Access Databases
Need a database to help get you started? These sample databases can jump-start your database development project.

Microsoft Access Tutorials
Looking to learn about Microsoft Access? This collection of tutorials includes materials for novices and advanced users alike.

Visual Basic for Applications (VBA)
Visual Basic for Applications (VBA) provides developers with the means to extend their Microsoft Access databases programatically.

Database Administration
The Net’s best collection of database administration links from your About.com guide: SQL Server, Oracle, FoxPro, Paradox, Sybase and more.

Careers in Databases
Database Careers - Jobs for database administrators, designers, technicians and more!

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

Database Training
Collection of the best database training resources on the Internet! Learn about Microsoft SQL Server, Oracle database products, the Structured Query Language and more!

Database Development
The Net’s best collection of database development links from your About.com guide. Visual Basic, Visual Studio, Visual Office, Java and more!

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

Other Databases
There are tons of other databases on the market. This section contains collections of resources related to some of the more popular ones.

Software and Book Reviews
Your About.com Guide to Databases reviews and discusses popular database products and books. These range from

Database Security Issues
The Net’s best collection of database security links from your About.com guide. Access controls, security measures, identification & authentication and more!

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

Database Design
The Net’s best collection of database design links from your About.com guide.

Structured Query Language (SQL)
The Net’s best collection of SQL links from your About.com guide. Find an SQL training course, SQL reference book or have your questions answered!

Basic SQL Tutorials
Getting started with SQL? These tutorials will help you get off to a running start with the Structured Query Language.

Advanced SQL Topics
Looking for more advanced SQL knowledge? This collection of tutorials will help you with more complex SQL questions.

NoSQL Databases
NoSQL databases abandon the relational model in favor of the key/value store approach where the database uses a simple hash function to assign each key/value pair to a database server for later retrieval. NoSQL does not provide transactional functionality but it does allow for the efficient storage and retrieval of simple unstructured information.

Exact Numeric Data Types in SQL Server
The exact numeric data types are the most common SQL Server data types used to store numeric information. They include integers (int), big integers (bigint), tiny integers (tinyint), small integers (smallint), decimal and numeric values.

Binary Data Types in SQL Server
Binary data types allow you to store any type of binary data, including entire files of up to 2GB. They include binary, varbinary, image and bit.

Character String Data Types in SQL Server
Character string data types are used to store text values in Microsoft SQL Server databases.

HIPAA Compliance (Privacy and Security)
The Health Insurance Portability and Accountability Act of 1996 (HIPAA) places a large regulatory burden on organizations that deal with certain types of health-related information. We're now only a couple of weeks away from the compliance deadline for the Security Rule. Are you ready for April 21st?

Adding Tables to Your Database
In Part 6 of our Building an Access Database From the Ground Up series, well build the tables necessary to implement the relational structure developed in Part 4 that builds upon the Patricks Widgets scenario from Part 3.

Introducing Pivot Tables in Google Docs
Pivot tables provide a powerful data analysis tool embedded within your current spreadsheet software. They offer the ability to summarize data without the use of a relational database or aggregate functions. Instead, they provide a graphical interface that allows users to create customized reports within a spreadsheet by simply dragging and dropping data elements to the desired columns or rows.

Pivot Table Source Data
Begin by opening Google Docs and navigating to the source file you wish to use for your pivot table. This data source should contain fields related to your analysis and enough data to provide a robust example. In this tutorial, we use a sample student course registration database. If you would like to follow along, you may access the sample document and use it as we walk through creating a pivot table step by step.

Create Your Pivot Table
Once you've opened the file, select Pivot Table Report from the Data menu.

Select the Target Value for the Pivot Table
Pivot tables provide a powerful data analysis tool embedded within your current spreadsheet software. They offer the ability to summarize data without the use of a relational database or aggregate functions Instead, they provide a graphical interface that allows users to create customized reports within a spreadsheet by simply dragging and dropping data elements to the desired columns or rows. In this tutorial, we examine the process of creating a pivot table in Google Spreadsheets.

Select the Columns and Rows for Your Pivot Table
You will now have a new worksheet containing an empty pivot table. At this point, you should select the columns and rows you would like to include in the table, depending upon the business problem you are trying to solve. In this example, we will create a report that shows the enrollment in each course offered by the school over the past few years.

Create a Job Step
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 create and schedule a job that automates database administration.

Create a SQL Server Agent Job
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 create and schedule a job that automates database administration.

Switch to SQL Server Management Studio
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 create and schedule a job that automates database administration.

Schedule your SQL Server Agent 2012 Job
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 create and schedule a job that automates database administration.

View the Job Steps
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 create and schedule a job that automates database administration.

Configuring SQL Server Agent 2012
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 create and schedule a job that automates database administration.

What is the Definition of a Determinant in a Database?
What is a determinant? Find out here!

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

What is an Isolation in a Database?
What is isolation? Find out here!

Microsoft Access 2010 Fundamentals
Are you overwhelmed by the large quantities of data that need to be tracked in your organization? Perhaps you're currently using a paper filing system, text documents or a spreadsheet to keep track of your critical information. If you're searching for a more flexible data management system, a database might be just the salvation you're looking for and Microsoft Access 2010.

Primary and Foreign Database Keys
As you may already know, databases use tables to organize information. Each table consists of a number of rows, each of which corresponds to a single database record. So, how do databases keep all of these records straight? Its through the use of keys.

Text Formulas in Microsoft Access 2013
Most people are adept at using numeric formulas because they are very similar between Microsoft Excel and Microsoft Access. However, text formulas are a little more complex, partly because people do not understand what they are or how to use them.

- By Category
An index of categories in the

Choose a Database Name
After you select a database template, a new pane will appear in the right portion of the screen, as shown in the image above. You must now name your Access database. You may either use the name suggested by Access or type in your own name. If you'd like to change the database location from the default, click the file folder icon to navigate through the directory structure.

How to Create a Microsoft Access Database Using Templates
In this tutorial, we'll walk through the process of creating an Access database using the templates available from Microsoft Office 2010.

Open Microsoft Access 2010 to the Getting Started Screen
Once you've selected a template, open Microsoft Access. If you already have Access open, close and restart the program so you're viewing the opening screen, as shown in the image above. This will be our starting point for creating our database.

Select the Template Source
Next, choose the source of your template from the left pane, as shown in the image above. If you wish to use a template on your local system, click

Begin Working With Your Database
That's all there is to it! After a brief delay, Access will open your new database, as shown in the image above. You can either begin entering data immediately by typing in the first open cell or you can explore the features of the template using the navigation pane on the left side of the screen.

Converting an Excel Spreadsheet to an Access 2013 Database
Let us walk you through the process of converting your Excel spreadsheet to a flexible Access 2013 database.

Create a new Access 2013 database
Unless you have an existing database that you use to store contact information, you're probably going to want to create a new database from scratch. We're not going to use a wizard to help us this time, we're going to do it by hand. Make sure that the

Begin the Excel Import Process
Next, click the External Data tab at the top of the Access screen and double-click the Excel button to begin the Excel import process. The position of this button is indicated by the red arrow in the image above.

Select the Source and Destination
Next, you'll be presented with the screen shown above. Click the Browse button and navigate to the file you'd like to import. Once you've located the correct file, click the Open button.

Select Column Headings
Often, Microsoft Excel users utilize the first row of their spreadsheet to provide column names for their data. In our example file, we did this to identify the Last Name, First Name, Address, etc. columns. In the window shown above, ensure that the

Create Any Desired Indexes
Database indexes are an internal mechanism that can be used to increase the speed at which Access can find information in your database. You can apply an index to one or more of your database columns at this step. Simply click the

Select a Primary Key
The primary key is used to uniquely identify records in a database. The easiest way to do this is to let Access generate a primary key for you. Select this option and press Next to continue. If you're interested in choosing your own primary key, you might want to read our glossary entries on keys for more information.

Name Your Table
You need to provide Access with a name to reference your table. We'll call our table

View Your Data
You'll see an intermediate screen asking you if you'd like to save the steps used to import your data. If not, go ahead and click the Close button. You'll then be returned to the main database screen where you can view your data by simply double-clicking on the table name in the left panel. Congratulations, you've successfully imported your data from Excel into Access!

How to Create an Adobe PDF File From an Access 2007 Database
Read this article on how to create an Adobe PDF file from an Access 2007 Database using a PDF plugin.

SQL Server Agent - Automating Database Administration
Read this tutorial to learn how to use the SQL Server Agent to create a job that automates database administration.

SQL Server Disaster Recovery
There are numerous threats to your data -- disk corruption, natural disaster, human error and server failure, among others. Is your disaster recovery plan sufficient to ensure your organization's interests are protected?

Database Backups
Microsoft SQL Server 2005 offers two primary database backup mechanisms -- full backups and differential backups. Read this article to weigh the costs and benefits of each. Page 2.

Transaction Log
There are numerous threats to your data -- disk corruption, natural disaster, human error and server failure, among others. Is your disaster recovery plan sufficient to ensure your organization's interests are protected? Page 3.

Schedule your SQL Server Agent 2014 Job
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 create and schedule a job that automates database administration.

Starting SQL Server Agent in SQL Server 2014
In this tutorial, we use SQL Server Agent to create and schedule a job that automates database administration.

Switch to SQL Server Management Studio
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 create and schedule a job that automates database administration.

Create a SQL Server Agent Job
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 create and schedule a job that automates database administration.

View the Job Steps
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 create and schedule a job that automates database administration.

Create a Job Step
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 create and schedule a job that automates database administration.

Creating Relationships in Access
Read this article with a step-by-step tutorial on creating database relationships by using Microsoft Access.

Retrieving Data from Multiple Tables with SQL Joins
Join us as we walk through the process of retrieving data from multiple tables with SQL joins. This page shows how to use outer joins.

Creating Tables in SQL
Learn to create databases and tables using the Structured Query Language (SQL) in this step-by-step tutorial from your About.com Guide to Databases. Page 2.

Modifying Tables
Learn to create databases and tables using the Structured Query Language (SQL). In this final segment, we'll look how to alter the structure of a database. Page 3.

Creating Databases and Tables In SQL
Learn to create databases and tables using the Structured Query Language (SQL) in this step-by-step tutorial from your About.com Guide to Databases.

Removing Permissions
Learn about what you need to do to secure SQL databases. This page goes into removing granted permissions using the REVOKE command. Page 3.

Retrieving Data with SQL Queries: Introducing the SELECT Statement
Learn how to retrieve data with the SQL SELECT statement. Read Part 3 to look at renaming columns in these query results, and removing duplicate values.

Retrieving Data with SQL Queries: Introducing the SELECT Statement
Learn how to retrieve data with the SQL SELECT statement. Read Part 2 to go a step further and learn how to restrict the data received.

Microsoft Access Fundamentals
How do you modify queries in Microsoft Access? Learn more about queries, or the real power of databases in answering complex requests.

Starting a Career in Databases
Looking for a job in the database field? This article provides the advice you need to get started.

Educational Requirements for a Career in Databases
Looking for a job in the database field? This article provides the advice you need to get started. Page 2.

Professional Certifications
Looking for a job in the database field? This article provides the advice you need to get started. Page 3.

Introduction to SQL Fundamentals
Would you like to learn SQL? This tutorial will introduce you to the basics.

Data Definition Language - Create, Use, Alter, Drop
Would you like to learn SQL? This tutorial will introduce you to the basics. Page 2.

Data Manipulation Language for SQL Fundamentals
Would you like to learn SQL? This tutorial will introduce you to the basics. Page 3.

Join Statements
JOIN statements allow you to combine multiple tables in powerful ways. Page 4.

Blog


Microsoft SQL Server 2008 Editions: Which 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 database engine full of new features, but fortunately it doesn’t pack any additional punch in your wallet: SQL Server 2008 is available at the same price points used by SQL Server 2005.

Microsoft SQL Server 2008 R2: Choosing Correct Edition
SQL Server 2008 R2 is the latest in Microsoft’s enterprise relational database platform series. Here's a look at the 7 different editions that you can use.

Microsoft SQL Server 2012: Choosing the Correct Edition
SQL Server 2012. Databases.

Top 5 Microsoft Access 2007 Books for Beginners
So, you'd like to learn more about Microsoft Access 2007 and you don't know where to begin. I've selected five of my favorite introductory-level Access books for your perusal. Follow the

Top 7 Microsoft Access 2010 Books for Beginners
So, you'd like to learn more about Microsoft Access 2010 and you don't know where to begin. I've selected seven of my favorite introductory-level Access books for your perusal. Follow the

Top 5 Desktop Databases (Comparative)
Desktop databases offer simple, flexible solutions for data storage and retrieval. They're often quite sufficient to meet uncomplicated database requirements for both small and large organizations. If you're not sure if a desktop database is right for you, try reading the Choosing a Database series of articles which cover both desktop and server databases in depth

Filtering Query Results with Parameter Queries
Sometimes you run a query, and it returns more data than you can possible go through. Sometimes you actually need all of that data to get the best analytical results.

Dealing with Read-only Queries
Sometimes when you are working with Access you encounter read-only queries. Some of the queries have to be read-only, such as totals, and you are not meant to change the query results.

Databases for Retail Shops
If you are a shop owner or manager, you already know exactly how important it is to have the right database. From inventory and shipping to employees and customers, you know that even a slow day involves a lot of data maintenance.

SQL Server Administration (70-228) Practice Exam
Looking to prove your SQL Server Administration mettle? This quiz will help you prepare for Microsoft's 70-228 exam: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition. This is a critical step toward earning your Microsoft Certified Database Administrator credential.

Who Leads the RDBMS Pack?
According to most sources, Microsoft is rapidly gaining market share in the RDBMS arena. Have they finally surpassed Oracle? Read the latest results!

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

Creating a Simple Query in Microsoft Access
Want to learn how to create a query in Microsoft Access? Find out on the About.com Databases site!

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

SQL Server in Amazon Web Services (AWS) Free Tier
If you're seeking an inexpensive way to run a SQL Server database in the cloud, you might want to consider using the free tier of Amazon Web Services.

Top 5 Database Programming Books
Are you a database administrator looking to make the big move toward development? A programmer looking to make the rewarding plunge into database work? Perhaps you're even a seasoned database developer looking for a few good reference books. Here are my top five picks, representing several commonly used technologies.

SQL Server Index Tuning
Looking to squeeze that last bit of performance out of your SQL Server database? The Index Tuning Wizard can help!

Rollback and Savepoint Definition - Databases Glossary
What does it mean to rollback a database transaction? How do savepoints factor into this process? Learn more in the About Databases glossary!

Printing Forms in Microsoft Access
While forms are most useful when accessed directly in the database, there will be times when you will want to print them, for example when you want details about a single record or if you want to create instructions and include screenshots for entering data into a form.

Converting Forms to Reports in Microsoft Access 2013
Converting Forms to Reports in Microsoft Access 2013

Access Controls in SQL
SQL joins allow you to retrieve data from multiple database tables. Your About.com Guide to Databases provides a comprehensive introduction.

Access Controls in SQL - Granting Permissions
SQL joins allow you to retrieve data from multiple database tables. Your About.com Guide to Databases provides a comprehensive introduction. Page 2.

Customizing Form Appearance in Microsoft Access 2013
You need to be able to customize the look and information on a form so that it is easier for you, your team, and your company to work with it.

Grouping and Sorting Report Data in Microsoft Access 2013
Getting a database report to look presentable is one task; getting the data organized in a way that makes sense to different audiences is an entirely different challenge.

Field Types in Microsoft Access
As you get more familiar with Microsoft Access, it is extremely helpful to understand the different field types so that you can customize forms in order to standardize data entry.

Navigation Forms in Microsoft Access 2013
Navigation forms have been around for a while and many databases use them to make it easier for users (particularly new users) to get around faster.

Conditional Functions in Microsoft Access 2013
Microsoft Access offers the more advanced users a way around some of the most time consuming and repetitive actions by using conditional functions.

Copying Tables in Microsoft Access 2013
Copying tables in Microsoft Access can be tricky, not because it is particularly difficult, but because there are a number of things you need to consider before you begin. Naturally, there are a lot of things you need to avoid as well, because having two copies of the same table will significantly skew your data.

Full Functional Dependency Computing Definition
What is a full functional dependency? Find out here!

Trivial Functional Dependency Definition
The definition of trivial functional dependency in relational database theory, along with an example and some further reading.

Creating New Users in SQL Server 2008
SQL Server 2008 provides two methods for creating database user accounts - Windows authentication or SQL Server authentication. In Windows authentication mode, you assign all database permissions to Windows accounts. This has the advantage of providing a single sign-on experience for users and simplifying security management. In SQL Server (mixed mode) authentication, you can still assign rights to Windows users, but you may also create accounts that exist only in the context of the database.

Data Control Language (DCL) - for Database Permissions
The Data Control Language (DCL) is a subset of the Structured Query Lanaguge (SQL) that allows database administrators to configure security access to relational databases. It complements the Data Definition Language (DDL), which is used to add and delete database objects, and the Data Manipulation Language (DML), which is used to retrieve, insert and modify the contents of a database.

Developing Names for Database Fields, Tables, Reports
It’s very tempting to simply come up with something off the top of your head and run with it, but that’s not a great practice. Either you or your successors will curse the difficult field names you created down the road. In this article, I offer my advice on creating logical, consistent names for database fields, tables, reports, stored procedures and other objects.

Microsoft Access for Teachers
Teaching is already challenging enough without adding something that is potentially troublesome and complicated, but databases can actually make the job easier. While there are a number of databases out there, usually it will be easier (and cheaper) to use the tools you already have.

Databases for Salespeople
Being in sales comes with a host of challenges that no other position has. It is a fine balance between being helpful and being pushy, and that line changes based on who you are dealing with. Also, if you are in sales, you probably don’t like being tied down to a computer, so the idea of having to deal with a database can be a real headache. However, since you have so much information that you have to manage, you already know that you cannot get by without some sort of method to track customers, leads, and other clients.

SQL - Creating Stored Procedures for Your Database
Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks.

Introduction to SQL Server 2012
Microsoft SQL Server 2012 is a relational database management system (RDBMS) that offers tools for easy database development, upkeep, and administration.

Visual Basic for Applications (VBA) Essentials
There are several things that you need to know about VBA before you start trying to program in it, especially if you have not worked with a computer language before now. As with any computer program, you have to know about the different objects and how they are identified, what libraries are available and when to use them, and then you have to know how to work with the code. Even after you learn enough to deal with macros, you still have a good bit to learn before beginning to write the code in VBA, especially if you want to avoid spaghetti code (the bane of any programmer’s existence).

Accessing VBA, Recording Macros, and Making Basic Changes
Visual Basic Applications (VBA) actually opens in a separate window to the other things you use in Microsoft Access. This is because it is a programming language, so you will need an entirely different set of tools than those that you normally use. Macros are one way to use VBA to automate and simplify a project. This article focuses on how to record and make basic changes to macros, and it requires the least amount of knowledge to complete your first project.

Databases for Marketing Professionals
As a marketing professional you already deal with so many apps and software packages you are probably wondering why you should have to deal with something that is designed specifically for databases. After all, you probably already have a number of Excel spreadsheets to handle calculations, contacts and email templates in your preferred email software, and marketing campaigns recorded in a third program. This is exactly why you can benefit from an app or program that offers the organization of a database; it provides a centralized program to keep all of your information current from a single location instead of needing all of the different apps and programs.

Printing Query Results in Access 2013
Access offers users a way to print queries and their results. This provides users with a way to later review the results if they cannot remember which query was used.

Queries Using Multiple Tables in Access 2013
One of the primary benefits of using Microsoft Access is having the ability to pull data regardless of where it is saved within the database, especially if it is spread over half a dozen tables.

Saving Queries in Access 2013
After making tweaks and changes to a query, it can be difficult to remember exactly what changes pulled which results. This is one very good reason to get accustomed to saving queries with some frequency, even if they don’t provide exactly what the user is looking for at the time.

Operators and Expressions in Microsoft Access 2013
To really maximize the results of queries and calculations from Microsoft Access, users need to become familiar with operators and expressions

Payroll Database in Microsoft Access
In a recent forum posting, Bright wrote:

Opening PDF Files Within Microsoft Access
In a recent forum message, Redwings2010 wrote:

Cheap Database Software for Small Business?
In a recent forum posting, Karen wrote:

Publishing Access Forms on SharePoint
Databases.

Copying, Renaming and Deleting Tables in Microsoft Access
Copying, renaming and deleting tables in Microsoft Access often causes confusion for database administrators. In this article, we clarify the differences between the three operations and explain how to perform each.

Indexing Access 2013 Tables
Tables can be indexed, giving the user the power to execute sorts and finds in a manner that is faster and more efficient for fields that are frequently searched

Filtering Data in Access 2013
Microsoft Access 2013 includes filters that pull specific information instead of users having to muddle through countless records.

Database Relationships in Access 2013
So you've made the move from a spreadsheet to a database. You've set up your tables and painstakingly transferred all of your precious data. You take a well-deserved break, sit back and look at the tables you've created. Wait a second -- they look strangely familiar to the spreadsheets you've just disowned. Did you just reinvent the wheel? What's the difference between a spreadsheet and a database anyway?

Using Criteria in Microsoft Access Queries
Are you familiar with the use of criteria in queries? They can help you limit results in interesting ways!

Using Microsoft Access in Your Small Business
Learn five ways that Microsoft Access databases can help your small business succeed!

Verifying Credit Card Numbers with the Luhn Algorithm
All valid credit card numbers are creating using an internal checksum that helps merchants quickly determine if a card number contains typographical errors. This checksum appears as the last digit of the credit card number and is calculated using a process known as the Luhn algorithm. In this article, we examine how the Luhn algorithm works so that database developers may use it to perform a cursory inspection of credit card numbers.

Free and Low Cost SQL Server 2012 Options: SQL Server Express Edition and SQL Server Developer Edition
SQL Server is an enterprise-class relational database, but that doesn't mean it has to blow your budget. In this article, we take a look at two low cost options that let you get up and running with SQL Server 2012 for free or under $50.

Introduction to Microsoft Access 2013
Are you overwhelmed by the large quantities of data that need to be tracked in your organization? Perhaps you're currently using a paper filing system, text documents or a spreadsheet to keep track of your critical information. If you're searching for a more flexible data management system, a database might be just the salvation you're looking for and Microsoft Access 2013 provides an excellent option.

Input Masks in Microsoft Access 2013
Do your databases contain fields where users have entered a mess of information in a variety of different formats? Microsoft Access input masks may help you alleiviate this inconsistency in your desktop databases. Input masks allow you to specify the format of allowable user input, preventing users from entering information in a form that does not meet your data quality requirements.

Compact and Repair an Access 2013 Database
Over time, Microsoft Access databases grow in size and unnecessarily use disk space. Additionally, repeated modifications to the database file may result in data corruption. Therefore, it's a good idea to periodically run the compact and repair database tool to ensure the consistency of your data.

Shortcut Keys in Microsoft Access
Microsoft Access shortcut keys make it faster to execute queries and enter data without the user having to remove their hands from the keyboard.

Understanding Microsoft Access 2013 Encryption
This article provides additional technical details for individuals seeking to understand the encryption options offered within Microsoft Access 2013.

How to Print Mailing Labels in Microsoft Access 2013
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 Access 2013 using the built-in Label Wizard.

How To Install Microsoft Access 2013
Due to its widespread availability and flexible functionality, Microsoft Access is arguably the most popular database software in use today. In this

Creating Database Relationships in Access
Join us as we walk through the process of creating database relationships in Microsoft Access.

Microsoft Access Reports Tutorial
Would you like to create professional-looking reports from your Microsoft Access database with the click of a mouse? Follow along as we walk through the simple process of designing a reusable report.

Retrieving Data from Multiple Tables with SQL Joins
SQL joins allow you to retrieve data from multiple database tables. Your About.com Guide to Databases provides a comprehensive introduction.

Retrieving Data from Multiple Tables with SQL Joins
SQL joins allow you to retrieve data from multiple database tables. Your About.com Guide to Databases provides a comprehensive introduction.

Retrieving Data with SQL Queries: Introducing the SELECT Statement
Learn to retrieve information from your database with the SQL SELECT statement. Your About.com Guide to Databases provides a thorough introduction.

Modifying a Query in Microsoft Access
Want to learn how to modify a query in Microsoft Access? Find out on the About.com Databases site!

Entity-Relationship Diagrams
Entity Relationship diagrams (also known as E-R or ER diagrams) provide database designers with a valuable tool for modeling the relationships between database entities in a clear, precise format. This industry standard approach uses a series of block shapes and lines to describe the structure of a database in a manner understandable to all database professionals. Many database software packages, including Microsoft Access, SQL Server, and Oracle, provide automated methods to quickly create E-R diagrams from existing databases.

Converting an Excel Spreadsheet to an Access Database
Are you ready to convert your unweildy Excel spreadsheet to a flexible Access database? Let us walk you through the process!

Creating a Table with SQL Server 2014
Tables serve as the basic unit of organization for any database, including those managed by SQL Server 2014. Designing appropriate tables to store your data is an essential responsibility of a database developer and both designers and administrators must be familiar with the process of creating new SQL Server database tables. In this article, we explore the process in detail.

Using Table Templates in Access 2013
One of the greatest perks of Access 2013 is the length of time that Access has been around. With all of the iterations and updates, there are a lot of useful tools, particularly templates.

Microsoft Access Databases in Office 365
With the release of Microsoft Office 365 in 2013, there were a number of questions about how it changed the different Microsoft programs, including Microsoft Access.

Databases for Dry Cleaners
At first it may seem that dry cleaners don’t need databases, but if you have been in the business a while, you know exactly why they are vital to the industry.

Creating a Table with SQL Server 2012
Tables serve as the basic unit of organization for any database, including those managed by SQL Server 2012. Designing appropriate tables to store your data is an essential responsibility of a database developer and both designers and administrators must be familiar with the process of creating new SQL Server database tables. In this article, we explore the process in detail.

Expand the Tables Folder for the Appropriate Database
Once you've connected to the right SQL Server, expand the Databases folder and select the database where you'd like to add a new table. Expand that database's folder and then expand the Tables subfolder.

Select a Primary Key for your SQL Server Database Table
Next, highlight the column(s) that you've selected for your table's primary key. Then click the key icon in the taskbar to set the primary key.

Save Your Table
Don't forget to save your table! When you click the save icon for the first time, you'll be asked to provide a unique name for your table.

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

Start SQL Server Management Studio
Open Microsoft SQL Server Management Studio (SSMS) and connect to the server where you'd like to add a new table.

Start the SQL Server Table Designer
Right-click on the Tables subfolder and select the New Table option. This will start SQL Server's graphical Table Designer, as shown in the image above.

Add Columns to Your Database Table
Now it's time to add the columns you designed in step 1. Begin by clicking in the first empty cell under the Column Name heading in Table Designer.

Encrypting SQL Server Database Connections in SQL Server 2012
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.

Application Templates in Microsoft Access 2013
Apps are one of the staples of software today, and people have come to expect them. For Microsoft Access 2013, there are several app templates that are actually extremely useful for making a number of different aspects of databases a lot easier to manage. From billing and time tracking to basic database maintenance, there are a number of established apps that can help you with all of these chores. Or you can create your own from scratch or based on information in programs like Excel and SharePoint. You can take an existing template and customize it to do what you need the app to do. If you created any apps in a previous version of Access, you can also load those and update them to work better with Access 2013.

Dealing with Errors and Debugging in VBA
One of the most difficult things about writing code is finding the problems and fixing them, and Microsoft Access is not an exception. If you are relatively new to coding, there are a number of things you need to be aware of that will help you debug your code. If you are already familiar with other databases, like SQL, you know about troubleshooting your coding, but (of course) there are a few things that you have to learn that are specific to VBA. There is a lot more to debugging code, but the following sections can help you through the most common problems for reports, forms, and tables.

Creating SQL Server 2014 User Accounts
SQL Server 2014 provides a wide range of security features designed to help you protect the confidentiality, integrity and availability of data stored in your enterprise databases. One of the most important tasks that database administrators perform is the implementation of role-based access control that limits the ability of users to retrieve and modify data in the database unless they have an explicit business need to do so.

Converting an Excel Spreadsheet to an Access Database
Are you ready to convert your unweildy Excel spreadsheet to a flexible Access database? Let us walk you through the process!

Importing and Exporting Data With SQL Server 2014
The SQL Server Import and Export Wizard is a component of SQL Server Integration Services (SSIS) that facilitates the transfer of information between your SQL Server databases and other data sources, including Microsoft Excel, Microsoft Access and flat files.

Introduction to Visual Basic for Applications (VBA) in Microsoft Access
As you become more proficient in Microsoft Access, you begin to realize that there is a lot of duplicate effort and repetitive tasks that are well suited for automation. In Microsoft products, automation is done through the creation of macros in a specific type code language called Visual Basic for Applications, or VBA.

Introduction to SQL Server 2014
Microsoft SQL Server 2014 is a relational database management system (RDBMS) that offers tools for easy database development, upkeep, and administration.

Databases for Fundraising Professionals
As a professional fundraiser, you know how important it is to have a reliable and easy to manage database.

Report Themes in Microsoft Access 2013
Microsoft Access report themes give you a way to make all of your team, department, or company reports look consistent

NULL Values: Definition and Proper Uses
Users new to the world of databases are often confused by a special value particular to our field – the NULL value. Read about the proper uses of NULL in this article.

What is a Database?
Databases are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables. If youre familiar with spreadsheets like Microsoft Excel, youre probably already accustomed to storing data in tabular form. Its not much of a stretch to make the leap from spreadsheets to databases.

Databases for Beginners - Introduction
Are you new to the world of databases? Wondering where to get started? In this series of articles, we introduce you to the basics of database technology and help you get started in this exciting field.

Putting a Database in First Normal Form
In this article, we begin our look at the first of three major normal forms -- first normal form (otherwise known as 1NF).

Third Normal Form - Converting Databases to 3NF
In our first article, we looked at the basic requirements of 3NF. Here they are again to refresh your memory: meet the requirements of 1NF and 2NF and remove columns that are not fully dependent upon the primary key.

Database Relationships: Foreign Keys, Joins, E-R Diagrams
Relationships allow you to describe the connections between different database tables in powerful ways. Once you’ve described the relationships between your tables, you can later leverage that information to perform powerful cross-table queries, known as joins.

Access File Formats: ACCDB vs MDB
The release of Access 2007 brings a new file format. The MDB database files weve known for over a decade are now slated to become historical relics. While Access 2007 continues to support MDB databases for backwards compatibility purposes, Microsoft has now introduced the new ACCDB file format as the future standard. Wondering if you should begin using the ACCDB format?

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 your life easier!

Putting a Database in Second Normal Form (2NF)
Second Normal Form allows you to enhance the normalization of your database. In this article, we explore the requirements of 2NF and the process of normalizing your database.

Transaction Log Shrinking and Truncation in SQL Server
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 data in the event of a disaster. However, this benefit comes at a cost: the transaction log can consume a substantial amount of space in an active database. SQL Server provides two actions designed to counterbalance these large space requirements: transaction log truncation and log file shrinking.

Functional Dependency Definition
What is a functional dependency? Find out here!

Self-Joins in SQL Statements
You can use a self-join to simplify nested SQL queries where the inner and outer queries reference the same table. These joins allow you to retrieve related records from the same table.

Choosing a Database for Your Organization
It's important to do a careful needs analysis before you dive in and commit to a database solution. Learn the difference between desktop and server databases.

Pattern Matching in SQL Server Queries with Wildcards
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 to find data that fits a certain pattern, rather than specifying it exactly. For example, you can use the wildcard

Creating SQL Server 2012 User Accounts
SQL Server 2012 provides a wide range of security features designed to help you protect the confidentiality, integrity and availability of data stored in your enterprise databases. One of the most important tasks that database administrators perform is the implementation of role-based access control that limits the ability of users to retrieve and modify data in the database unless they have an explicit business need to do so.

Partitioning a SQL Server Database Table
Looking to optimize the performance of your SQL Server database? If your database contains very large tables, you may benefit from partitioning those tables onto separate filegroups. This technology, introduced in SQL Server 2005, allows you to spread data onto different physical disks, leveraging the concurrent performance of those disks to optimize query performance.

Counting Values in Database Table - SQL COUNT Function
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 values in a column or count the number of times records occur that meet certain criteria. This tutorial takes a brief look at each of these scenarios.

Structured Query Language (SQL) in Databases
Most large-scale databases use the Structured Query Language (SQL) to define all user and administrator interactions. This language offers a flexible interface for databases of all shapes and sizes.

Adding a Date or Time Stamp to an Access Database Table
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 easy to do this in Microsoft Access using the Now() function. In this tutorial, I explain the process step-by-step.

Importing and Exporting Data With SQL Server 2012
The SQL Server Import and Export Wizard is a component of SQL Server Integration Services (SSIS) that facilitates the transfer of information between your SQL Server databases and other data sources, including Microsoft Excel, Microsoft Access and flat files.

Foreign Keys in Microsoft SQL Server
One of the most important concepts in databases is creating relationships between database tables. These relationships provide a mechanism for linking data stored in multiple tables and retrieving it in an efficient fashion. In order to create a link between two tables, you must specify a foreign key in one table that references a column in another table.

Normalizing vs Denormalizing Databases
Database normalization is one of the sacred cows of application development. Every undergraduate programming course you’ve taken or book you’ve read likely preaches about the importance of normalizing databases in an almost religious fashion. You’re made to feel like failure to normalize a database is tantamount to violating one of the laws of the universe.It’s time to challenge that truism. Sometimes it’s OK to denormalize your database

Using the GROUP BY Clause to Group 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 provides you with the ability to group query results based upon row-level attributes in order to apply aggregate functions using the GROUP BY clause.

View and Edit SQL 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 accessing the underlying SQL code and tweaking it to perfect Access queries.

Choosing a SQL Server Authentication Mode
Microsoft SQL Server 2008 offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode. Making the proper choice affects both the security and maintenance of your organization’s databases.

What is SQL? Introduction to the Structured Query Language
The Structured Query Language (SQL) is the set of instructions used to interact with a relational database. In fact, SQL is the only language that most databases actually understand. Whenever you interact with such a database, the software translates your commands (whether they are mouse clicks or form entries) into SQL statement that the database knows how to interpret.

Testing 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, hackers manipulate a web application in an attempt to inject their own SQL commands into those issued by the database. In this article, we take a look at several ways you can test your web applications to determine whether they're vulnerable to SQL Injection attacks.

Stored Procedures & User Defined Functions (SQL Server)
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 server for future use. This offers you a tremendous efficiency benefit, as you can save programming time by...

Create Simple Queries - Access 2010 Tutorial
Have you ever wanted to combine information from multiple tables in your database in an efficient manner? Microsoft Access 2010 offers a powerful query function with an easy-to-learn interface that makes it a snap to extract exactly the information you need from your database. In this tutorial we'll explore the creation of a simple query.

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 cornerstone of SQL Server error handling and is an extremely important part of developing robust database applications.

Microsoft Access Genealogy Database Template
Are you interested in tracing your family roots but don’t have a good place to store all of your genealogical information? While there are several full-featured family tree software packages on the market, you can also use a free Microsoft Access template to create your own genealogy database on your computer. Microsoft’s already done most of the work for you, so there is no programming knowledge needed to get started.

SQL Server Replication Types and Components
Microsoft SQL Server provides a robust replication facility to distribute and update data in a decentralized fashion.

Exporting Access Tables to Excel - Step-By-Step Tutorial
Microsoft Access allows you to export data to a variety of formats for sharing and analysis. In this tutorial, we walk through the process of exporting an Access table to an Excel workbook.

SQL Server Recovery Models - Three Options
SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options.

Choosing a Primary Key for a Database
Databases depend upon keys to store, sort and compare records. If you’ve been around databases for a while, you’ve probably heard about many different types of keys – primary keys, candidate keys, and foreign keys. When you create a new database table, you’re asked to select one primary key that will uniquely identify records stored in that table.

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 encrypting your database and protecting with a password, step by step.

Structured Query Language (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 databases.

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 Server checks the column in question to determine whether it contains any duplicate values. If the table contains preexisting duplicates, the constraint creation command fails. Similarly, once you have a UNIQUE constraint on a column, attempts to add or modify data that would cause duplicates to exist also fail.

Including Attachments 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 Microsoft's Object Linking and Embedding (OLE) technology. Database attachments are a new feature in Access 2007.

Installing MySQL on Mac OS X 10.7 Lion
The MySQL database server is one of the most popular open source databases in the world. Although there is not yet an official package for installing it on the latest version of the Macintosh operating system (Mac OS X 10.7, codenamed Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6. Here’s a step-by-step walkthrough of the process.

Creating a Report in Microsoft Access 2010 -Tutorial
Microsoft Access 2010 allows you to easily create professionally formatted reports automatically from information stored in a database. In tis tutorial, we're going to design a nicely-formatted listing of employee home telephone numbers for the use of management using the Northwind sample database and Access 2010.

Data Input via Forms to Input and Modify Data
Part VIII of our tutorial introduces you to the concept of Access forms to input and modify data.

Creating Traces 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 and tuning database engine performance. In this tutorial, we walk through the process of creating a SQL Server Trace with SQL Server Profiler, step-by-step.

Converting an 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 database to Microsoft SQL Server might be the solution you’re trying to find. Fortunately, Microsoft provides an Upsizing Wizard in Access that makes it easy to convert your database. In this tutorial, we walk through the process of converting your database.

What Is a Candidate Key? Definition
What is a Candidate Key? Find out here!

What Is a Foreign Key? - Definition
What is a foreign key? Find out here!

Free ZIP Code Database (City, State, Latitude & Longitude)
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 the latitude and longitude of that location.

Database Software Options
You've finally buckled down and decided that it's time to purchase a database solution for your home or business. What type of database do you need? It's actually a simple matter of deciding what features you need and choosing a product that meets your requirements and doesn't cause too much pain in your pocketbook.

Database Management System (DBMS) - Definition
The software that allows a computer to perform database functions of storing, retrieving, adding, deleting and modifying data.

Importing Bulk Data into SQL Server
SQL Server provides fourmethods you can use when you need to insert large quantities of data into a SQL Server database. These automated techniques will help you insert data from the results of a SQL query, a text file or another database.

Database Certifications: Microsoft, Oracle & MySQL
Popular database certifications are always in demand, whether it's Microsoft's MCTS or MCITP, Oracle's OCA, OCP and OCM or MySql's CMA, CMDEV and CMDBA. Are you a database professional seeking to polish your resume in the hopes of landing a better gig? Database vendors offer a variety of professional certification programs that can help you advance your career while gaining valuable technical skills.

Combining Query Results with the UNION Command
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 example, imagine that you have a school database and wish to use it to create a master contact list for all students, faculty and staff. Looking at your database, you discover that the records corresponding to each of these constituencies appears in separate database tables.

How to Convert a Database to Access 2010 Format
The ACCDB database format introduced in Access 2007 provides a number of enhanced features over the older MDB format. In this article, we'll walk you through the process of converting an MDB format database to the new ACCDB format in Access 2010.

Creating Relationships
In the seventh installment of our Building an Access Database From the Ground Up series, we create relationships between our tables to finish implementing our relational model.

Creating Relationships (cont'd)
In the seventh installment of our Building an Access Database From the Ground Up series, we create relationships between our tables to finish implementing our relational model. Page 2.

SQL - Introduction, Overview and Sample Statements
The Structured Query Language (SQL) is the language of databases. All modern relational databases, including Access, FileMaker Pro, Microsoft SQL Server and Oracle use SQL as their basic building block. In fact, it’s often the only way that you can truly interact with the database itself.

Using Self-Joins in SQL - Expert Tutorial
Did you know that you can use a self-join to simplify nested SQL queries where the inner and outer queries reference the same table? Let's take a look at an example.

Data Mining - Introduction and Resources
Data mining allows you to find the needles hidden in your haystacks of data. Learn how to use these advanced techniques to meet your business objectives.

Show or Hide Tabs in Microsoft 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 of your database or more closely simulate the appearance of older versions of Access.

Selecting Data Within Ranges in SQL - Databases
The Structured Query Language (SQL)provides database users with the ability to create customized queries to extract information from databases. In an earlier article, we explored extracting information from a database using SQL SELECT queries. Let's expand upon that discussion and explore how you can perform advanced queries to retrieve data that matches specific conditions.

Retrieving Data With the SELECT Statement in SQL
The SELECT command is the most commonly used command in SQL. It allows database users to retrieve the specific information they desire from an operational database.

SQL Server Transaction Isolation Models
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 ACID model. However, sometimes business requirements force database administrators to stray from the default behavior and adopt a less rigid approach to transaction isolation. To assist in such cases, SQL Server offers five different transaction isolation models.

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 database column, SQL Server checks the column’s current contents for any NULL values. If the column currently contains NULL values, the constraint creation fails. Otherwise, SQL Server adds the NOT NULL constraint and any future INSERT or UPDATE commands that would cause the existence of a NULL value fail.

What is a Superkey? - Superkeys Defined
What is a superkey? Find out here!

What Is Boyce-Codd Normal Form (BCNF)?
What is Boyce-Codd Normal Form (BCNF)? Find out here!

Multivalued Dependency - Database Definition
What is a multivalued dependency? Find out here!

Open SQL Server Management Studio & Expand Folder
Open SQL Server Management Studio and Expand the SQL Server Agent Folder. Page 2.

Create a New SQL Server Agent Job - Tutorial
Create a New SQL Server Agent Job.

Enter the SQL Server Agent Job Steps Screen
Enter the SQL Server Agent Job Steps Screen

Add SQL Server Agent Job Steps
Add SQL Server Agent Job Steps. Databases.

Schedule the SQL Server Agent Job
Schedule the SQL Server Agent Job

Compact and Repair an 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 data corruption. Therefore, it's a good idea to periodically run the compact and repair database tool to ensure the consistency of your data.

Creating a Simple Query in Microsoft Access 2013
Have you ever wanted to combine information from multiple tables in your database in an efficient manner? Microsoft Access 2013 offers a powerful query function with an easy-to-learn interface that makes it a snap to extract exactly the information you need from your database. In this tutorial we'll explore the creation of a simple query.

Definition of a Schema in a Database
What is a database schema? Find out here!

Area Code Database
This free Access database of area codes provides database designers with a valuable tool to assist in mapping area codes to a state, province or region.

Definition and Examples of Database Instance
Looking for a definition of a database instance? Look no further!

What Is the Definition of a Database Attribute?
An attribute, when in regards to databases, deals with single data in an object. It is one of the basic terms used in SQL.

Installing SQL Server 2014 Express Edition - Completing the Installation
Microsoft SQL Server 2012 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.

Installing SQL Server 2014 Express Edition - File Extraction
Microsoft SQL Server 2012 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.

Installing SQL Server 2014 Express Edition - Instance Configuration
Microsoft SQL Server 2012 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.

Installing SQL Server 2014 Express Edition
Microsoft SQL Server 2014 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.