MIS1305-Access 2007- ALL Lectures

MIS1305-Access - o AND OR • Determine Sorting • Hiding Unnecessary Fields • Multi Table Query • Running the Query Page 2 of 4 2-Forms&

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

View Full Document Right Arrow Icon
Outline 1-Introduction 2-Queries Access 2007 Interface (label the objects) Page 1 of 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
1-Introduction What is a Database? What is Access? Objects: Tables, Queries, Forms, Reports 2-Queries Purpose Creating a Query Query By Example Identify the Table Identify the Fields Identify the Rows (Criteria) o Typical Mathematical Operators o IN, LIKE, BETWEEN
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: o AND, OR • Determine Sorting • Hiding Unnecessary Fields • Multi- Table Query • Running the Query Page 2 of 4 2-Forms & Reports Purpose Creating a Form or a Report • Use the Wizard • Identify the Table/Query to be used • Identify the Fields • Identify the Layout Page 3 of 4 • Using the Form or Report Page 4 of 4...
View Full Document

This note was uploaded on 05/07/2008 for the course MIS 1305 taught by Professor Dr.moshinske during the Spring '07 term at Baylor.

Page1 / 4

MIS1305-Access - o AND OR • Determine Sorting • Hiding Unnecessary Fields • Multi Table Query • Running the Query Page 2 of 4 2-Forms&

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

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