Categories
Blog

Importing and Exporting Data with SQL Server

The SQL Server Import and Export Wizard allows you to quickly and easily import information into a SQL Server 2014 database from any of the following data sources: Microsoft Excel Microsoft Acces Flat Files Another SQL Server Database The wizard builds SQL Server Integration Services (SSIS) packages through a user-friendly graphical interface. Starting the SQL Server […]

Categories
Blog

Database Keys

As you may already know, databases use tables to organize information. (If you don’t have a basic familiarity with database concepts, read What is a Database?) 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? It’s through […]

Categories
Blog

SELECT TOP and SELECT TOP PERCENT Queries

With the vast number of possible queries you can make it may be difficult to determine exactly what it is you need and when you need it. In this article we will take a look at two queries that become increasingly helpful (and powerful) as your database grows. When you are faced with ploughing through […]

Categories
Blog

What Is a Blockchain Database?

The blockchain is the thing that ties bitcoin together. But how does it work? Bitcoin is a decentralized technology, meaning that no one person controls it. This is great for people that don’t trust their banks, or bitcoin speculators for example, or simply people who prefer to take control of their finances themselves to help […]

Categories
Blog

Text Formulas in Microsoft Access

Most people are adept at using numeric formulas because they are very similar between Microsoft Excel and Microsoft Access. However, text formulas are a little more complex, partly because people do not understand what they are or how to use them. A major part of the misunderstanding comes from the name; text formulas can do […]

Categories
Blog

Databases for Marketing Professionals

As a marketing professional you already deal with so many apps and software packages you are probably wondering why you should have to deal with something that is designed specifically for databases. After all, you probably already have a number of Excel spreadsheets to handle calculations, contacts and email templates in your preferred email software, […]

Categories
Blog

Databases for Fundraising Professionals

As a professional fundraiser, you know how important it is to have a reliable and easy to manage database. A good database makes it easy to manage, organize, and coordinate all of the intricacies of fundraisers, something you really need, especially if you are dealing with multiple fundraisers at the same time. Having the option […]

Categories
Blog

Conditional Functions in Microsoft Access

Microsoft Access offers the more advanced users a way around some of the most time consuming and repetitive actions by using conditional functions. Conditional functions help you reduce how much data you have to store by telling Access how to calculate or compare information in specific fields so that you don’t’ have to create an […]

Categories
Blog

Introduction to Visual Basic for Applications (VBA) in Microsoft Access

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

Categories
Blog

Microsoft Access for Teachers

Teaching is already challenging enough without adding something that is potentially troublesome and complicated, but databases can actually make the job easier. While there are a number of databases out there, usually it will be easier (and cheaper) to use the tools you already have. Of course you already have to deal with numerous types of […]