Databases Sitemap - Page 2 2016-09-26

Installing SQL Server 2014 Express Edition - Microsoft Update
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 - Feature Selection
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 - Server 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.

Database Engine 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 Page 2
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. Page 2.

Installing SQL Server 2014 Express Edition - Installation Center
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.

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

Flat File - Computing Glossary Definition
What is a flat file? Find out here!

Domain Definition and Example for Databases
What is the domain of a database? Find out here!

Atomicity Definition as It Relates to Databases
What is atomicity? Find out here!

Exporting Data: Microsoft Access 2010 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 unique analytical capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick.

Creating an ADO Connection in a Real-World Environment
The first step in developing an ADO application is to create a connection to a data source. This tutorial walks you through the process.

SQL Server 2012 Backup Types and Scopes
One of the major advantages that enterprise-class databases offer over their desktop counterparts is a robust backup and recovery feature set. Microsoft SQL Server provides database administrators with the ability to customize a database backup and recovery plan to the business and technical requirements of an organization.

How to Convert a Database to Access 2007 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.

Queries
Part 9 of our Building an Access Database From the Ground Up series explores the use of queries to retrieve information from a database.

Microsoft Access Function Library: InStr()
The InStr() function returns a number corresponding to the first location of a substring within a string.

Pivot Table Source Data
Begin by opening Microsoft Excel 2010 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 download the sample Excel file and use it as we walk through creating a pivot table step by step.

Introducing Pivot Tables in Excel 2013
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.

Create Your Pivot Table
Once you've opened the file, use your mouse to highlight the data that you wish to include in the pivot table. Then select the Insert tab in the Microsoft Excel Ribbon.

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.

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 Microsoft Excel 2010.

Applying Triggers in Database Development
Triggers may be used to automate common database actions. Learn how to apply them effectively!

What Is Metadata? - Definition and Examples
What is metadata? Find out here!

Publishing Access Data on the Web
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.

Begin the export process
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.

Set the file type to HTML
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.

Select an HTML template
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.

Upload your file(s) to your web server
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.

Review the finished product
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.

Open the item you wish to publish
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.

Choose an HTML filename
Would you like to share your Access reports with the web? This step-by-step tutorial will walk you through the process.

What Is First Normal Form (1NF)?
What is First Normal Form? Find out here!

Create an Adobe PDF File From Access 2010 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 database.

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

Microsoft SQL Azure: SQL Server in the Cloud (Overview)
With the release of SQL Azure, Microsoft is now offering serious database users the ability to put their databases in the cloud. SQL Azure is a relational database that supports Transact-SQL using Microsoft SQL Server Technology but allowing you to place all of the server and operating system administration tasks in the hands of Microsoft Engineers.

Clustering (Data Mining) Definition
What is clustering? Learn more about this data mining term here!

Installing MySQL on Windows 8 - Complete the Instance Configuration
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 8 - Set Windows Options
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 8 (Slideshow Tutorial)
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Log on with an Administrator Account
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 8 - Launch the Installer File
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 8 - Accept the EULA
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 8 - Choose an Installation Type
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 8 - Begin the Installation
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Initial MySQL Configuration
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 8 - Choose a Root Password and Create User Accounts
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

How to Back Up a Microsoft Access Database
Backing up your Microsoft Access databases is an important part of protecting your critical data. In this tutorial, we walk through the process of backing up an Access database, step-by-ste.

Exporting 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 unique analytical capabilities or simply share data with someone unfamiliar with Access. Whatever the reason, the conversion process is fairly straightforward and quick.

Executing Your Query
When you are ready to execute your query, simply type the command GO on a new command line within SQLCMD and press Enter. SQLCMD will execute your query and display the results on the screen, as shown above.

SQLCMD: Microsoft SQL Server 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. However, sometimes it’s just easier to work from the old-fashioned command line. Whether you’re looking for a quick-and-dirty way to execute a SQL query or wish to include SQL statements in a Windows script file, SQLCMD allows you to meet your goal.

Opening a Command Prompt
In order to run SQLCMD, you must first open a Windows command line utility. In Windows XP, click Start->Run and then type CMD in the textbox before clicking OK. In Windows Vista, click the Windows button, type CMD into the Search box and press Enter.

Connecting to the Database
Once you have a command prompt open, you use the SQLCMD utility to connect to the database.

Entering a Query
Next, you may begin typing a SQL statement at the 1> prompt. You may use as many lines as you wish for your query, pressing the Enter key after each line. SQL Server will not execute your query until explicitly instructed to do so (as shown in the next step).

Exiting SQLCMD
When you are ready to exit SQLCMD, simply type the command EXIT on a blank command line and you will be returned to the Windows command prompt.

Start the Relationships Tool
Next, you'll need to open the Access Relationships Tool. Begin by selecting the Database Tools tab on the Access ribbon. Then click the Relationships button, as shown in the image above.

Add the Related Tables
If this is the first relationship you've created in the current database, the Show Tables dialog box will appear, as shown in the image above.

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 understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. In this tutorial, we’ll walk through the process of creating a relationship between two tables in an Access database.

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

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

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

Introduction to MySQL
Fed up with the world of commercial software licensing? Are you looking for a stable database platform for your organization but sweating at the hefty price tags attached to mainstream products from Microsoft and Oracle? MySQL may be for you!

Installing MySQL
Installing MySQL is a breeze! In the second installment of our Introduction to MySQL series, we look at the installation process. Page 2.

Configuring MySQL for Windows
Now that you've installed MySQL, it's time to perform some basic administrative and configuration tasks to ensure that your database environment is ready for production. In this installment of our MySQL series, we'll look at the process of configuring MySQL on a Windows system. Page 3.

Configuring MySQL for Linux
Now that you've installed MySQL, it's time to perform some basic administrative and configuration tasks to ensure that your database environment is ready for production. In this installment of our MySQL series, we'll look at the process of configuring MySQL on a Linux system. Page 4.

Encrypting Access 2013 Databases
Password protecting an Access database allows you to protect your sensitive data from prying eyes. Encrypted databases require a password to open. Users attempting to open the database without the correct password will be denied access. Additionally, users attempting to directly access the database’s ACCDB file will not be able to view any of the data contained within it, as the encryption obscures the data from view by those without the proper password.

Make a Microsoft Access 2013 Database Using a Template
Starting from a template is the easiest way to get up and running quickly with Microsoft Access. Using this process allows you to leverage the database design work initially performed by someone else and then customize it to suit your particular needs. In this tutorial we walk you through the process of creating a Microsoft Access database using a template to get you up and running in just a few minutes.

Search for a Template
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.

Browse the Search Results
Starting from a template is the easiest way to get up and running quickly with Microsoft Access. Using this process allows you to leverage the database design work initially performed by someone else and then customize it to suit your particular needs. In this tutorial we walk you through the process of creating a Microsoft Access database using a template to get you up and running in just a few minutes.

Begin Working With Your Database
Starting from a template is the easiest way to get up and running quickly with Microsoft Access. Using this process allows you to leverage the database design work initially performed by someone else and then customize it to suit your particular needs. In this tutorial we walk you through the process of creating a Microsoft Access database using a template to get you up and running in just a few minutes.

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.

Enable Active Content
Starting from a template is the easiest way to get up and running quickly with Microsoft Access. Using this process allows you to leverage the database design work initially performed by someone else and then customize it to suit your particular needs. In this tutorial we walk you through the process of creating a Microsoft Access database using a template to get you up and running in just a few minutes.

Access 2013 Tour: The User Interface
If you're switching to Microsoft Access 2013 from an earlier version, you're bound to immediately notice some changes. If you've been using Access 2007, the ribbon-based user interface will look similar, but it's received a facelift.

The Ribbon
The Ribbon, introduced in Office 2007, is the biggest change for users of earlier versions of Access. It replaces the familiar drop-down menus (remember

The File Tab
Fans of the old File menu have something to celebrate in Access 2013 - it's back! (Well, kind of!) The Microsoft Office button is now gone and has been replaced with a File tab on the Ribbon. When you select this tab, a new window appears down the left side of the screen with many of the functions found on the old File menu.

Command Tabs
The command tabs help you navigate through the Ribbon by choosing the high-level task that you'd like to perform. For example, the Ribbon shown above has the Create command tab selected. The Home, External Data and Database Tools command tabs always appear at the top of the Ribbon. You'll also see context-sensitive tabs, such as the Datasheet tab in the example above.

Navigation Pane
The Navigation Pane (shown above) provides you with access to all of the objects in your database. You may customize the contents of the Navigation Pane by using the expandable/collapsable subpanes.

Getting Started Page
The most notable feature on this page is the prominent set of dynamic links to Microsoft's Access database templates. These are updated automatically through Office Online and offer you the ability to begin your database design with a predefined template, rather than starting from a blank database. Examples include databases for asset tracking, project management, sales, tasks, contacts, issues, events and students.

Quick Access Toolbar
The Quick Access Toolbar (shown in the image above) appears at the top of the Access window and provides you with one-click shortcuts to commonly used functions. You may customize the contents of the toolbar by clicking the arrow icon immediately to the right of the toolbar. By default, the Quick Access Toolbar contains buttons for Save, Undo and Redo. You may customize the toolbar by adding icons for New, Open, E-mail, Print, Print Preview, Spelling, Mode, Refresh All and other functions.

Tabbed Documents
Access 2013 incorporates the popular tabbed document browsing feature found in web browsers. As shown in the image above, Access provides you with tabs representig each of your open database objects. You may quickly switch between open objects by clicking on the corresponding tab.

Relation Definition
What is a relation? Find out here!

Creating the Database File
In part five of our Building An Access Database From the Ground Up series, we create the Access database file that will be used for the Patrick's Widgets database.

Classifying Results with SQL CASE Statements
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 SQL statement that you would normally include an expression. CASE statements are often found in SELECT, UPDATE and DELETE statements as well as WHERE and IN clauses.

Transitive Dependency in a Database - Definition
What is a transitive dependency? Find out here!

What Is a Database Relationship? - Definition
Looking for a definition of a database relationship? Check out the About Databases glossary definition!

Select Create Form from the Microsoft Access Ribbon
Next, select the Create tab on the Access Ribbon and choose the Create Form button, as shown in the image above.

View the Basic Microsoft Access Form
Access will now present you with a basic form based upon the table you selected. If you're looking for a quick and dirty form, this may be good enough for you. If that's the case, go ahead and skip to the last step of this tutorial on Using Your Form. Otherwise, read on as we explore changing the form layout and formatting.

Format Your Microsoft Access Form
Now that you've arranged the field placement on your Microsoft Access form, it's time to spice things up a bit by applying customized formatting.

Use Your Microsoft Access Form
You've put a lot of time and energy into making your form match your needs. Now it's time for your reward! Let's explore using your form.

Creating Forms in Microsoft Access 2010
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry situation. If you’re working with users you don’t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we’ll walk through the process of creating an Access form.

Opening a Microsoft Access Database
To begin, open your Access database.

Select the Table for your Microsoft Access Form
Before you begin the form creation process, it's easiest if you pre-select the table that you'd like to base your form upon. Using the pane on the left side of the screen, locate the appropriate table and double-click on it.

Arrange Your Microsoft Access Form Layout
After your form is created, you'll be placed immediately into Layout View, where you can change the arrangement of your form. If, for some reason, you're not in Layout View, choose it from the drop-down box underneath the Office button.

Name Your Access Database
In the next step, the right pane of the Getting Started window will change to match the image above. Give your database a name by typing it into the text box and click the Create button to begin building your database.

Creating an Access 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 a database, there isn’t always a template available that meets your needs. In this article, we review the process for creating an Access database from scratch.

Create a Blank Access Database
Next, you'll need to create a blank database to use as your starting point. Click

Add Tables To Your Access Database
Access will now present you with a spreadsheet-style interface, shown in the image above, that helps you create your database tables.

Continue Building Your Access Database
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 a database, there isn’t always a template available that meets your needs. In this article, we review the process for creating an Access database from scratch.

Is Two-Tier or N-Tier Best for Computer Databases?
What's best for your situation? Two-tier, three-tier or n-tier databases? Find out here!

NoSQL Introduction - Building Databases for Big Data
The NoSQL movement is changing the way we think about databases. Instead of requiring that database developers follow the rigid principles of the ACID model, NoSQL allows a great deal of flexibility that provides a tremendous efficiency boost. This comes, however, at the cost of reduced enforcement of traditional database constraints.

Microsoft SQL Server 2012 Certification Programs
Microsoft is once again overhauling its SQL Server certification program in conjunction with the release of SQL Server 2012. The short-lived MCITP and MCTS certifications are no more and now there are three levels of certification available to database professionals

Excel Tutorial - Convert Spreadsheet to Access 2010 Database
Excel Tutorial - Convert Spreadsheet to Access 2010 Database

Create a new Access 2010 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!

Microsoft Access Sample Database: Geographical Data
This Microsoft Access sample database provides tables containing information on the world's countries, cities and provinces. It is used to illustrate examples for a number of the articles on the About Databases site and also provides a good sample for students, professionals and others who are learning Microsoft Access.

What Is a Database Query? (Definition and Examples)
What is a query? Find out here! Databases.

Installing MySQL on Windows 7 - Set Windows Options
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Choose a Root Password
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Complete the Instance Configuration
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Run Instance Configuration Wizard
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Choose a Configuration Type
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL Database Server on Windows 7
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Log on with an Administrator Account
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Launch the Installer File
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Accept the EULA
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Choose an Installation Type
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Begin the Installation
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Installing MySQL on Windows 7 - Complete the Installation
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it’s certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here’s a step-by-step walkthrough of the process.

Sample Excel Document for Use in Tutorials
Sample Excel Document. Databases.

Creating 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. If you’re working with users you don’t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we’ll walk through the process of creating an Access form.

Opening a Microsoft Access Database
To begin, open your Access database.

Select the Table for your Microsoft Access Form
Before you begin the form creation process, it's easiest if you pre-select the table that you'd like to base your form upon. Using the

Select Create Form from the Microsoft Access Ribbon
Next, select the Create tab on the Access Ribbon and choose the Create Form button, as shown in the image above.

View the Basic Microsoft Access Form
Access will now present you with a basic form based upon the table you selected. If you're looking for a quick and dirty form, this may be good enough for you. If that's the case, go ahead and skip to the last step of this tutorial on Using Your Form. Otherwise, read on as we explore changing the form layout and formatting.

Arrange Your Microsoft Access Form Layout
After your form is created, you'll be placed immediately into Layout View, where you can change the arrangement of your form. If, for some reason, you're not in Layout View, choose it from the drop-down box underneath the Office button.

Format Your Microsoft Access Form
Now that you've arranged the field placement on your Microsoft Access form, it's time to spice things up a bit by applying customized formatting.

Use Your Microsoft Access Form
You've put a lot of time and energy into making your form match your needs. Now it's time for your reward! Let's explore using your form.

Databases Glossary - Definitions and Information
Glossary of database related terms, including definitions, explanations, examples, suggested reading, and other resources.

Creating Forms in Microsoft Access 2003 - Tutorial
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Edit Properties
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Click on the Forms tab under Objects
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Click on the New icon to create a new form
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Select the creation method you wish to use
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Select the data source and click OK.
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Select the form fields to be used and click Next.
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Select the form layout and click Next
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Select the form style and click Next.
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

Provide a title for your form
Learn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!

The ACID Model for Database Management Systems
All database management systems should share four characteristics: Atomicity, Consistency, Isolation and Durability.

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

Create a new Access 2007 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!

Password Protect an Access 2007 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.

Select Open from the Office Menu
Next, choose Open from the Office menu. Please read the next step before opening your database. We need to open it in a special way to ensure that it's ready for encryption.

Open the Database in Exclusive Mode - Page 3
Step-by-step instructions on password protecting Access. On this page we discuss how to open a database exclusively.

Selecting Encryption
From the Database Tools tab, double-click on the

Set a Database Password
Choose a strong password for your database and enter it in both the Password and Verify boxes in the Set Database Password dialog box, as shown in the image above. Once you've done this, click OK.

What Is a One-To-Many Relationship?
Looking for a definition of one-to-many database relationships? Read our definition in the About Databases glossary!

Controlling Data Access With Views in SQL
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 limiting the data presented to the end user. Essentially, a view uses the results of a database query to dynamically populate the contents of an artificial database table.

DISTINCT Keyword in SQL - Unique Records From a Table
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 are ignored and only displayed once.

Select the Database
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Configure the Data Source
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Add a new Data Source
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Choose the Driver
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Open the ODBC Data Source Control Panel
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Save the file
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Begin the export process
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Create a Filename
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

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

Open the item you wish to publish
Want to create dynamic, server-generated HTML from your Access database? This step-by-step tutorial will walk you through the process.

Stored Procedure Definition - Databases Glossary
Looking for a definition of the database term stored procedure? Find it here in the About Databases glossary.

Database Basics - Normalizing & Securing Databases
Databases offer a convienient and powerful way to organize your information. In Database Basics, you'll learn how to get started in the world of databases, normalize your database according to commonly accepted design principles, add security to your database and use database keys and transactions.

How to Create an Alert Using SQL Server Agent
SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour monitoring of your database performance without staffing a 24-hour operations center.

Oracle - Computing Glossary Definition
What is Oracle? Find out here! Databases.

Splitting an Access Database, Step One: Open It
Oftentimes, you 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 ability to view and/or update your data, you may not wish them to modify the interface you use to work with the data yourself. Fortunately, Microsoft Access provides the ability to split a database into front-end and back-end components. You can safely share data with other users while keeping your interface private.

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!

Installing SQL Server 2012 Express Edition
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 2012 Express Edition Page 2
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. Page 2.

Installing SQL Server 2012 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 2012 Express Edition - Installation Center
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 2012 Express Edition - Feature Selection
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.

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 2012 Express Edition - Server 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 2012 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.

Introduction to Pivot Tables in Excel and Google
If you’re looking for some of the flexible query power of a database but don’t want to mess with relational database design, pivot tables may be just the technology you need. Chances are you’re already using one of the popular spreadsheet packages that include this technology, such as Microsoft Excel or the free Google Spreadsheets package.

One-To-One Relationships - Databases
Looking for a definition of one-to-one database relationships? Read our definition in the About Databases glossary!

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

Installing MySQL on Mac OS X 10.8 - Getting Ready
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.8, codenamed Mountain Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6, just as it was possible to do so on Mac OS X 10.7 Lion. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Here’s a step-by-step walkthrough of the process.

Download the MySQL Installer
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.8, codenamed Mountain Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6, just as it was possible to do so on Mac OS X 10.7 Lion. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Here’s a step-by-step walkthrough of the process. Page 2.

Mount the Disk Image
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.8, codenamed Mountain Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6, just as it was possible to do so on Mac OS X 10.7 Lion. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Here’s a step-by-step walkthrough of the process. Page 3.

Launch the Installer
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.8, codenamed Mountain Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6, just as it was possible to do so on Mac OS X 10.7 Lion. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Here’s a step-by-step walkthrough of the process. Page 4.

Walk Through the Installation Process
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.8, codenamed Mountain Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6, just as it was possible to do so on Mac OS X 10.7 Lion. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Here’s a step-by-step walkthrough of the process. Page 5.

Configure Automatic Start Up
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.8, codenamed Mountain Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6, just as it was possible to do so on Mac OS X 10.7 Lion. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Here’s a step-by-step walkthrough of the process. Page 6.

Add a System Preferences Pane
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.8, codenamed Mountain Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6, just as it was possible to do so on Mac OS X 10.7 Lion. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Here’s a step-by-step walkthrough of the process. Page 7.

PCI DSS for Database Professionals
The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit or debit card transactions. These requirements stem from a series of significant security incidents affecting databases of consumer credit information over the past decade.

Continue Building Your Access Database
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 a database, there isn’t always a template available that meets your needs. In this article, we review the process for creating an Access database from scratch. Page 5.

Backing up an Access 2013 Database
Backing up your Access 2013 database is an important step to preserve the integrity and availability of your important data. In this tutorial, we walk through the process of backing up an Access 2013 database, step-by-step.

Open the Database
Start Microsoft Access 2013 and open the database that you would like to backup. Page 2.

Close all database objects
Protecting the integrity of information stored in a database is one of the most important responsibilities of a database administrator. One task associated with this responsibility is performing regular database backups. In this tutorial, we'll walk through the process of backing up your Access 2010 database using the software's built-in backup functionality. Page 3.

Select "Save Database As"
Protecting the integrity of information stored in a database is one of the most important responsibilities of a database administrator. One task associated with this responsibility is performing regular database backups. In this tutorial, we'll walk through the process of backing up your Access 2010 database using the software's built-in backup functionality. Page 4.

Choose a Backup File Name
Protecting the integrity of information stored in a database is one of the most important responsibilities of a database administrator. One task associated with this responsibility is performing regular database backups. In this tutorial, we'll walk through the process of backing up your Access 2010 database using the software's built-in backup functionality. Page 5.

Click the Save Button
Protecting the integrity of information stored in a database is one of the most important responsibilities of a database administrator. One task associated with this responsibility is performing regular database backups. In this tutorial, we'll walk through the process of backing up your Access 2010 database using the software's built-in backup functionality. Page 6.

Creating Forms in Microsoft Access 2013
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn’t always an appropriate tool for every data entry situation. If you’re working with users you don’t want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we’ll walk through the process of creating an Access form.

Opening a Microsoft Access Database
To begin, open your Access database. Page 2.

Select the Table for your Microsoft Access Form
Before you begin the form creation process, it's easiest if you pre-select the table that you'd like to base your form upon. Using the pane on the left side of the screen, locate the appropriate table and double-click on it. Page 3.

Select Create Form from the Microsoft Access Ribbon
Next, select the Create tab on the Access Ribbon and choose the Create Form button, as shown in the image above. Page 4.

View the Basic Microsoft Access Form
Access will now present you with a basic form based upon the table you selected. If you're looking for a quick and dirty form, this may be good enough for you. If that's the case, go ahead and skip to the last step of this tutorial on Using Your Form. Otherwise, read on as we explore changing the form layout and formatting. Page 5.

Arrange Your Microsoft Access Form Layout
After your form is created, you'll be placed immediately into Layout View, where you can change the arrangement of your form. If, for some reason, you're not in Layout View, choose it from the drop-down box underneath the Office button. Page 6.

Format Your Microsoft Access Form
Now that you've arranged the field placement on your Microsoft Access form, it's time to spice things up a bit by applying customized formatting. Page 7.

Use Your Microsoft Access Form
You've put a lot of time and energy into making your form match your needs. Now it's time for your reward! Let's explore using your form. Page 8.

Creating an Access Database from Scratch
Many people choose to create their first database using one of the many free Access 2013 database templates. Unfortunately, this isn't always an option, as you sometimes need to create a database with business requirements that aren't met by one of the available templates. In this article, we walk you through the process of designing your own Access database without the use of a template.

Create a Blank Access Database
Once you've opened Access 2013, you will see the Getting Started screen shown above. This presents the ability to search through the many templates available for Microsoft Access databases, as well as browse the databases that you've recently opened. We won't be using a template in this example, however, so you should scroll through the list and locate the

Name Your Access Database
In the next step, the right pane of the Getting Started window will change to match the image above. Give your database a name by typing it into the text box and click the Create button to begin building your database. Page 3.

Add Tables To Your Access Database
Access will now present you with a spreadsheet-style interface, shown in the image above, that helps you create your database tables. Page 4.

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. Page 4.

Create Your Pivot Table
Once you've opened the file, use your mouse to highlight the data that you wish to include in the pivot table. Then select the Insert tab in the Microsoft Excel Ribbon. On the left side of the ribbon, click the down arrow under Pivot Table and click Pivot Table. Page 3.

Pivot Table Source Data
Begin by opening Microsoft Excel 2010 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 download the sample Excel file and use it as we walk through creating a pivot table step by step. Page 2.

Introducing Pivot Tables in Excel 2010
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.

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 Microsoft Excel 2010. Page 5.

Creating Relationships in Microsoft 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 don’t understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. In this tutorial, we’ll walk through the process of creating a relationship between two tables in an Access database.

Creating an Access 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 a database, there isn’t always a template available that meets your needs. In this article, we review the process for creating an Access database from scratch.

Continue Building Your Access Database
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 a database, there isn’t always a template available that meets your needs. In this article, we review the process for creating an Access database from scratch. Page 5.

Authentication Defined
Authentication is the process of confirming a user or computer’s identity. The process normally consists of four steps:

Fact Table
What is a fact table in business intelligence? Find out in the About Databases Glossary!

Microsoft Office Specialist: Access 2013 MOS Certification
Microsoft offers a variety of professional certification programs, including a database certification for users of Microsoft Access 2013. If you use Microsoft Access 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 the Microsoft Office Specialist (MOS) program's Access 2013 track. This program (formerly known as the Microsoft Office User Specialist or MOUS program) allows users of the popular desktop database to prove their knowledge in a structured exam environment.

Analytics Databases
Analytics databases are optimized to be used for retrieval, aggregation, tabulation, dissemination, and analytics, under the general banner of business intelligence (BI). They deliver benefits in a BI environment because they are designed for high performance in this environment, whereas an online transaction processing (OLTP)-oriented database is optimized for a very different role.

SQL Server Migration Assistant 2012
SQL Server Migration Assistant (SSMA) provides database administrators with a smooth way to transition from their existing database platform to Microsoft SQL Server. The migration assistants are able to transfer data to either a server-based SQL Server database or to Microsoft’s SQL Azure cloud-based database platform.

Database Engine Tuning Advisor in SQL Server 2012
SQL Server 2012’s Database Engine Tuning Advisor (DETA) provides database administrators with a powerful way to tune your database for your specific environment. DETA allows you to design a customized workload that mimics your operational environment and then analyze that workload to determine the optimal configuration settings for your SQL Server instance. DETA’s recommendations include adding normal and clustered indexes to your database, partitioning tables and creating indexed views, where appropriate.

Creating Traces with SQL Server 2012 and SQL Profiler
SQL Profiler is a diagnostic tool included with Microsoft SQL Server 2012. It allows you to create SQL traces that track the specific actions performed against a SQL Server databases. SQL traces provide valuable information for troubleshooting database issues and tuning database engine performance. For example, administrators might use a trace to identify a bottleneck in a query and develop optimizations that might improve database performance.