Skip to main content

What is database?

Access 2010 is a database creation and management program. To understand Access, you must first understand databases. 

In this lesson, you will learn about databases and how they are used. You will familiarize yourself with the differences between data management in Access and Microsoft Excel. Finally, you will get a look ahead at the rest of the Access course. 

What is a database? 

A database is a collection of data that is stored in a computer system. Databases allow their users to enter, access, and analyze their data quickly and easily. They’re such a useful tool that you see them all the time. Ever waited while a doctor’s receptionist entered your personal information into a computer, or watched a store employee use a computer to see whether an item was in stock? Then you’ve seen a database in action. 

The easiest way to understand a database is to think of it as a collection of lists. Think about one of the databases we mentioned above—the database of patient information at a doctor’s office. What lists are contained in a database like that? Well, to start with, there’s a list of patient names. Then there’s a list of past appointments, a list with medical history for each patient, a list of contact information.. 

This is true of all databases, from the simplest to the most complex. For instance, if you like to bake you might decide to keep a database containing the types of cookies you know how to make and the friends you give those cookies to. This is one of the simplest databases imaginable. It contains two lists: a list of your friends, and a list of cookies. 

However, if you were a professional baker you would have many more lists to keep track of: a list of customers, a list of products sold, a list of prices, a list of orders ... it goes on and on. The more lists you add, the more complex the database will be.

Labels:

Comments

Post a Comment

Popular posts from this blog

Chapter 7 - Copying, moving, renaming, and deleting files.  

Chapter 7 - Copying, moving, renaming, and deleting files.   we will discuss the basics of managing your files from the command line.   COPYING FILES   One of the most useful features of the modern PC is the ability to swiftly copy files from one location to another. Practically every computing device has the ability to copy files. The Windows operating system and the Command Prompt are no different. The basic command for copying files from the Command Prompt is the COPY command. If you wanted to use COPY to copy a file called test.txt to the root directory of a USB flash drive assigned the letter J: COPY test.txt J:\ The command will create a copy of test.txt in the root directory of the J drive. Like most Command Prompt commands, COPY assumes that you will be copying files from the working directory, and looks there first to find the filenames you specify. However, you can also use COPY with absolute file paths. If test.txt were in the Users directory of the C...
Post a Comment
Read more

Gallery

photos
Post a Comment
Read more
How to slide in Word Procedure is useful for creating presentations on PCs without PowerPoint By Helito Beggiora, for TechTudo 08/04/2019 08:01 Updated há 16 horas You can create slides in Word with a few simple settings. The feature is useful if your PowerPoint application is in trouble and you need to produce a presentation in a hurry. To do this in the text editor, you need to make adjustments in the orientation and size of the sheets, change the margins, and manually insert titles and topics into large fonts. In the following tutorial, check out how to make slides in Word from the PC. The procedure was performed in the latest version of Office 2016 , but the tips are also valid for users of previous editions of the Microsoft program . Eight hidden functions of Word that will streamline your work How to insert line in Word Want to buy cell phone, TV and other discount products? Compare TechTudo Step 1. Open a new Word document and go to the "Layout" tab. Then go...
Post a Comment
Read more