MICROSOFT ACCESS

Database Management SystemStores and tracks information

Inventory Customer Data Sales

A database is an organized collection of information about a subject.

WHAT IS ACCESS?

TYPES OF OBJECTS

Tables are a collection of records that share the same field. Information is stored in rows

and columns.

TYPES OF OBJECTS

Queries are ‘questions’ that provide sorted, filtered, or summarized data.

TYPES OF OBJECTS

Forms are an interface for data entry and lookup.

TYPES OF OBJECTS

Reports are printable views of tables and query data.

Database that has multiple tables with relationships that connect them.

RELATIONAL DATABASE

Table

Field

Primary Key

A piece of data that helps describe the record

FIELDS

All of these fields make up one record.In this case – all the details about one

employee

A unique field that identifies records in a table

PRIMARY KEY

At THS, your ‘primary key’ is your Student ID Number

A collection of information (fields) about something specific

RECORD

Records are the data for your business.

TABLE DESIGN VIEW

The view that lets you add, edit, and delete fields from a table.

You will be creating your tables in Design View!