Microsoft Access Introduction to objects, Lecture notes of Mathematics

Download Microsoft Access Introduction to objects and more Lecture notes Mathematics in PDF only on Docsity!

z

Introduction to

Objects

Microsoft Access

Introduction to Objects

Databases in Access are composed of four objects:

 Tables

 Queries

 Forms

 Reports

Together, these objects allow you to enter, store, analyze,

and compile data however you want.

Introduction to Objects

TABLES

Rows and columns are referred to as records and fields. A field is more than just a column; it’s a way of organizing information by the type of data it is. Every piece of information within a field is of the same type. For example, every entry in a field called First Name would be a name, and every entry in field called Street Address would be an address.

Introduction to Objects

TABLES

A record is more than just a row; it's a unit of information. Every cell in a given row is part of that row’s record. Even though the information in each record is organized into fields, it belongs with the other information in that record.

Introduction to Objects

Used for entering , modifying , and viewing records.

The reason forms are used so often is that they're an easy

way to guide people toward entering data correctly. When

you enter information into a form in Access, the data goes

exactly where the database designer wants it to go: in one

or more related tables.

FORMS

Introduction to Objects

 Forms make entering data easier. Working with extensive tables can be confusing, and when you have connected tables you might need to work with more than one at a time to enter a set of data.  with forms it's possible to enter data into multiple tables at once, all in one place.  Database designers can even set restrictions on individual form components to ensure all of the needed data is entered in the correct format.  All in all, forms help keep data consistent and organized, which is essential for an accurate and powerful database.

FORMS

Introduction to Objects

QUERIES

way of searching for and compiling data from one or

more tables.

Running a query is like asking a detailed question of your

database.

When you build a query in Access, you are defining

specific search conditions to find exactly the data you

want.

Introduction to Objects

QUERIES

A well-designed query can give information you might not be able to find just by looking through the data in your tables.

Introduction to Objects

REPORTS

The ability to present your data in print.

Example: computer printout of a class schedule, printed invoice of a

purchase

Reports are useful because they allow you to present components

of your database in an easy-to-read format.

You can even customize a report's appearance to make it visually

appealing.

Access offers you the ability to create a report from

any table or query.

Introduction to Objects

REPORTS

Example: electronic card catalog to search for a book at the library

Example:z electronic card catalog to search for a book at the library

When you performed your search, you were entering your

search terms into a form that then created and ran

a query based on your request. When the query finished

searching the database's tables for records that matched

your search, you were shown a report that drew information

from the query and the related tables—in this case, a list of

books matching your search terms.