Access - Queries

Introduction

One of the most powerful elements of a data base is the capacity to make a search on a mass of data stored in the data base. It is then possible to make analyses and to take out of it trends. For example, you don't need to see all the list of the customers if you need only the phone number of one of them. There are also queries for certain queries of action such as the update and the deletion of data.

Access - Tables

Introduction

You will find in the tables three important elements of a database; the list of fields, the properties of each one and the data that's in them.Tables are structured. The structure contains the list of fields as well as the properties or the characteristics of these fields. This page gives you not only the information to create of a table, but also how add and change fields in it.