Re: [AI] creating composite primary key in MS access 2010
When you create a database in Access, it's important to include a primary key within your table. Primary keys keep you from inserting duplicate records. You may set the primary key to automatically increment or manage it on your own. According to Microsoft Office, a composite primary key is one in which the primary key is assigned to two or more fields within a table. The fields do not have to be adjacent in your table. select the fields which you would like to be asigned as a composite key and press application key. navigate to "primary key" option and press enter to asign a key. warm regards, Yogesh Chhabra On 2/20/14, karan singhania wrote: > Hello everyone, > feeling great to write on this forum after a very long time! > I want to assign composite primary key to two or more fields in MS > access 2010. could anyone please help me in doing that? > > -- > Thanks and Regards > Karan Singhania > PGP 2013-15, IIM Ahmedabad > B.Com (Hons), Batch of 2013, SRCC (Delhi University) > Mob: +91 8758388116 > LL: +917966323301 > Skype: karan.singhania7 > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] creating composite primary key in MS access 2010
Dear Sir, I got your point. however, I am facing issue in selecting the fields. could you please help me in figuring out how to select the fields with the help of keyboard? Thanks On 2/20/14, Yogesh Chhabra wrote: > When you create a database in Access, it's important to include a > primary key within your table. Primary keys keep you from inserting > duplicate records. You may set the primary key to automatically > increment or manage it on your own. According to Microsoft Office, a > composite primary key is one in which the primary key is assigned to > two or more fields within a table. The fields do not have to be > adjacent in your table. > > select the fields which you would like to be asigned as a composite > key and press application key. navigate to "primary key" option and > press enter to asign a key. > > warm regards, > Yogesh Chhabra > > On 2/20/14, karan singhania wrote: >> Hello everyone, >> feeling great to write on this forum after a very long time! >> I want to assign composite primary key to two or more fields in MS >> access 2010. could anyone please help me in doing that? >> >> -- >> Thanks and Regards >> Karan Singhania >> PGP 2013-15, IIM Ahmedabad >> B.Com (Hons), Batch of 2013, SRCC (Delhi University) >> Mob: +91 8758388116 >> LL: +917966323301 >> Skype: karan.singhania7 >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility >> of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the >> person sending the mail and AI in no way relates itself to its veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the >> mails >> sent through this mailing list.. >> > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > -- Thanks and Regards Karan Singhania PGP 2013-15, IIM Ahmedabad B.Com (Hons), Batch of 2013, SRCC (Delhi University) Mob: +91 8758388116 LL: +917966323301 Skype: karan.singhania7 Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] creating composite primary key in MS access 2010
hai friends, i'm using access but very limited angle only. so if anybody has tutorial for access 2010 with jaws kindly send me. it will be useful inside andhrabank to customise many reports easily. On 2/21/14, karan singhania wrote: > Dear Sir, > I got your point. however, I am facing issue in selecting the fields. > could you please help me in figuring out how to select the fields with > the help of keyboard? > Thanks > On 2/20/14, Yogesh Chhabra wrote: >> When you create a database in Access, it's important to include a >> primary key within your table. Primary keys keep you from inserting >> duplicate records. You may set the primary key to automatically >> increment or manage it on your own. According to Microsoft Office, a >> composite primary key is one in which the primary key is assigned to >> two or more fields within a table. The fields do not have to be >> adjacent in your table. >> >> select the fields which you would like to be asigned as a composite >> key and press application key. navigate to "primary key" option and >> press enter to asign a key. >> >> warm regards, >> Yogesh Chhabra >> >> On 2/20/14, karan singhania wrote: >>> Hello everyone, >>> feeling great to write on this forum after a very long time! >>> I want to assign composite primary key to two or more fields in MS >>> access 2010. could anyone please help me in doing that? >>> >>> -- >>> Thanks and Regards >>> Karan Singhania >>> PGP 2013-15, IIM Ahmedabad >>> B.Com (Hons), Batch of 2013, SRCC (Delhi University) >>> Mob: +91 8758388116 >>> LL: +917966323301 >>> Skype: karan.singhania7 >>> >>> >>> >>> Register at the dedicated AccessIndia list for discussing accessibility >>> of >>> mobile phones / Tabs on: >>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>> >>> To unsubscribe send a message to >>> accessindia-requ...@accessindia.org.in >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please >>> visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >>> Disclaimer: >>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >>> the >>> person sending the mail and AI in no way relates itself to its veracity; >>> >>> 2. AI cannot be held liable for any commission/omission based on the >>> mails >>> sent through this mailing list.. >>> >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility >> of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the >> person sending the mail and AI in no way relates itself to its veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the >> mails >> sent through this mailing list.. >> > > > -- > Thanks and Regards > Karan Singhania > PGP 2013-15, IIM Ahmedabad > B.Com (Hons), Batch of 2013, SRCC (Delhi University) > Mob: +91 8758388116 > LL: +917966323301 > Skype: karan.singhania7 > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > -- nothing is difficult unless you make it appear so. r. aravind, clerk in andhrabank, mobile no: +91 9940369593, email id : aravind_...@yahoo.com, aravind.andhrab...@gmail.com. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.
Re: [AI] creating composite primary key in MS access 2010
Even I need the tutorial. Friends, Please send it if you have. Regards. Ajay On 2/21/14, Aravind R wrote: > hai friends, i'm using access but very limited angle only. so if > anybody has tutorial for access 2010 with jaws kindly send me. it will > be useful inside andhrabank to customise many reports easily. > > On 2/21/14, karan singhania wrote: >> Dear Sir, >> I got your point. however, I am facing issue in selecting the fields. >> could you please help me in figuring out how to select the fields with >> the help of keyboard? >> Thanks >> On 2/20/14, Yogesh Chhabra wrote: >>> When you create a database in Access, it's important to include a >>> primary key within your table. Primary keys keep you from inserting >>> duplicate records. You may set the primary key to automatically >>> increment or manage it on your own. According to Microsoft Office, a >>> composite primary key is one in which the primary key is assigned to >>> two or more fields within a table. The fields do not have to be >>> adjacent in your table. >>> >>> select the fields which you would like to be asigned as a composite >>> key and press application key. navigate to "primary key" option and >>> press enter to asign a key. >>> >>> warm regards, >>> Yogesh Chhabra >>> >>> On 2/20/14, karan singhania wrote: Hello everyone, feeling great to write on this forum after a very long time! I want to assign composite primary key to two or more fields in MS access 2010. could anyone please help me in doing that? -- Thanks and Regards Karan Singhania PGP 2013-15, IIM Ahmedabad B.Com (Hons), Batch of 2013, SRCC (Delhi University) Mob: +91 8758388116 LL: +917966323301 Skype: karan.singhania7 Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. >>> >>> >>> >>> Register at the dedicated AccessIndia list for discussing accessibility >>> of >>> mobile phones / Tabs on: >>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>> >>> To unsubscribe send a message to >>> accessindia-requ...@accessindia.org.in >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please >>> visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >>> Disclaimer: >>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >>> the >>> person sending the mail and AI in no way relates itself to its veracity; >>> >>> 2. AI cannot be held liable for any commission/omission based on the >>> mails >>> sent through this mailing list.. >>> >> >> >> -- >> Thanks and Regards >> Karan Singhania >> PGP 2013-15, IIM Ahmedabad >> B.Com (Hons), Batch of 2013, SRCC (Delhi University) >> Mob: +91 8758388116 >> LL: +917966323301 >> Skype: karan.singhania7 >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility >> of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the >> person sending the mail and AI in no way relates itself to its veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the >> mails >> sent through this mailing list.. >> > > > -- > nothing is difficult unless you make it appear so. > > r. aravind, > clerk in andhrabank, > mobile no: +91 9940369593, > email id : aravind_...@yahoo.com, aravind.andhrab...