There are a few ways to have Access insert today's date, but the simplest way is add a simple Date() function to the Default Value property of your table.
Let's say we have a database that tracks applicants and case workers, and when cases are assigned, signed out, and closed.
Alternatively, if the field is time-sensitive as well, you can also use the Now() function in place of the Date() function to store both the date and time information.
Protecting the validity of your data is one of the most important tasks of a database developer.
At the field level, the rule checks the data for only the field constrained by the rule.
For example, you might restrict an hours worked field to values between 0 and 40 (inclusive).
It's important because the data must be entered accurately; otherwise, any analysis of the data becomes at best misleading and at worst just plain wrong.
Microsoft Access date functions are a powerful way to retrieve and analyze data in your Access databases, but very few users know about these functions or how to use them.Data entry is one of those tasks that I describe as "dangerous" because it's a chore that's both tedious and important.It's tedious because entering dozens or hundreds of records is no one's idea of fun.Validation rules catch errors at the data entry level, so in effect, the mistakes never make it into your database.If the data doesn't satisfy the conditions you've set, Access won't accept the input value.As a forms designer, you can help to reduce this danger by setting up your forms so that data entry is both as efficient as possible and as accurate as possible.