CS1000 ACED2400 INTRO. TO COMPUTERS COMPUTERS IN THE WORKPLACE

1
CS-1000 / ACED-2400INTRO. TO COMPUTERS /
COMPUTERS IN THE WORKPLACE

• DEWEY L. EDWARDS, JR., M. ED. /
• DON KOSKI, M.B.A., M.A.M.
• VSU - KINGS BAY CENTER
• WEEK 5

2
MICROSOFT ACCESS TOPICS

• DIFFERENCES BETWEEN A DATABASE AND SPREADSHEET
• DATABASE
• ADVANTAGES OF ACCESS OVER EXCEL
• PURPOSE OF A FORM
• QUERY

3
MICROSOFT ACCESS TOPICS

• PURPOSE OF A QUERY
• WILDCARDS
• REPORTS
• PURPOSE OF A REPORT

4
DIFFERENCES BETWEEN A DATABASE AND SPREADSHEET

• ACCESS IS USED FOR CREATING AND MAINTAINING
  DATABASES
• EXCEL IS USED FOR CALCULATING DATA IN TABLE FORM
• DATABASES HAVE FORMS, SPREADSHEETS DONT
• DATBASES HAVE A KEY TO LINK ALL THE DATA TOGETHER

5
DATABASE

• A DATABASE IS A COLLECTION OF DATA. AN ADDRESS
  BOOK OR PHONE DIRECTORY ARE WELL KNOWN DATABASES.

6
ADVANTAGES OF ACCESS OVER EXCEL

• ACCESS CAN SORT DATA BETTER THAN EXCEL.
• ACCESS CAN HAVE MORE THAN ONE TABLE
• ACCESS CAN DO REPORTS, EXCEL CANT DO REPORTS
• ACCESS CAN DO QUERIES, EXCEL CANT DO QUERIES

7
PURPOSE OF A FORM

• The purpose of a form is to provide a method of
  entering data into the database in a an easy to
  use format.
• The form information automatically goes into a
  corresponding table.
• Ex entering names, address, phone into a form
  when making an address book with MS Access.

8
QUERY

• A query searches out or locates data in a
  database.

9
PURPOSE OF A QUERY

• The purpose of a query is to question or search
  for data in a database.
• It is a way to search for information in a
  database.
• Ex run a search for a zip code in a particular
  database.

10
WILDCARDS

• A wildcard takes the place of a letter or number.
• A wildcard looks like an asterisk ().

11
WILDCARDS

• Ex numerical query - 3 when placed in the
  postal code field, will look for postal codes
  that start with 3
• Ex character query - K when placed in the city
  field, will look for cities that start with K

12
REPORTS

• A report outputs data to the screen or printer.

13
PURPOSE OF A REPORT

• The purpose of a report is to give an output of
  results from a table in a database.
• Ex print out address labels to a printer of an
  address book that you made in MS Access

14
MICROSOFT ACCESS TOPICS

• QUESTIONS