Table of ContentsPPT Slide Open a Access Database The database window Database Tables Table Selection Design View Database Table Columns in the Table Design Access Data Types Access Data Types Access Data Types Access Data Types Filled in Table Design Datasheet View Records Added to Datasheet Two Views Form View Maintenance Find, Filter, Query Query Language Find or Filter or Query Find To Find Records in a DB Table Find Find Filters Filters Filter Filter/Query Database Window Queries Queries Show Table Select Query Window The Select Query Window Parts of the Query Design Window the table(s) used in the query Parts of the Select Query Window the design grid Field Table: Sort: Show: Criteria Our Question (Query)? Filled in Select Query Window to Answer our Question The Results Access Automatic “FILL” String Criteria Our Next Question? Select QueryWindow Parts The Results OR Or Conjunction Numeric Criteria - Logic Operators Select Query The Results Select Query Criteria The Results Select Query The Results Access Automatic “FILL” Simple Selection Query And Conjunction Combining Multiple Conjunctions Design Query PPT Slide PPT Slide PPT Slide Design Query PPT Slide Three fields using AND and OR Meaning Questions |
Author: Dolores Zage
Email: dmz@cs.bsu.edu Home Page: http://www.cs.bsu.edu/homepages/dmz/cs104/lecture/ |