Jim, I don't know if that's what you want to know but :
To create a new grid :
To select which columns/fields should appear in the grid :
To manage/create new fields (which can eventually be showed as columns...) :
Right click on colum titles -->Manage fields (but that doesn,t seem to always work<
EDIT : Sorry... PPLAndry was here first... Anyhow.
I had another thread I had started about the availability of a simple/easy-to-use database application. SQL Notes was strongly suggested in that thread and it sounded promising. But I mentioned there also that without pretty easy-to-understand manuals or tutorials, I am lost when it comes to databases! Spreadsheets - as complex as you like: I can create them in my sleep. Digital photo and video authoring and editing - I started that and created my first project for an American Idol finalist who needed it for their first meeting with an agent after being booted - and have improved since then. Again, that just seemed to come naturally without reading hardly anything about it. No manuals needed!
But that has never worked with databases! For some reason I just cannot work intuitively with a database application - at least none since I used to use the old dBase III+ a million years ago. I really lose focus - and then interest and efficiency - as soon as I try to create databases without reading a whole lot! Just a mind-block? I don't know. All I know is that wading into a database app doesn't work for me!
As for what I was looking for in the first place - I think we discussed this here in my other thread
, Pierre. No notes. A database to track my correspondence and other documentation from certain insurance companies. It started out simple enough and I tracked everything with spreadsheets, pivot tables, Look-ups, etc. Easy - about 100 or so documents. Now, however, it is up to several hundred, and the companies have a way of asking you to confirm data you supplied last year. If it doesn't match exactly - sometimes word for word - we go off to arbitration. A truly weird system! Anyway, I need the documentation readily accessible, and searchable by multiple keywords so I can access the correct documents quickly. The spreadsheet system has gotten truly bogged down!
I have MS Office 2003 with Access but every time I start anew in Access and try designing my tables, forms, etc. as soon as I try to run a report or pull out data I am presented with the VB Editor - which completely confounds me!!