lab3-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 #3) Page 1 © Dr. Mark Llewellyn CGS 2545: Database Concepts Spring 2012 LAB #3 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 #3 – Due February 22 nd
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 #3) Page 2 © Dr. Mark Llewellyn Lab #3 • The objective of this lab is to familiarize yourself with forms and reports in Access. • Again, we will use the sample Northwind sample database from webCourses. NOTE: In the slides that follow, if the call-out symbol is outlined in red, it means that there is something for you to try, if the call-out is outlined in blue, I am simply giving you some information about what is displayed on that page.
Background image of page 2
CGS 2545: Database Concepts (Lab #3) Page 3 © Dr. Mark Llewellyn Forms Forms are primarily designed to allow users to enter data into tables in a user-friendly format that requires little if any knowledge about the actual database. Forms are also a way to display the data in a table in a more user-friendly format than is available in the Table view which looks are raw data. Often forms are designed to resemble a paper form that is utilized by a company and thereby provide a sense of familiarity for the individuals who actually enter the data. All forms contain controls (objects) that accept and display data, perform a specific action, decorate the form, or add descriptive information. There are three types of controls: A bound control (see next page) has a data source (a field in an underlying table) and is used to enter or modify data in that field. An unbound control has no data source. Unbound controls are used to display labels, titles, lines, graphics, or pictures. A calculated control has as its data source an expression rather than a field.
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 #3) Page 4 © Dr. Mark Llewellyn Forms To look at some of the already constructed forms in the Northwind database, start Access running on the database and close the main switchboard that appears in the main panel. Your Access probably has the Query option set by default, but in any case, click on the down arrow and you’ll see all the options…select Forms
Background image of page 4
CGS 2545: Database Concepts (Lab #3) Page 5 © Dr. Mark Llewellyn Forms Your Access probably has the Query option set by default, but in any case, click on the down arrow and you’ll see all the options…select Forms As you can see there are a lot of already constructed forms in this database. Scroll down to the very last one which is the Suppliers form. Double click the Suppliers form…you’ll see the form on the next page.
Background image of page 5

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

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts (Lab #3) Page 6 © Dr. Mark Llewellyn The Suppliers form is a very basic form that contains the same information as found in the Suppliers table, although it is displayed in a more user-friendly, one supplier at a time format. This format is often more
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.

Page1 / 51

lab3-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