Variables vs. Consonants – Programming Fundamentals

This article on programming fundamentals seeks to introduce the idea of variables and consonants. We explain what these concepts mean and when to use each in a computer program. Variables and consonants contain values that are used in calculations. However, each of these has a different use, and understanding this will help us to know … Read more

Calculated Field In Access Query – Work with Dates in Access Query

A calculated field in Access Query is used to generate new information. It does not affect the information already in the table. Instead, it allows the user to generate additional information by doing calculations. For instance, what if you had a database table containing the date of birth of all the students in a school, … Read more

Troubleshooting Computer Battery Issues

Everyone will have computer battery issues at some time, especially if you work with laptop computers or other mobile devices. This is because these devices’ mobility is heavily dependent on the need for a working, rechargeable battery. Desktop computers also have CMOS batteries that allow them to keep the correct time even when the computer … Read more

Creating a Database Report and Form – Access Report and Form

This lesson was created to teach you how to create an Access report and form. For the most part, Access reports and Access forms are pretty simple and easy to create. However, for newbies who have never worked with database reports, this article will help you overcome any difficulties you may have encountered. In this … Read more

Learn How to Set Up an Update Query in Microsoft Access

If you are here, chances are you have been working with or studying Access databases and you are interested in learning about the MS Access update query. Queries are very powerful. They help us to search, manipulate and change information in thousands of records quickly and easily. You will never be an expert at databases … Read more

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