Lecture 05 - Introduction to Access

Lecture 05 - Introduction to Access - Introduction to...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Introduction to Microsoft Access
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
What is Access? Access is a relational database  management application that is used to  create and analyze a database. 
Background image of page 2
What is a Database? As you already know a database is a  collection of related data. 
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Relational databases In a relational database, data are  organized in related tables.  The tables are related or linked to one  another by a common field.  Relational databases allow you to create  smaller and more manageable database  tables, since you can combine and  extract data between tables.
Background image of page 4
Some features of Access Has tools to enter, edit, and retrieve data from  the database as well as to analyze the database  and produce reports.  Ability to quickly add, delete, and locate specific  records.  Records can also be easily rearranged or sorted  according to different fields of data, resulting in  multiple table arrangements that provide more  meaningful information for different purposes. 
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Queries You can ask questions of (query) the 
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/10/2008 for the course CIS 220 taught by Professor Soper during the Spring '08 term at ASU.

Page1 / 20

Lecture 05 - Introduction to Access - Introduction to...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online