How To Use Database Concepts And Terminology In Access 2010


show more Database concepts and terminology provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Database concepts and terminology

Before we can began to build an Access 2010 database, it's important to understand fundamental database concepts and terminology. First, what is a database? A database is a collection of information about one subject. Real life examples might be a telephone book, a way to track your music collection, or the way your business attracts its customers in sales. A database program gives you a way to manage that data and to analyze it to make it useful. You can sort the information in many ways, extract just certain pieces of info, or summarize it in reports.

Let's take a look at the terminology you'll need. First off are Tables. A Table is one collection of information and it's organized into Fields, Records, and Data. Fields are the columns in the table. They are the categories of info you are collecting. In a phone book, these will be the person's name, address and phone number. Each is one person or thing you are collecting information about. In a phone book, each person&...

Database concepts and terminology
Video duration: 5m 35s 3h 30m Beginner

Viewers:

Database concepts and terminology provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...