lab 7 fall 07

lab 7 fall 07 - CNA 169 Lab 7 Due Monday, December 3 A...

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

View Full Document Right Arrow Icon
CNA 169 Lab 7 Due Monday, December 3 A database is an organized collection of information on one subject. For this lab, you will make a database of DVDs or books. Create Table A database is made up of tables. This lab uses one table made up of the fields ID, Genre, Title, Author, and Producer, studio, or publisher. Fields are created in design view. The first field is typically some kind of identification field and usually designated the primary key. Once the fields are defined, data is entered. We will use the Datasheet view, which looks like a spreadsheet. The fields are at the top of columns. Data is entered in rows. Each row is called a record. 1. Start Microsoft Access and create a new database. Save this database as Lab7_Last_First (your last and first name) in the database folder of your cna169 folder. 2. Set Design view. Create a new table with appropriate name (not Table1). 3. Add five fields. Include the Field Name, Data Type and Description for each. 4.
Background image of page 1

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

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

Page1 / 2

lab 7 fall 07 - CNA 169 Lab 7 Due Monday, December 3 A...

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

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