Understanding Databases and Spreadsheets: A Comprehensive Overview
This unit provides an introduction to databases and spreadsheets, explaining their importance in storing and managing information. It covers how databases help organize data using fields and records, and introduces SQL (Structured Query Language) for advanced querying. The spreadsheet section highlights the structure of spreadsheets, including cells organized in rows and columns, and their use for calculations. Practical exercises are included to reinforce learning concepts. This foundational knowledge is essential for anyone working with data management tools.
Understanding Databases and Spreadsheets: A Comprehensive Overview
E N D
Presentation Transcript
Database and Spreadsheets Unit 23 Prepared by :Nahed Al-Salah
Intoduction • A database is needed to store information so that it can be searched and sorted in various ways. • Each item of information stored in a field. • A collection of related fields form a record. • Simple searches can often be created by allowing the user to type the required field information into a blank record and pressing a search button.
More advanced programs usually use a query language known as SQL ( structural Query Language. • This allows users to type statements using logical operators to specify the search conditions.
Spreadsheet • A Spreadsheet program is used for calculating formulae. • It made up of a grid or array of rectangular boxes called cells as shown below : • The columns are labelled A,B,C… • The rows of cells numbered 1,2,3… • To refer to a particular cell e.g A1 , B1,C1………
Exercises • At Textbook
