– In House Excel Training & MS Office Blog

A validation rule is an expression that limits the values that can be entered in the field. Examples of validation rules

Accept Or Reject will only allow “Accept” or “Reject“

>=0 number cannot be negative

>=Date() date cannot be in the past

Between Date() And DateAdd("m",6,Date()) date…

MS Access Tutorial Tutorial

Set a Field’s Default Value in an MS Access Table

Blue Pecan Computer Training on

A default value is automatically entered in a field for a new record. You can set a default value for table fields set to the Text, Memo, Number, Date/Time, Currency, Yes/No, and Hyperlink data types. Examples of default values Yes – would automatically add the word Yes to the current field. 25 – would automatically add…

Excel Tutorial Tutorial

Create a Progress Bar, Actual Vs Target Using Excel’s Conditional Formatting

Chester Tugwell on

https://youtu.be/dnP1CpjKEBQ This video shows you how to create a progress bar for actual vs target percentage calculations in Excel. Excel's conditional formatting options include something called data bars. Data bars are normally used to compare values in a single column, so, for example, the smallest value has the smallest bar and the largest value the…

Categories

Tags

Archives

Set a Field’s Validation Rule in an Access Table

Set a Field’s Default Value in an MS Access Table

Create a Progress Bar, Actual Vs Target Using Excel’s Conditional Formatting