Whether you use Microsoft Access to keep track of inventory or to keep a record of customers and clients, managing your tables can become cumbersome as the database grows in size and complexity.

Yes, but you have SharePoint experience don't you (I'm sure I saw several SharePoint threads by you???)<BR><BR>Anyway, why not just do it there?<BR><BR><BR>Basically move out of Excel and into ...

Microsoft introduced its Access database product about 20 years ago, and it remains popular due to its ability to link and import data from a variety of sources. Either through ODBC or native drivers, ...

I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.

When you create a Microsoft Access table, Access will automatically create a primary key to your database table. Still, you can also specify the field you want as the primary key for your database ...

Microsoft Access is a database management system program that combines the relational Access Database Engine with a graphical user interface and software development tools. In Microsoft Access, you ...