Microsoft Access TablesThis page on Microsoft Access Tables, will in the future consist of lots of tips, questions/answers about Tables and the use of them in Microsoft Access.If you wish to know the basics on how to create Microsoft Access tables, then I suggest you download my free tutorial. This does not only include how to create tables in Microsoft Access, but will step you through the entire process of building your first database in MS Access. To learn the basics of Microsoft Access then:Click Here I am currently revamping this site, and transferring all the query related tips, questions and answer links to this page, from this page: Simply Access Tips Index So if you are sure there should be something here that isn't, check out the Index page above, or contact me on my 'Contact Page' to put forward your suggestion and I will do my best to include it. Preventing Orphan RecordsTo learn about how to prevent orphan records then click here This tip will explain how to set up your tables so that records in a sub-table are always linked to a record in the main table. Adding Prefix to an Autonumber FieldTo learn about how to add a prefix to an autonumber field then click here This tip will explain how to add a prefix such as 'ABC' to an autonumber field. Appending Autonumber FieldTo learn about how to append data to an Autonumber field then click here. There may be times when you import numbers (they maybe of data type AutoNumber or not) into an AutoNumber field which is also (and usually) your primary key. This tip explains how to append data from another table or data source to an autonumber field. Finished with Microsoft Access Tables then Return to Simply Access Home Page |
Search Simply Access
Want to learn more for free.
Sign up for Simply Access 'Microsoft Access Tips'. Free useable tips to your in-box each month.
If you wish to learn VBA to expand the possibilities of Microsoft Access then
Click Here Just $7.95 for 56 lessons.