Using Excel as a Database

Chapter 4 USING EXCEL AS DATABASE A database is a collection of information related to a particular subject, such as maintaining addresses, numbers, a list of library books, keeping students’ record pertaining to academic and co-curricular activities, keeping employees’ information, etc. It helps the users to organise, retrieve, sort and edit data as per their requirements. Database consists of fields and records. In simple terms, records refer to rows, and fields refer to columns. FIELD A column within a database that contains only one type of data is called Field. For example, Roll No. and Name are different fields.

A close-up photo shows a textbook page titled “USING EXCEL AS DATABASE,” with definitions of databases, fields, and records. The joke is the absurdity of treating Excel like a full database, making this image useful as a reaction to unnecessarily complicated spreadsheets or questionable technical decisions.

• @right_wing_dev_squads / 489 2020-11-03
• @right_wing_dev_squads / 1298 2021-03-04