Question

Find the rules for naming field names in Libreoffice Base.

Answer 1

According to Balbharati Information Technology (Commerce), Standard 12, Chapter 5: Database Concepts using LibreOffice Base, this appears as a “Do it Yourself” activity rather than a printed list of rules.

Rules for naming field names in LibreOffice Base:

1. Field names should be meaningful: The name should clearly indicate what data the field contains, such as Name, Address, or Mobile_No.
2. Avoid spaces: Spaces should preferably not be used in field names. Use an underscore (_) to separate words, for example, Student_Name.
3. Avoid special characters: Special symbols such as $, @, #, %, &, etc. should not be used.
4. Use letters and numbers: Field names should mainly consist of letters and numbers.
5. Keep field names short and clear: A field name should be easy to understand and relevant to the data stored in it.

These naming practices make database fields easier to identify and use correctly.