Cee3804_databases

Cee3804_databases - CEE 3804: Computer Applications...

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

View Full Document Right Arrow Icon
CEE 3804: Computer Applications Databases and Pivot Tables Dr. Trani
Background image of page 1

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

View Full DocumentRight Arrow Icon
CEE 3804 Slide 2 Spring 2008 1. Topics to be Covered Lists and databases Database functions Pivot tables: Basics Pivot table reports
Background image of page 2
CEE 3804 Slide 3 Spring 2008 Working with Lists and Databases a. Basic Definitions A list is a collection of related information with  an organizational structure In Excel a List is defined as: a worksheet range that has the following properties: field: a single type of information (e.g. name, address, etc.) field value: a single item in a field field name: a unique name you assign to a field (located in  first row of list) record: a collection of associated field values (each row) list range: the worksheet range that includes all records,  fields, and field names
Background image of page 3

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

View Full DocumentRight Arrow Icon
CEE 3804 Slide 4 Spring 2008 Working with Lists and Databases b. Inserting Records Enter data directly into worksheet Add a record: Insert/Rows Add a field: Select a column and Insert/Columns Delete a record: Select entire row and Edit/Delete Enter data using the data form: Data/Form
Background image of page 4
CEE 3804 Slide 5 Spring 2008 Working with Lists and Databases c. Finding Records Load the database form: Set criteria or multiple criteria using the criteria button Find the item by clicking on the Find Next button Criteria: * : wild card to substitute any number of characters ? : wild card to substitute a single character >, <, =, >=, <=
Background image of page 5

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

View Full DocumentRight Arrow Icon
CEE 3804 Slide 6 Spring 2008 Working with Lists and Databases d. Sorting Lists Lists can be sorted using Data/Sort: Blanks always sorted last All error values are equal
Background image of page 6
CEE 3804 Slide 7 Spring 2008 Working with Lists and Databases e. Data Filtering - Basics Data/Filter/AutoFilter: Standard criteria Custom Filter: Custom criteria And/Or criteria
Background image of page 7

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

View Full DocumentRight Arrow Icon
CEE 3804 Slide 8 Spring 2008 Working with Lists and Databases f. Data Filtering - Advanced Data/Filter/Advanced Filter
Background image of page 8
CEE 3804 Slide 9 Spring 2008 Database Functions a. Overview Functions that provide pivot table functionality Dfunction( database,field,criteria ): database:  range of cells that make up the data field:
Background image of page 9

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

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

This note was uploaded on 01/01/2012 for the course CEE 3804 taught by Professor Aatrani during the Spring '07 term at Virginia Tech.

Page1 / 38

Cee3804_databases - CEE 3804: Computer Applications...

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

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