2016-10-27T11:03:32ZIn 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.
2016-10-27T11:03:32ZThe 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.
2016-10-27T11:03:32ZLearn to retrieve information from your database with the SQL SELECT statement.
2016-10-27T11:03:32ZWhat is a determinant? Find out here!
2016-10-27T11:03:32ZLearn to create databases and tables using the Structured Query Language (SQL) in this step-by-step tutorial from your About.com Guide to Databases.
2016-10-27T11:03:32ZDo your databases contain fields where users have entered a mess of information in a variety of different formats? Microsoft Access input masks may help you alleiviate this inconsistency in your desktop databases. Input masks allow you to specify the format of allowable user input, preventing users from entering information in a form that does not meet your data quality requirements.
2016-10-27T11:03:32ZYou've finally buckled down and decided that it's time to purchase a database solution for your home or business. What type of database do you need? It's actually a simple matter of deciding what features you need and choosing a product that meets your requirements and doesn't cause too much pain in your pocketbook.
2016-10-27T11:03:32ZTraces 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-10-27T11:03:32ZMicrosoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. In this tutorial, we'll walk through the process of creating an Access database using these templates.
2016-10-27T11:03:32ZDesktop databases offer simple, flexible solutions for data storage and retrieval. They're often quite sufficient to meet uncomplicated database requirements for both small and large organizations. If you're not sure if a desktop database is right for you, try reading the Choosing a Database series of articles which cover both desktop and server databases in depth
2016-10-27T11:03:32ZAre 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-10-27T11:03:32ZMicrosoft’s release of the SQL Server 2014 enterprise database management platform marks a major evolution in this popular product. Organizations seeking to license Microsoft's SQL Server database platform should have a clear understanding of the various editions available before making a purchase.
2016-10-27T11:03:32ZIt's important to do a careful needs analysis before you dive in and commit to a database solution. Learn the difference between desktop and server databases.
2016-10-27T11:03:32ZIf 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.
2016-10-27T11:03:32ZJust 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-10-27T11:03:32ZWith 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-10-27T11:03:32ZLearn how to create a simple form in Microsoft Access. This tutorial walks you through the process step-by-step!
2016-10-27T11:03:32ZIf youre a Microsoft Office power user, you might be familiar with the encryption features of Word, PowerPoint and Excel. These programs all allow file owners to easily apply encryption. Unfortunately, Microsoft Access doesnt offer similar functionality, but it still has relatively powerful security functionality. In this article, well take a look at Microsoft Access user-level security, a feature that lets you specify the level of access to grant each individual user of your database.
2016-10-27T11:03:32ZLooking for a definition of a database instance? Look no further!
2016-10-27T11:03:32ZAfter making tweaks and changes to a query, it can be difficult to remember exactly what changes pulled which results. This is one very good reason to get accustomed to saving queries with some frequency, even if they don’t provide exactly what the user is looking for at the time.
2016-10-27T11:03:32ZUsers new to the world of databases are often confused by a special value particular to our field – the NULL value. Read about the proper uses of NULL in this article.
2016-10-27T11:03:32ZStarting 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.
2016-10-27T11:03:32ZThis sample Excel document contains student course registration data for use in generating pivot tables. It should be used in conjunction with the Creating Pivot Tables in Excel 2010 tutorial found on this site.