Published: Sat, 10 Dec 2016 11:12:25 +0000
2016-12-10T11:12:25ZDatabase normalization can save storage space and ensure the consistency of your data. Learn the basics in this introductory article.
2016-12-10T11:12:25ZAs 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.
2016-12-10T11:12:25ZThink you're a database dummy? This article discusses basic database concepts, including the structure of a database and typical database programs.
2016-12-10T11:12:25ZReferential integrity is a database concept that ensures that relationships between tables remain consistent. Find more information here.
2016-12-10T11:12:25ZOne 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.
2016-12-10T11:12:25ZFacts and dimensions form the core of any business intelligence effort. In this article, we look at the development and use of facts and dimensions.
2016-12-10T11:12:25ZSQL Server constraints allow you to enforce rules in your database. These rules may affect business logic, database integrity and/or table structures. Each one plays an important role in your database architecture.
2016-12-10T11:12:25ZWhat 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.
2016-12-10T11:12:25ZDatabase dependencies are a topic that often confuses both students and database professionals alike. Fortunately, they are not that complicated.
2016-12-10T11:12:25ZThe 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.
2016-12-10T11:12:25ZSecond 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.
2016-12-10T11:12:25ZMost 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.
2016-12-10T11:12:25ZLooking 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.
2016-12-10T11:12:25ZGlossary of database terms used commonly in many database management systems.
2016-12-10T11:12:25ZMicrosoft Access 2013 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 2013.
2016-12-10T11:12:25ZJust 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!
2016-12-10T11:12:25ZBacking 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.
2016-12-10T11:12:25ZThe 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.
2016-12-10T11:12:25ZChoose your database's primary keys carefully, ensuring they are unique and will never need to be changed. A bad choice is a ZIP code or Social Security number.
2016-12-10T11:12:25ZAre 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.
2016-12-10T11:12:25ZIn this article, we begin our look at the first of three major normal forms -- first normal form (otherwise known as 1NF).
2016-12-10T11:12:25ZLooking for an easy way to move your Microsoft Access database to the cloud? Microsoft's Office 365 service provides a central location.
2016-12-10T11:12:25ZLearn to retrieve information from your database with the SQL SELECT statement.
2016-12-10T11:12:25ZRelationships allow you to describe the connections between different database tables in a relational database in powerful ways.
2016-12-10T11:12:25ZInstall the Northwind sample database for Microsoft Access 2013. This database contains some great sample tables, queries, reports and other database features useful for learning Access.
2016-12-10T11:12:25ZLooking 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.
2016-12-10T11:12:25ZThe 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.
2016-12-10T11:12:25ZDatabase management systems ensure data integrity through the ACID protocol: Atomicity, Consistency, Isolation and Durability.
2016-12-10T11:12:25ZWith 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.
2016-12-10T11:12:25ZWould you like to learn SQL? This tutorial will introduce you to the basics.
2016-12-10T11:12:25ZThe Northwind database contains some great sample tables, queries, reports and other database features. Here's how to install it.
2016-12-10T11:12:25ZAre you familiar with the use of criteria in queries? They can help you limit results in interesting ways!
2016-12-10T11:12:25ZDo a careful needs analysis before you dive in and commit to a database solution. Learn the difference between desktop and server databases.
2016-12-10T11:12:25ZThe ACCDB Access file format has been the default Access file format since its 2007 release. Learn its benefits and how to convert between it and the older format, MDB.
2016-12-10T11:12:25ZThe 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.
2016-12-10T11:12:25ZIn this series of Microsoft Access tutorials, we follow the database admins for Patrick's Widgets as they build a Microsoft Access database.
2016-12-10T11:12:25ZAre 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.
2016-12-10T11:12:25ZData 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.
2016-12-10T11:12:25ZOne 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.
2016-12-10T11:12:25ZWith this metadata definition, find out how metadata describes data itself and is used in almost every industry.
2016-12-10T11:12:25ZSQL 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.
2016-12-10T11:12:25ZThe bulk copy (bcp) command of Microsoft SQL Server provides you with the ability to insert large numbers of records directly from the command line.
2016-12-10T11:12:25ZFind out how a database query can get the data you need out of your database by writing the query in the language the database requires, usually SQL.
2016-12-10T11:12:25ZWant to learn how to use Microsoft Access? Find out about the fundamentals with this introduction.
2016-12-10T11:12:25ZFind out how defining a database domain ensures your data's integrity, which ensures that all data in a field contains valid values.
2016-12-10T11:12:25ZDesktop databases offer simple, flexible solutions for data storage and retrieval. Here's a rundown on the five top desktop databases for individuals and businesses.
2016-12-10T11:12:25ZIn 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.
2016-12-10T11:12:25ZThe BASE model offers a completely different alternative to our traditional notions of database engineering. It abandons the relational database guiding principles of atomicity, consistency, isolation and durability in favor of a relaxed approach that allows the flexible, efficient storage of data.
2016-12-10T11:12:25ZTraces 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.
2016-12-10T11:12:25ZPassword 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.
2016-12-10T11:12:25ZWhat is a multivalued dependency? Find out here!
2016-12-10T11:12:25ZThe 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.
2016-12-10T11:12:25ZMany database users begin their adventure in the world of databases by creating a Microsoft Access database that meets the basic requirements of their organizations. Often, this is a dramatic improvement from an unwieldy collection of spreadsheets, text files or other documents that the organization previously used to manage information. However, eventually the business may outgrow that Access database and need to make the move to a more advanced database product.
2016-12-10T11:12:25ZWhat is a full functional dependency? Find out here!
2016-12-10T11:12:25ZIs 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.
2016-12-10T11:12:25ZA database attribute is a column, or field, in a database table. For example, given a Customers table, a Name column is an attribute of that table.
2016-12-10T11:12:25ZThe Data Control Language (DCL) is a subset of the Structured Query Lanaguge (SQL) that allows database administrators to configure security access to relational databases.
2016-12-10T11:12:25ZSo 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?
2016-12-10T11:12:25ZLearn five ways that Microsoft Access databases can help your small business succeed!
2016-12-10T11:12:25ZDatabases offer an organized mechanism for storing, managing and retrieving information. Far more powerful than spreadsheets, a database and a Database Management System can help manage and protect large amounts of data.
2016-12-10T11:12:25ZLearn how to create a simple query in Microsoft Access.
2016-12-10T11:12:25ZCopying 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.
2016-12-10T11:12:25ZAlthough copying, renaming or deleting tables remains a straightforward process in Microsoft Access, you'd be wise to copy your database before you adjust its internal structure.
2016-12-10T11:12:25ZAccess 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.
2016-12-10T11:12:25ZUnderstand the definition of a database relationship, which is behind all relational databases.
2016-12-10T11:12:25ZDatabase software comes in all flavors. Here's a brief rundown on some of the primary desktop or server-based database software solutions.
2016-12-10T11:12:25ZHere, we define a database foriegn key and provide examples for understanding its relationship to a table's primary key.
2016-12-10T11:12:25ZMicrosoft 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.
2016-12-10T11:12:25ZAs 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.
2016-12-10T11:12:25ZShould you use a spreadsheet or a database? Learn more in this article!
2016-12-10T11:12:25ZJoin us as we walk through the process of creating database relationships in Microsoft Access.
2016-12-10T11:12:25ZInput masks in Microsoft Access 2013 restrict user input, preventing users from entering data in a form that doesn't meet your quality requirements.
2016-12-10T11:12:25ZIn this course, we explore the basics of database design. Ten weekly lessons each explore a different issue in database design, culminating in a final case study.
2016-12-10T11:12:25ZMicrosoft Access 2013 includes filters that pull specific information instead of users having to muddle through countless records.
2016-12-10T11:12:25ZThis 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.
2016-12-10T11:12:25ZWhat is a Candidate Key? Find out here!
2016-12-10T11:12:25ZLearn to retrieve information from your database with the SQL SELECT statement.
2016-12-10T11:12:25ZWhile 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.
2016-12-10T11:12:25Zk-means clustering is a data mining/machine learning algorithm used to cluster observations into groups of related observations without any prior knowledge of those relationships. The k-means algorithm is one of the simplest clustering techniques and it is commonly used in medical imaging, biometrics and related fields.
2016-12-10T11:12:25ZSQL 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.
2016-12-10T11:12:25ZLooking for a job in the database field? This article provides the advice you need to get started.
2016-12-10T11:12:25ZA database management system allows a computer to perform database functions of storing, retrieving, adding, deleting and modifying data.
2016-12-10T11:12:25ZA database relation is the same as a database table, and is governed by a series of constraints that ensure data integrity.
2016-12-10T11:12:25ZOne 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.
2016-12-10T11:12:25ZDatabase certifications from major database vendors including Microsoft, Oracle, MySQL and IBM.
2016-12-10T11:12:25ZAt 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.
2016-12-10T11:12:25ZClassification is a data mining technique that helps analyze data and predict outcomes. It is one of several such methods used to analyze big data.
2016-12-10T11:12:25ZAn entity-relationship (ER) diagram is a specialized graphic that illustrates the relationships between entities in a database.
2016-12-10T11:12:25ZWould 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.
2016-12-10T11:12:25ZA database instance is the entire database environment, but vendors may use the term in a specific way.
2016-12-10T11:12:25ZA transitive dependency in a database is an indirect relationship between values in the same table that causes a functional dependency and thus results in de-normalization.
2016-12-10T11:12:25ZThe definition of trivial functional dependency in relational database theory, along with an example and some further reading.
2016-12-10T11:12:25ZEditing the raw SQL powering a Microsoft Office query is straightforward -- and Access conforms well to ANSI-standard SQL syntax.
2016-12-10T11:12:25ZWant to learn how to modify a query in Microsoft Access? This is the help you need.
2016-12-10T11:12:25ZOver 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.
2016-12-10T11:12:25ZWhat is a functional dependency in a database? Find out why FC is important in ensuring the accuracy of your data.
2016-12-10T11:12:25ZDatabase normalization is a basic tenet of database application development, but it's not always absolutely necessary. Here's a look at when you might not need to normalize.
2016-12-10T11:12:25ZPart 7 of our tutorial introduces you to the concept of Access forms to input and modify data.
2016-12-10T11:12:25ZEntity Relationship diagrams provide database designers with a valuable tool for modeling the relationships between database entities in a clear, precise format. Learn how to create basic diagrams for your databases with this guide.
2016-12-10T11:12:25ZLet us walk you through the process of converting your Excel spreadsheet to a flexible Access 2013 database.