0
What's the difference between a field and a record using Microsoft Excel?
Wiki User
∙ 13y ago
Field and Record are database terms.
If you look at it from the top-down, a database consists of records--a collection of data, all of which belongs to one person or account or business or other unique entity; and each record consists of a collection of fields, each of which contains a chunk of data. .
The way simple databases have historically been set up, a row corresponds to a record, and the individual cells within that row correspond to the particular data or expression in the various fields which make up that record. Records are represented by particular rows, and fields identify the type of information in each particular column. Where the rows and columns intersect is a cell, which corresponds to the particular field (type of information) for a particular record.
Wiki User
∙ 13y ago
Wiki User
∙ 14y agoA table is a collection of related records, while a record is a collection of related individual data items.
EXAMPLE:
Table = collection of information about all customers
Record = collection of information about a single customer (e.g. name, address, etc.)
Add your answer:
Earn +20 pts
What is the difference between Microsoft Excel 2003 and Microsoft Word?
Microsoft Excel is a worksheet. Microsoft Word is a word processor.
What is the difference between Excel sheet and spread sheet?
They are the same thing, excel is Microsoft's spreadsheet programme.
What is the difference between the way Access saves a record and the way Excel saves a row in a work sheet?
the difference between the way Access saves a record and the way Excel saves a row in a worksheet. Answer
What is the difference between excel and a word window?
Excel is a spreadsheet program that is marketed by Microsoft. Word is a word processing program that is marketed by the same company.
How do you time stamp a cell in Microsoft Excel?
You do not. Excel does not record the change date of an individual cell.
Can a person complete calculations in Microsoft Excel 2003?
Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.
What is the difference between Microsoft Word and MS Excel?
Word: Is used to Create / Edit Word Processing documents Excel: Is used to Create / Edit Spreadsheet Calculations Hope this helps
What is the difference between sql and Microsoft Excel?
SQL means Structured Query Language. It is a programming language which is mainly used for maintaining databases. Excel is one of the application developed by Microsoft to do calculations, graphs using spreadsheets.
What is the difference between Microsoft Excel and Microsoft Proficient?
There is no Microsoft application titled "Proficient." The only reference I can think of that relates to the phrase "Microsoft Proficient," is I have seen it occasionally in job ads to indicate that the applicant is expected to have a reasonable proficiency level with Microsoft Office applications (usually referring to Word, Excel, PowerPoint, and Outlook).
What is the difference between a cell and a range in Microsoft Excel 2007?
A cell is a single location while a range is a collection of related cells.
What is difference between an Excel XLR and XLS file?
The xlsx file extensions are from Excel 2007 whereas xls is used in the earlier versions of Excel.Thanks
What is the relationship between Microsoft Excel and calculations?
The main reason for Excel is to perform calculations.
