Lesson7XP - Lesson 7: Introduction to the Access Database...

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

View Full Document Right Arrow Icon
Lesson 7: Introduction to the Access Database 193 7 INTRODUCTION TO THE ACCESS DATABASE Keeping student records LEARNING OUTCOMES In this tutorial you will learn about databases in general and about the Access database in particular. The concept of a database is not as easy to grasp as that of a word processor or a spreadsheet. So if this is the first time you are learning about databases you would be well advised to read over the lesson first, away from the computer, and perhaps highlight the text to ease understanding. Specifically this tutorial will introduce you to the following: • the general idea behind a database • planning a new database • creating a database template • adding records to a new or existing database • viewing the data in a database • clearing entries and records from a database • making a backup copy of a database A caveat before you begin: You'll find it easiest to use the tutorial if you follow the directions carefully. On computers there are always other ways of doing things, but if you wander off on your own be sure you know your way back!
Background image of page 1

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

View Full DocumentRight Arrow Icon
ESSENTIAL MICROSOFT OFFICE XP : Tutorial for Teachers Copyright © Bernard Poole, Lorrie Jackson, Rebecca Randall, 2002. All rights reserved 194 7.1 AN OVERVIEW OF THE DATABASE CONCEPT The database component of MS Office is designed to act as an "intelligent" 1 electronic filing cabinet. Like a manual filing cabinet, it enables you to • collect sets of related data and keep the data organized; • update the data once you've collected them, by adding or deleting records and by changing existing records; An electronic filing cabinet such as a database allows you also to easily and quickly use the data- -sort them, create reports, merge the data with other documents, and so forth. How is a database organized? Access is an object-oriented relational database management system. The objects that make up any particular database that you create using Access are illustrated in Fig. 7.1. Fig. 7.1 The Access database objects 1 The word "intelligent" is enclosed in quotes so as not to create a false impression. With regard to computers, the word is overused, and strictly speaking inappropriate. It also can be misleading. The only "intelligence" exhibited by these otherwise "dumb" machines has been programmed into them by intelligent human beings.
Background image of page 2
Lesson 7: Introduction to the Access Database 195 A Table is an object which represents the data in rows and columns, rather like a spreadsheet. For this reason, when you view a table in an Access database, you are in what Access refers to as a Datasheet View . You will learn about Tables in this lesson. A Query is an object which makes a request to the database to find some set of data that is stored in the database. You will learn about queries in Lesson 8. A
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/22/2010 for the course CMSY 103 taught by Professor N/a during the Fall '06 term at Howard County Community College.

Page1 / 29

Lesson7XP - Lesson 7: Introduction to the Access Database...

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

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