Homework answers / question archive / Access Chapter 3   Updating Records   1)To create a split form: 2 To use a form to add records: 3 To search for a record: 4 To update the contents of a record:   5 To delete a record: Filtering Records 6 To use filter by selection: 7 To toggle a filter:   8 To clear a filter:   9 To use a common filter:   10 To use filter by form:   11 To use advanced filter/sort:   12 Filters and queries are related in three ways: Changing the Database Structure   13 To add a new field:   14 To create a lookup field:   15 To add a multivalued field:   16 To modify single valued or multivalued lookup fields:   17 To add a calculated field:   18 To save the changes and close the table: Mass Changes   19 To use an update query:       20 To use a delete query:         21 To use an append query:   22 To use a make-table query:   23 To use a make-table query:   Validation Rules   24 To change a field size:   25 To specify a required field   26 To specify a range:   27 To specify a default value:   28 To specify a collection of legal values:   29  To specify a format:   30 To save the validation rules, default values, and formats:   Making Additional Changes to the Database   31 To change the contents of a field:   32 To use a lookup field:   33 To use a multivalued lookup field: 34 To update a form to reflect changes in the table:     35 To update a report to reflect changes in the table:   36 To print a report:   Changing the Appearance of a Datasheet   37 To include totals in a datasheet:   38 To remove totals from a datasheet: 39 To change gridlines in a datasheet:   40 To change the colors and font in a datasheet: 41 To close the datasheet without saving the format changes:   Multivalued Fields in Queries   42 To include multiple values on one row of a query:   43 To include multiple value on multiple row of a query   Referential Integrity   44 To specify referential integrity   Effect of Referential Integrity   45 To use a Subdatasheet:   Handling Data Inconsistency   46 To find duplicate records:   To find unmatched records:   Ordering Records   47 To use the ascending button to order records:   48 To use the ascending button to order records on multiple fields:  

Access Chapter 3   Updating Records   1)To create a split form: 2 To use a form to add records: 3 To search for a record: 4 To update the contents of a record:   5 To delete a record: Filtering Records 6 To use filter by selection: 7 To toggle a filter:   8 To clear a filter:   9 To use a common filter:   10 To use filter by form:   11 To use advanced filter/sort:   12 Filters and queries are related in three ways: Changing the Database Structure   13 To add a new field:   14 To create a lookup field:   15 To add a multivalued field:   16 To modify single valued or multivalued lookup fields:   17 To add a calculated field:   18 To save the changes and close the table: Mass Changes   19 To use an update query:       20 To use a delete query:         21 To use an append query:   22 To use a make-table query:   23 To use a make-table query:   Validation Rules   24 To change a field size:   25 To specify a required field   26 To specify a range:   27 To specify a default value:   28 To specify a collection of legal values:   29  To specify a format:   30 To save the validation rules, default values, and formats:   Making Additional Changes to the Database   31 To change the contents of a field:   32 To use a lookup field:   33 To use a multivalued lookup field: 34 To update a form to reflect changes in the table:     35 To update a report to reflect changes in the table:   36 To print a report:   Changing the Appearance of a Datasheet   37 To include totals in a datasheet:   38 To remove totals from a datasheet: 39 To change gridlines in a datasheet:   40 To change the colors and font in a datasheet: 41 To close the datasheet without saving the format changes:   Multivalued Fields in Queries   42 To include multiple values on one row of a query:   43 To include multiple value on multiple row of a query   Referential Integrity   44 To specify referential integrity   Effect of Referential Integrity   45 To use a Subdatasheet:   Handling Data Inconsistency   46 To find duplicate records:   To find unmatched records:   Ordering Records   47 To use the ascending button to order records:   48 To use the ascending button to order records on multiple fields:  

Business

Share With

---

Access Chapter 3

 

Updating Records

 

1)To create a split form:

2 To use a form to add records:

3 To search for a record:

4 To update the contents of a record:

 

5 To delete a record:

Filtering Records

6 To use filter by selection:

7 To toggle a filter:

 

8 To clear a filter:

 

9 To use a common filter:

 

10 To use filter by form:

 

11 To use advanced filter/sort:

 

12 Filters and queries are related in three ways:

Changing the Database Structure

 

13 To add a new field:

 

14 To create a lookup field:

 

15 To add a multivalued field:

 

16 To modify single valued or multivalued lookup fields:

 

17 To add a calculated field:

 

18 To save the changes and close the table:

Mass Changes

 

19 To use an update query:

 

 

 

20 To use a delete query:

 

 

 

 

21 To use an append query:

 

22 To use a make-table query:

 

23 To use a make-table query:

 

Validation Rules

 

24 To change a field size:

 

25 To specify a required field

 

26 To specify a range:

 

27 To specify a default value:

 

28 To specify a collection of legal values:

 

29  To specify a format:

 

30 To save the validation rules, default values, and formats:

 

Making Additional Changes to the Database

 

31 To change the contents of a field:

 

32 To use a lookup field:

 

33 To use a multivalued lookup field:

34 To update a form to reflect changes in the table:

•  

 

35 To update a report to reflect changes in the table:

 

36 To print a report:

 

Changing the Appearance of a Datasheet

 

37 To include totals in a datasheet:

 

38 To remove totals from a datasheet:

39 To change gridlines in a datasheet:

 

40 To change the colors and font in a datasheet:

41 To close the datasheet without saving the format changes:

 

Multivalued Fields in Queries

 

42 To include multiple values on one row of a query:

 

43 To include multiple value on multiple row of a query

 

Referential Integrity

 

44 To specify referential integrity

 

Effect of Referential Integrity

 

45 To use a Subdatasheet:

 

Handling Data Inconsistency

 

46 To find duplicate records:

 

To find unmatched records:

 

Ordering Records

 

47 To use the ascending button to order records:

 

48 To use the ascending button to order records on multiple fields: