What is Data Manipulation – Learn to Work with Access Queries

If you are wondering what data manipulation is, look no further. Data manipulation refers to the process of filtering data based on some predefined criteria. It also refers to the process whereby we change data to a format that makes it easy to analyze. We manipulate data to make it easier to understand. Database queries … Read more

Introduction to Database Queries – Access Queries, Select Query

When using a database, it is the queries that make databases and, in turn, Access databases the wonderful tool that they are. Queries make it possible to manipulate, update and change information much faster than paper databases. They help to save a great deal of time by updating large amounts of data with a single … Read more

Audio Output Devices | Definition, Types, Installation and Issues

A computer system uses several different output devices. We group them into two categories: visual output devices and audio output devices. In this article, we will explore what audio output devices are and give some examples. We will also look at how to install an audio output device as well as how to fix the … Read more

Advanced Excel Functions – DATE, VLOOKUP, and PMT Functions

Advanced Excel functions will make your life easier on the job. From entering and changing information to doing calculations, graphing, and sorting data, Excel has all that you need. It is a great tool to make working with numbers easier and faster. Whether you are a business owner, office worker, or teacher, becoming a pro … Read more

Troubleshoot Desktop Monitor Problems – PC Running, no Display

You will encounter many computer hardware problems as you begin to work regularly on a computer. Monitor problems are just one. As a novice user, you will be tempted to call a technician when you encounter computer problems, which is fine. However, many of these issues you can solve easily with a little know-how. This … Read more

Create an Access Database – Create Tables and Set Data Types

If you are here, there is a good chance that you are learning how to create an Access database. Databases are everywhere. In fact, different types of databases have been in place for generations. They are used to collect and store all types of data to be easily accessed and analyzed. Microsoft Access tables are … Read more

Primary Key in a Database – Database Keys Explained

If you are an information technology student and you are now beginning to study or work with databases or learn database terminologies, there is a good chance you have heard of a primary key, composite key, or foreign key. But what type of keys are these, and how do you use them? In this article, … Read more