COMPUTER GUIDE

ALEXIA ROQUE LEAL 1A

COMPUTER GUIDE

ACCCESS

INFORMATICS

Access

Definitions

INFORMATICS

ACCESS

DEFINITION & QUESTIONS

Questions

Definition

Microsoft Access is a database management system included in the professional editions of the Microsoft Office suite. Access is a data manager that uses relational database concepts and can be managed by means of queries and reports.

• What is a primary key?

A primary key is a field or set of fields with values that are unique throughout a table. Values of the key can be used to refer to entire records, because each record has a different value for the key.

• What is a foreign key?

A foreign key is a field (or fields) in one table that references the primary key in another table.

INFORMATICS

DEFINITIONS

ACCESS

• Data

+info

• Information

+info

• Table

+info

• Null

+info

• File

+info

• Record

+info

• Field

+info