ACCESS CHAPTER 2 Introduction to ACCESS Learning Objectives

ACCESS CHAPTER 2 Introduction to ACCESS Learning Objectives: l Understand ACCESS icons. l Use ACCESS objects, including tables, queries, forms, and reports. l Open and display tables. l Retrieve information with queries. l Create and use forms to display and modify table contents l Design and use reports.

ACCESS OBJECTS: l Tables: All database information is stored in tables comprised of rows (attributes) and columns (tuples) l Queries: A question you ask about one or more tables in your database l Forms: A simple way to enter, change, or display data l Reports: A convenient way to consolidate and group information that is stored in a database for publication or reporting purposes.

ACCESS CHAPTER 2 Introduction to ACCESS TASK 1. open and change a table display Exercise 2. 4: opening a table Exercise 2. 5: searching a row containing a particular value Exercise 2. 6: changing a table’s display characteristics Exercise 2. 7: sorting a table Complete Exercise 1 on page 103 and print the sorted table. TASK 2. query a database Exercise 2. 8: running a query Exercise 2. 9: creating a one-table query Exercise 2. 10: writing selection criteria using an “AND” operating Exercise 2. 11: forming an “OR” query Complete Exercise 2 on pages 103. Print the resulting dynasets. Complete Problem 1 on page 104. Print the resulting dynasets. TASK 3. use forms Exercise 2. 12: opening and using a form Exercise 2. 13: editing data with a form Exercise 2. 14: filtering data through a form Complete Problem 2 on page 104. Print the FIRST TWO PAGES of the form. TASK 4. design reports Exercise 2. 15: loading and reviewing a report Exercise 2. 16: creating a report quickly Exercise 2. 17: saving a report Complete Problem 3 on page 104 and print the FIRST TWO PAGES of the report.