access2000 - Introduction to Access 2000 Department of...

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

View Full Document Right Arrow Icon
Department of Client Services Information Technology Systems Division Introduction to Access 2000 1/01 Seminar at a Glance Review of Database principles Planning the table design Creating a Database Creating Tables Establishing Relationships between the tables Creating Forms for data entry Creating a Query Creating Mailing Labels
Background image of page 1

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

View Full DocumentRight Arrow Icon
Client Services Intro to Access 2000 UNC Wilmington 2 Review of Database principles As we discussed in the Understanding Databases workshop, Access databases consist of the following objects: Tables, Queries, Forms and Reports. Access is a relational database, meaning that objects in Access relate to each other by common fields, or primary keys. The most common relationships between objects are one-to-one, and one-to-many. In this workshop we will learn how to create each object and learn how they relate to each other. Planning the table design A well organized table design is essential to the usefulness of a database. Before you create a table in Access, consider the type of reports you want to produce. The planning process should include the following: 1. Examine the data that you want to include, and determine the categories (fields) of information that you need and what data types they should be. 2. Decide if this information is closely related and should be in one table or if it should be split into multiple tables. 3. Anticipate what questions will be asked about the data and how you will want to group the data. 4. Sketch the reports that you will need to produce. Creating a Database Open Microsoft Access by clicking on the Start button and going to Programs.
Background image of page 2
Intro to Access 2000 Client Services , 3 UNC Wilmington Choose Blank Database and click OK. Save the database as Faculty Info and click Create . Creating Tables We are going to create a database of faculty information, and from that we will be creating summaries of the faculty teaching schedules and address mailing labels. We have the following information to work with: Faculty name Home Address Email address Office location Phone Course number Location Time Office hours
Background image of page 3

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

View Full DocumentRight Arrow Icon
Client Services Intro to Access 2000 UNC Wilmington 4 Creating the Faculty Information table We can create one table with the faculty name, home address, email address, office location and phone. The primary key would be the email address because it is unique (i.e. no two people have the same email address). We can then use the email address in the second table as a link to the first table, and have email address, course number, location and time. In the Tables window/tab, click the new button and choose the Table Wizard. Click OK. Choose the Employees Sample Table and select each of the following: FirstName, LastName, EmailName, Address, City, StateorProvince, PostalCode, OfficeLocation, and Extension, clicking on the right arrow button after each one to move it to your new table. Click on the Next button. The next window asks you to name the table.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 16

access2000 - Introduction to Access 2000 Department of...

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