Ch. 6-7 ReviewData Validation, Forms : Ch. 6-7 ReviewData Validation, Forms Computer Applications II
Lesson 6: Adding and Editing Data : 1. Why should you be careful when deleting a record?
When you delete a record, that record number is permanently deleted from the
database table. There may be other records that rely on the record you are
trying to delete. DO NOT delete a record without knowing how it will impact the rest of your database.
2. Why would you set data validation rules?
to force the person entering data to follow a specific format.
3. Give two examples of data validation rules.*Setting a field data type to currency only.
*Setting validation text to have Access tell the person entering data the specific way you would like them to enter it.
*Setting a field size to hold a specific number of characters (i.e. 255 characters) Lesson 6: Adding and Editing Data
Lesson 7- Creating and Using Forms : What are the benefits of using forms with a
database?
Forms let your user enter data one record at a time, without having to see the entire table.
Access 2007 form also lets the person entering data know exactly what information to enter, and can even tell him what that information should look like.
Forms are one more way that the database owner can limit the actions of the other users. Form properties can be set so users can only enter records or only view records. Lesson 7- Creating and Using Forms
Lesson 10 –Sorting Data : When Access 2007 sorts on a text value, it offers the two options described in the table below:
Description
A to Z
Ascending
Values closest to A are displayed first
Z to A
Descending
Values closest to Z are displayed first Lesson 10 –Sorting Data
Lesson 10 – Sorting Data (cont) : Access 2007 also offers the two options when sorting based on a numeric value. These options are described in the table below:
Description
Smallest to Largest
Ascending
Values closest to 1 are displayed first
Largest to Smallest
Descending
Values furthest from 1 are displayed first Lesson 10 – Sorting Data (cont)
Lesson 12 - Using Queries to Make Data Meaningful : What do queries allow you to do? Queries allow you to retrieve information from one or more tables based on a set of search conditions you define and then combine that information in a way that is easy for you to analyze.
Why are they useful? They help you answer questions about your data. Lesson 12 - Using Queries to Make Data Meaningful
Lesson 12 (cont) : 2. What query basics you will need to know to design a query:
What fields do you want to see in the results?
What tables hold the information you need?
What conditions do you want the data to meet? Lesson 12 (cont)
Lesson 14 - Using Reports To Make Data Meaningful to Others : 1.What is a report in Access 2007? an effective way to summarize and present your data using an attractive layout.
2. What is the purpose of creating a report in Access 2007? It provides a way for you to share your Access database with others. Lesson 14 - Using Reports To Make Data Meaningful to Others