The Wayback Machine - http://web.archive.org/web/20160314103150/http://databases.about.com/

Databases

Jetta Productions/Stone/Getty Images

Basic Keys That Make Database Management Easy

A business man working at office - Kohei Hara/Digital Vision/Getty Images

How to Choose a 'Primary Key' for Your Database

Tara Moore/Taxi/Getty Images

Transactions

Databases Essentials
Databases Categories
Readers Recommend
View More
The Latest in Databases
Databases for Retail Shops
If you are a shop owner or manager, you already know exactly how important it is to have the right database. From inventory and shipping to employees and customers, you know that even a slow day involves a lot of data maintenance.
Filtering Query Results with Parameter Queries
Sometimes you run a query, and it returns more data than you can possible go through. Sometimes you actually need all of that data to get the best analytical results.
-
Dealing with Read-only Queries
Sometimes when you are working with Access you encounter read-only queries. Some of the queries have to be read-only, such as totals, and you are not meant to change the query results.
Office 365 -
Microsoft Access Databases in Office 365
With the release of Microsoft Office 365 in 2013, there were a number of questions about how it changed the different Microsoft programs, including Microsoft Access.
Dry Cleaning - Tanya Constantine/Getty Images
Creating Databases for Dry Cleaners
At first it may seem that dry cleaners don’t need databases, but if you have been in the business a while, you know exactly why they are vital to the industry.
Using Table Templates in Access 2013
One of the greatest perks of Access 2013 is the length of time that Access has been around. With all of the iterations and updates, there are a lot of useful tools, particularly templates.
Creating a Table -
Creating a Table with SQL Server 2014
Tables serve as the basic unit of organization for any database, including those managed by SQL Server 2014. Designing appropriate tables to store your data is an essential responsibility of a database developer and both designers and administrators must be familiar with the process of creating new SQL Server database tables. In this article, we explore the process in detail.
Forcing Encryption in SQL Server 2014 -
Encrypting SQL Server Database 2014 Connections
Encryption helps you prevent unauthorized access to information when individuals try to bypass your database security controls. For example, someone with a computer on your network might try to use a packet sniffer to monitor connections made by users to a database. Fortunately, database encryption allows you to protect the data sent over those connections from prying eyes.
Microsoft Access Function Library: Rand()
The Rand() function returns a pseudorandom number between 0 and 1.
Microsoft Access Function Library: Log10()
The Log10() function returns the logarithm of the given number with base 10.
Microsoft Access Function Library: Log()
The Log() function returns the natural logarithm of the given number. It may also be used to return the logarithm of the given number using any specified base value.
-
Application Templates in Microsoft Access 2013
Apps are one of the staples of software today, and people have come to expect them. For Microsoft Access 2013, there are several app templates that are actually extremely useful for making a number of different aspects of databases a lot easier to manage. From billing and time tracking to basic database maintenance, there are a number of established apps that can help you with all of these chores. Or you can create your own from scratch or based on information in programs like Excel and SharePoint. You can take an existing template and customize it to do what you need the app to do. If you created any apps in a previous version of Access, you can also load those and update them to work better with Access 2013.
- Andrew Olney/Getty Images
Databases for Salespeople
Being in sales comes with a host of challenges that no other position has. It is a fine balance between being helpful and being pushy, and that line changes based on who you are dealing with. Also, if you are in sales, you probably don’t like being tied down to a computer, so the idea of having to deal with a database can be a real headache. However, since you have so much information that you have to manage, you already know that you cannot get by without some sort of method to track customers, leads, and other clients.
-
Creating Traces with SQL Server 2014
SQL Profiler is a diagnostic tool included with Microsoft SQL Server 2014. 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.
Microsoft Access Function Library: Min()
The Min function evaluates the string found in expression, which may be the name of a table field, constant or function. It then returns the smallest value found there.
Prev
1
2
3
4