Questions from Microsoft Excel and Access for Accounting

Q: What is the process for adding a validation rule to a field

What is the process for adding a validation rule to a field?

Q: Why would you establish default values for a field?

Why would you establish default values for a field?

Q: Modify What SUP’s Sum-of-the-Year’s Digits Depreciation

Modify What SUP’s Sum-of-the-Year’s Digits Depreciation Schedule You are to add another depreciation schedule for What SUP. Use the ch4-01_SYD_student_name worksheet you created in this chapter. Add a...

Q: What are input masks?

What are input masks?

Q: What is referential integrity?

What is referential integrity?

Q: Describe the difference between the Query Wizard and Design view methods of

Describe the difference between the Query Wizard and Design view methods of creating a query.

Q: When might you use a delete query?

When might you use a delete query?

Q: Describe the process for using criteria in a query using the Design

Describe the process for using criteria in a query using the Design view method.

Q: How and why are wildcards used in a query?

How and why are wildcards used in a query?

Q: Describe the process for adding to an existing query a field that

Describe the process for adding to an existing query a field that exists in a table not currently included in the query.