One of Access' best features is how easy it is to add related data sets. Forms frequently have embedded sub-forms or grids. Typically there are buttons for adding or editing rows in the sub-form If there is not a specialized button on each row for removing that row, you can still easily do so as follows. In a sub-form, there is a left-most grayed column, thin and empty. This is the row selector column. If you click next to a row in this left most column, the form responds by putting a right-facing triangle in the column, indicating you have selected that row in the sub-form.
GSpace
Posted January 7th, 2007 by Steve BackmanIf you have a google mail (GMail) account and you use Firefox (why not), you can install an extension called "GMail Space" or GSpace. From the authors' description:
"This extension allows you to use your Gmail Space (2.5 GB and growing) for file storage. It acts as an online drive, so you can upload files from your hard drive and access them from every Internet capable system. The interface will make your Gmail account look like a FTP host."
Creating off line data extracts
Posted January 7th, 2007 by Steve BackmanOften in an Access database, lists are presented either as Queries (data views) or Reports. These may suffice for many purposes, but it is also straightforward to then export them to Word or Excel. As with other things Microsoft, in fact, there is more than one route to doing this. All start by previewing the list on the screen.
