Question

Write a program and to extract and display four words from the word

“EDUCATION” using string function.

PLEASE SAY ME THE ANSWER I WILL MARK YOU BRAINLIEST​

Answer 1

Explanation:

With string functions, you can create expressions in Access that manipulate text in a variety of ways. For example, you might want to display only part of a serial number on a form. Or, you might need to join (concatenate) several strings together, such as a last name and a first name. If you’re not savvy with expressions yet, see Build an expression.

Here’s a listing of some of the more common string operations in Access, and the functions you would use to perform them:

To…

Use the…

For example…

Results

Return characters from the beginning of a string

Left function

=Left([SerialNumber],2)

If [SerialNumber] is “CD234”, the result is “CD”.

Return characters from the end of a string

Right function

=Right([SerialNumber],3)

If [SerialNumber] is “CD234”, the result is “234”.

Find the position of a character in a string

InStr function

=InStr(1,[FirstName],"i")

If [FirstName] is “Colin”, the result is 4.

Return characters from the middle of a string

Mid function

=Mid([SerialNumber],2,2)

If [SerialNumber] is “CD234”, the result is “D2”.

Trim leading or trailing spaces from a string

LTrim, RTrim, and Trim Functions

=Trim([FirstName])

If [FirstName] is “ Colin ”, the result is “Colin”.

Join two strings together

Plus sign (+) operator*

=[FirstName] + [LastName]

If [FirstName] is “Colin” and [LastName] is Wilcox, the result is “ColinWilcox”

Join two strings together with a space in between them

Plus sign (+) operator*

=[FirstName] + “ “ + [LastName]

If [FirstName] is “Colin” and [LastName] is Wilcox, the result is “Colin Wilcox”

Change the case of a string to upper or lower case

UCase function or LCase function

=UCase([FirstName])

If [FirstName] is “Colin”, the result is “COLIN”.

Determine the length of a string

Len function

=Len([FirstName])

If [FirstName] is “Colin”, the result is 5.

* Okay, so it’s not a function, it’s an operator. However, it’s the quickest way to join strings together. In a desktop database, you can also use the ampersand operator (&) for concatentation. In an Access app, you must use the plus sign (+).

There are many more text-related functions in Access. A good way to learn more about them is to open the Expression Builder and browse through the function lists. The Expression Builder is available almost anywhere you want to build an expression—usually there’s a little Build button that looks like this: Button image