The word Backend is usually used to refer to the part of a system that the end users or clients don’t see. Take buying airline tickets online as an example. In this instance, the person buying tickets online only sees the web page. What they don’t see is the database behind the web pages and the services that get kicked off when they click “Buy”. This is what we refer to as the backend of the system.

Read the rest of this entry »

This particular tips comes from the fact that I’ve been asked this question several times now in the last few days alone, so I thought it would be a good idea to post it here: How do you put a Carriage Return in-between lines of text in a single cell? In other words, how do you use the Enter key like you would in Microsoft Word?

The answer to this is simple: Use Alt + Enter. When typing in your cell and you want to create a blank line before the next line of text starts, hold down the Alt key and press Enter. This will insert a blank line (like in Word) instead of shifting the focus to the next cell.

As I have talked about in previous articles, there are many areas where Microsoft Access and Microsoft Excel overlap. Because of this, there exists the ability to quickly interchange data between the two programs. In this article, I’m going to go over a few simple steps to transfer all of the data from a table in an Access database to an Excel spreadsheet.

Read the rest of this entry »