How to Generate a Custom AutoNumber in MS Access?




About this tutorial:

Video duration: 00:03:13
By this video you can know how you can ‘Start’ AutoNumber field in Microsoft Access with your desired value and you can also control its increment.

Code Line:


ALTER TABLE [TABLE1]
ALTER COLUMN [Id] COUNTER (1,1)

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads