ACCESS CHAPTER 2 Introduction to ACCESS

1
ACCESS CHAPTER 2Introduction to ACCESS

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

2
ACCESS OBJECTS

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

3
ACCESS CHAPTER 2Introduction 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 tables 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