There is an important distinction that comes up here between Access and SQL Server that is critical to your table design and future expandability. Access does not comply with the ANSI SQL ...

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 ...