Setting a starting AutoNumber


show more Setting a starting AutoNumber provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Setting a starting AutoNumber

When you set AutoNumber as a fields data type, it will automatically start at one and then increment up from there, but sometimes you may need it to start at a larger number, here's how to set that up. I am going to close this Employees table and open up my SalesReps, it's essential to implement this technique, when you first create you new table. After you've assigned records to it, it's impossible to change the AutoNumbers that have been assigned. So let's say for example, that instead of one, I want all my AutoNumbers in my SalesReps table to started at a thousand and work up from there.

So after you finish creating your table, but before you begin populating it, close it and make a copy of it, I'll right-click on SalesReps and Copy and then right-click below and then Paste. I'll leave the name copy of SalesReps, so that I can distinguish the two and I'll make sure to copy over only the structure I don't want any existing data in it and I'll click ...

Setting a starting AutoNumber
Video duration: 3m 14s 3h 43m Intermediate

Viewers:

Setting a starting AutoNumber provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...