Geek
1) Not sure what you're aiming to do with the checkboxes, but if you right
click on the toolbar area, you will get a list of available toolbars. You
want either the 'forms' toolbox or the 'controls' toolbox. Generally those
from the 'forms' toolbox are easier to handle for a novice, but the activeX
controls from the 'controls' toolbox are more feature rich. You simply click
on the checkbox and draw it on the worksheet, re-sizing it with the handles.
2) Excel is a spreadsheet, which is to be used predominantly for
calculation, analysis, what-if scenarios and charting. It is limited as a
database because it has only 256 columns and 65536 rows, although it is
similar in as much as it has rows (records) and columns (fields), similar to
a database. Access is a database, able to collect huge quantities
(millions) of records in multiple tables, which can then be linked (form
relationships), to make a true relational database. It displays and
collects data by means of forms and reports. Both products are easily
integrated however, so you can collect huge quantities in Access and send it
to, or bring it into XL, (or Word for that matter), for analysis,
calculation or charting. All of the se operations are far easier in Excels
environment (IMHO)
The differences could go on for ever, but that's just a short example. It
never ceases to amaze me what XL is used for, much of which is driven by
it's relative ease of use, however, if you can get to grips with Access's
relative perceived complications, they work great together in their own
'domains'
