lab1-Access2010 - CGS 2545: Database Concepts Spring 2012...

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

View Full Document Right Arrow Icon
CGS 2545: Database Concepts (Lab #1) Page 1 © Dr. Mark Llewellyn CGS 2545: Database Concepts Spring 2012 LAB #1 Department of Electrical Engineering and Computer Science Computer Science Division University of Central Florida Course Instructor : Dr. Mark Llewellyn Lab Instructors : Arun Kulshreshth and Chris Ellis Includes Lab Assignment #1 – Due January 25 th
Background image of page 1

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

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts (Lab #1) Page 2 © Dr. Mark Llewellyn Lab #1 The objective of this lab is to familiarize yourself with the basic workings of the Access DBMS. Step #1 – Download Northwind database from WebCourses. We’ll be using this sample database for several labs. Save this database where you can easily get to it. NOTE: In the slides that follow, if the call-out symbol is outlined in red, it means that there is something for you to do or try, if the call-out is outlined in blue, I am simply giving you some information about what is displayed on that page. For the red call-outs on a given page, do them in numerical order.
Background image of page 2
CGS 2545: Database Concepts (Lab #1) Page 3 © Dr. Mark Llewellyn Lab #1 Step #2 – Start Access. There are a couple of different ways to do this depending on what you want to do during your session with the DBMS. If you are going to work exclusively with an already created database, it is easiest to just double-click on the database. Since that is what we are doing this time, just go to the location where you stored the Northwind database (the actual file name is: Northwind.accdb), and double-click on the file. Access will start and you should see the screen as shown on the next page. Page 5 shows the basic parts of the Access window. The second way to start Access is by clicking on the Start button, locating Access, start Access, then inside access click the File tab and select a database to open. We’ll do this later.
Background image of page 3

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

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts (Lab #1) Page 4 © Dr. Mark Llewellyn 2. The main switchboard will appear. For now we’ll make this disappear by clicking here. Now you should see the screen on the next page. 1. Access will display a “Security Warning - certain content in the database has been disabled”. Simple click the “enable content” button.
Background image of page 4
CGS 2545: Database Concepts (Lab #1) Page 5 © Dr. Mark Llewellyn Ribbon with command groups arranged on tabs Object tab Table Tools active now Object window Navigation Pane Object window Close button
Background image of page 5

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

View Full DocumentRight Arrow Icon
(Lab #1) Page 6 © Dr. Mark Llewellyn 1. Click on the Shippers table in the Tables listing. You’ll see this table appear in the main window. 2. Close this table and select some of the other tables and view the data in the tables. Notice the various vertical and horizontal scroll bars that appear in the different tables to allow you to view the entire contents of a table. If you don’t close the table the new table will overlay any open tables. Try this too. These icons allow you to
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 02/15/2012 for the course CGS 2545 taught by Professor Markllewellyn during the Spring '10 term at University of Central Florida.

Page1 / 37

lab1-Access2010 - CGS 2545: Database Concepts Spring 2012...

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