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 […]
Month: December 2020
Database Keys
As you may already know, databases use tables to organize information. (If you dont 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? Its through […]
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 […]
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 […]
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 […]
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, […]
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 […]
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 […]
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 […]
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 […]