# data[].attributes.body
String functions:
Left()
Right()
concatenate(joins more than two words together)
MID()

# data[].attributes.body
CONCANTENATE function joins two strings together.

# data[].attributes.body
String Functions:
=LEFT(Text,Number of Characters)
Selects characters from the left to a particular length
=RIGHT(Text, Number of Characters)

Selects characters from the right to a particular length

=MID(Text,StartCharacter,Number of Characters)
Displays characters from the middle of a text
=CONCATENATE(Text1,Text2,Text3,....)
Joins a number of text character cells in one single cell
=VALUE(Cell)
Converts text to a numerical value
=TEXT(Cell,Format)
Converts text into a given format

# data[].attributes.body
Data management and data analysis help us to make better business decisions, or decisions related to any kind of budget, collection of information (etc.)
Hence, it relates to the Moral Value of being organized, eventually leading to financial independence.
In Data Analysis Software (Spreadsheet; Excel), what-if analysis allows us to test out different situations in a model that is independent of real world factors.

# data[].attributes.body
Left
Mid
Right

Concatenate function is used to join multiple strings of text into one line.

# data[].attributes.body
List of string functions:
CONCATENATE
LEFT
MID
RIGHT

# data[].attributes.body
CONCATENATE function allows you to combine text from different cells into one cell

# data[].attributes.headline
Access and Excel is similar in functioning but are used for different purposes. Access allows us to create queries and reports based on the database imported. Excel allows us to use what if analysis and goal seek.

# data[].attributes.subject
Access and Excel is similar in functioning but are used for different purposes. Access allows us to create queries and reports based on the database imported. Excel allows us to use what if analysis and goal seek.

# data[].attributes.body
Emirates Id
-Link Health and other details

# data[].attributes.body
string function is used to Combine two or more strings of text
for example concatenate

another examples are mid, left,right

# data[].attributes.body
-LEFT
-RIGHT
-MID
-LEN (Counts the length of an input)
-TRIM ( Removes unnecessary characters from the sides of a string or maybe from the middle)
-CONCATENATE

# data[].attributes.body
=MID(A1,2,15)

# data[].attributes.body
Left
Mid
Right
Concatenate
Mid
Text
Value

# data[].attributes.headline
Spreadsheets and Databases are similar but databases involve a higher level of technical processing  

# data[].attributes.subject
Spreadsheets and Databases are similar but databases involve a higher level of technical processing  

# data[].attributes.body
for example access allows us to create multiple queries on the text file we import while excel might not offer us as much scope.

# data[].attributes.body
string functions:
=CONCATENATE()
=LEFT()
=RIGHT()
=MID()

# data[].attributes.headline
Mid: extracts characters form the middle 

# data[].attributes.subject
Mid: extracts characters form the middle 

# data[].attributes.body
Left/ Right : Extracts no. of characters from left or right respectively

# data[].attributes.body
CONCATENATE
LEFT
MID
RIGHT
LEN
TEXT
VALUE

WHAT IS DATA MANAGEMENT SYSTEM

A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.

DIFFERENCE BETWEEN THE ACCESS AND EXCEL

Key Difference: Microsoft Excel and Access are two different application software from Microsoft. They both deal with tabular data, but still there are numerous differences between the two. Excel is a spreadsheet application program, whereas Access is a database program

# data[].attributes.body
The MID function is used to extract characters in a sequence in the middle, or anywhere where the data needed to be  extracted does not lie in the far most positions in that sequence.
=MID(text, start_num, num_characters)

String functions:
=LEFT
=RIGHT
=MID
=CONCATENATE
=TEXT
=VALUE

Concatenate is used to put together characters or texts in one sequence

# data[].attributes.body
Types of string functions
=LEFT()
=RIGHT()
=CONCATENATE
=MID

# data[].attributes.body
Mid counts the number of characters from the middle of the text by choosing the starting point for counting and the number of characters to be extracted

# data[].attributes.body
String functions:
=TEXT()
=CONCATENATE()
=LEFT()
=MID()
=RIGHT()
=LEN()

# data[].attributes.body
concatenate  function  is used to join two or more words or text strings together.

# data[].attributes.body
Q: List few String Functions
Left
Right
Mid
Concatenate

Q: Explain What a Concatenate function does?
Concatenate function combines text from number of cells into one cell.

Q: How is Mid different from Right and Left?
Mid function takes data from the middle of the cell rather than the starting or ending.

# data[].attributes.headline
Sami                                 =Left()

# data[].attributes.subject
Sami                                 =Left()

# data[].attributes.body
=Right()
=Mid()
=concatenate()

# data[].attributes.headline
Concatenate links words or characters together to form chains or strings

# data[].attributes.subject
Concatenate links words or characters together to form chains or strings

# data[].attributes.body
MID: extracts certain data from the middle of the given data.

# data[].attributes.body
MID:  designed to parse out a substring from neither the left or right ends of a string, but rather a middle section of string.

RIGHT:  extracts substring relative to the right-most section of the existing string.

LEFT: extracts substring relative to the left-most section of the string.

# data[].attributes.body
String Functions are:
LEFT
RIGHT
MID
CONCANTENATE

# data[].attributes.headline
Explain what a concatenate function does

# data[].attributes.subject
Explain what a concatenate function does

# data[].attributes.headline
How is Mid different from Right and Left

# data[].attributes.subject
How is Mid different from Right and Left

# data[].attributes.headline
How is RDBMS different from Spreadsheet ie, Access different from Excel

# data[].attributes.subject
How is RDBMS different from Spreadsheet ie, Access different from Excel

# data[].attributes.body
Data analytics & decision making is the latest wave. Just like software and the internet were in the recent past. Decision making is one of the most complex areas of our day to day life. We need a lot of information before we can take any decision. Data analytics helps in just that spot- analyzing data to derive relevant information, based on which the decisions could be taken.

List some situations you use Data Analytics and Data Management in your daily life

# data[].attributes.body
As e-commerce and database development / management systems are rapidly growing across UAE in all departments the need of database dependent systems is also growing. To cope up with this growing need UAE requires more professionals in this field.

Dubai Council, Digital Industry’s and Research department uses DBMS / RDBMS to gather statistics in UAE.

List few other departments that might be using RDBMS

# data[].attributes.body
Why do you think data management and data analysis is important in life
Which moral value can you connect this too?