Lab-Chapter 7 - CSE1520.03 Computer Use Fundamentals The...

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

View Full Document Right Arrow Icon
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
Image of page 1

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

View Full Document Right Arrow Icon
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
Image of page 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
Image of page 3

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

View Full Document Right Arrow Icon
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 from different tables). Forms are used primarily to provide a simple way to enter data into
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern