Support de cours MICROSOFT ACCESS RECORDS AND FIELDS, tutoriel & guide de travaux pratiques ACCESS en pdf.
RECORDS AND FIELDS
Before creating and working with a database, it is important to understand what a database is and what it is made of.
A database is a collection of related data organized in tables. Tables consist of records and fields. A record is a row in the table that contains information such as name, address, phone number, etc. A field is a column that contains categories of information.
For example, each field in the Records table (Figure 1) contains the same type of information about a person. First Name, Last Name, Address are fields. Each record in the table (Figure 1) contains all the information about a person. P05783279, Bill Smith,123 Dorm, 555-1234, 555-7088 is a record.
When you open an Access file, whether existing or new, you will see the Database window. The Database window is the command center of your database; here you can create and use any object, such as Tables, Queries, Forms, Reports, Pages, Macros,and Modules (Figure 2). Database objects are the basic components that make up a database. For the purposes of this tutorial, we will discuss only four objects: Tables, Queries, Forms, and Reports.
Tables – used to enter, store, organize, and view data. For example, one table could store a list of students and their IDs, while another table could store the equipment that the students checked out.
Queries – used to extract data from a database. Queries ask a question of data stored in a table. For example, a query could display only students who checked out still cameras.
Forms – used to enter, edit, or view data stored in a table or a query.