Usually set at the Database level Now() in Access and GetDate ... There is an important distinction that comes up here between Access and SQL Server that is critical to your table design and future ...

Sample Database Diagram - SQL Server 7.0 Here is a sample E-commerce application ... Whatever you do in your Products Table will have a distinct impact on the design of your Orders and OrderDetails ...