What is the computer program called access

To me these are the rules of a relational database:. To explain this I will give an example below:. For the purpose of this example, we will be looking at a Library data base from a relational database viewpoint.

For a Library database we would want to collect the following information:. You may be tempted to include all this information within the one table. Once you start entering data the following occurs:.

Entering data this way requires multiple entries and duplicate data in some of the columns. This can lead to the following problems:. Therefore, to meet the rules of a relational database we would first break this one large table into smaller tables of like information categories. The next step is to list all the facts you think are required for each of these tables underneath them.

I have included the examples below for each of the tables for the library database. The primary key and foreign key fields will be explained a bit later. The fields have been broken down in to their smallest logical part. The information is only recorded once, i. Primary Key - Unique Identifier. An important part of determining the fields for each table is deciding which field if any is suitable as the primary key.

For this reason, one field or a set of fields needs to be unique. This can be a unique identification number such as a Medicare number, Employee ID number, Pension number, etc. If a unique identifier cannot be identified which is more than likely , you can add a field, which will automatically increase sequentially by one, thus providing the record with a unique identifier.

Foreign Keys. The Foreign Key is the field that links a related table to the main table. Therefore, the loan table would contain many links to a particular borrower and many links to a particular book, but each loan record would relate to only one book and one borrower.

This is illustrated below:. These fields are known as foreign keys FK. Note: that only the ID field is kept in the loan table, no other information is needed from the borrower table or the book table.

By setting up relationships between the tables, Microsoft Access knows which foreign key belongs to which primary key unique identifier and can pull the information from the relevant tables when needed.

So it some it all up. What is Microsoft Access, well it is a relational database found in the Microsoft Office suite. If you would like a free copy then just fill in the form below. Or if a video tutorial is more your thing, try Learn IT anytime. Please enter the word that you see below. What does via the web mean. How do you upload a video in you tube. When streaming videos are supplied via the Web they are often called. Q: What is the software called that allows you to access the Internet? Write your answer Related questions.

What kind of hardware or software blocks access from the internet to a networked computer? What is a legal agreement that allows multiple users to access software on a server simultaneously? What is the Microsoft Internet explorer software program called that allows you to view the contents of the web? The software from Microsoft that enable indivuduals to save and access office documents on the internet is called? What is a software program used to access the internet?

Microsoft internet explorer is a software program called that allows you to view the contents of the world wide web? What is Internet explorer called? The feature that allows users on different computers to access the internet through a single connection is called? What is called a feature that allows users on different computers to acces the internet through a single connection? Background software that allows the computers to work is called? What is a software that is available on-demand via the internet is called?

How do you receive a fax on your computer? What type of software program is Microsoft access? Access points or junctions to the internet backbone are called? What are the latest trends in computer software?

What is remote access system? Microsoft internet explorer is a software called what? What is the most informative recipe software that is also free? What is a computer that controls access to hardware and software on a network called? How do you acess internet without connection? How do you trace your stolen computer through the internet?

Microsoft internet explorer is a software program called? Software needs to be installed onto a computer before it can be used. Software is often sold in sets of several programs and associated data called a software package , and typically comes on a CD-ROM or may be downloaded from the Internet.

The Microsoft Office Suite is such a collection of programs and data that allows users to manipulate words, numbers, and data. There are two major categories of software: System software and Application software. System software includes the operating system, utilities , and computer programming tools. The operating system allows application software to access system resources without the applications having to know the details about the system hardware.

The operating system often allocates resources and processing time between several programs which are running at once, which is called multitasking. Multitasking allows you to perform multiple tasks at the same time, such copying a chart from an open Excel document and pasting it into a report you have open in Word, all while your web browser is downloading a large file from the Internet in the background.

It is the OS that plays traffic cop in this situation, deciding which program gets time on the CPU when, and handles the flow of data. The operating system also includes software that provides the user with a operating environment for interacting with the computer. Windows includes a GUI user environment. High-end microcomputer workstations, file servers, and mainframes often run some variation of the Unix operating system. System software also includes the software needed to access a peripheral device connected to the computer.

The device drivers may come already installed in the OS, or you may have to install or update a driver when you add a new peripheral device. System software may also include security software, such as Virus checkers and firewalls. A virus checker searches files for potentially harmful programs such as viruses , worms, or trojan horses that are written by malicious programmers.

Viruses and similar programs can perform disastrous activities on your computer system, such as erasing your hard disk. Note: There are vastly fewer viruses that affect Macintosh computers than affect PCs. A firewall , or similar program, protects your computer from unauthorized access over a network or telecom connection. Utilities are programs that perform a very specific task, usually related to managing system resources such as disk drives, printers, etc.