Lab-Chapter 7 - CSE1520.03 The Glade Computer Use:...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: CSE1520.03 The Glade Computer Use: Fundamentals Laboratory Handbook Chapter 7 Introduction to the Microsoft Access Database Objectives This laboratory exercise introduces the database called Microsoft Access. You will explore the help manual that is provided with Access, examine a previously created database and modify this previously created database. This lab is restricted to a database that consists of just one table. This lab will cover: Adding a new field to a table Adding and deleting records Creating a Form Creating a Report Creating a Query Preparation Read the whole of the chapter before beginning the exercises. Exercise 1 The Help Manual Launch Microsoft Access from the Start/Programs/Microsoft Office menu. Access 2003/2002: A window will appear asking if you want to create a new database or open an existing database. Do neither just click on the Cancel button. You will now just have an empty window for the Microsoft Access application. Click on Help from the command menu and choose Microsoft Access Help . In the help wizard balloon type Get Started and then click on the Search button. Then choose Get Started with Microsoft Access 2002 followed by Using a database for the first time . The window shown in Figure 7.1a appears, and you should read carefully the sections named: Databases: What they are and how they work Tables: What they are and how they work Queries: What they are and how they work Forms: What they are and how they work Reports: What they are and how they work Use the Back button to return to the window shown in the figure when you have finished reading a section. Within a section there are a few pages to read as indicated by the numbers that appear at the top left of the window once you enter a section. 7-1 The Glade CSE1520.03 Computer Use: Fundamentals Laboratory Handbook Figure 7.1a the introductory help material Access 2007: A welcome window will appear with the banner Getting Started with Microsoft Off ice Access across the top. Click on the question mark at the top right corner of the Access window and the Access Help window shown in Figure 7.1b appears, and you should read carefully the sections named: Getting started Database design Database basics Tables Queries Forms 7-2 CSE1520.03 The Glade Computer Use: Fundamentals Laboratory Handbook Reports Figure 7.1b the introductory help material Use the Back button to return to the window shown in the figure when you have finished reading a section. Within a section there are a few pages to read as indicated by the numbers that appear at the top left of the window once you enter a section. 7-3 The Glade CSE1520.03 Computer Use: Fundamentals Laboratory Handbook You should gather from reading this information that tables - more commonly called relations - within a database somehow divide up the data into topics. Queries on the other hand are used to retrieve data from the database (sometimes by combining data...
View Full Document

This note was uploaded on 12/09/2010 for the course CSE CSE 1520 taught by Professor Paul during the Fall '09 term at York University.

Page1 / 21

Lab-Chapter 7 - CSE1520.03 The Glade Computer Use:...

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

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