Goal Seek works a formula in reverse. Tables which share a common field can be related with a database system. The amount of information a database can hold is limited a. The greater the number of records and the more complicated the report, the more a person would decide in favor of a word processor over an electronic spreadsheet. Autoform in Access is available as a data entry form.
Direct files have a. variable length records b. end of record character c.
An electronic spreadsheet is better than a database when large numbers of records and complex reports are desired. A table structure in Microsoft Access can be changed. Numeric and Character are the only field types allowed in Microsoft Access. No matter how large the data base is, all the records are read into memory with the OPEN command. When records are grouped in a report it is not possible to to print subtotals.