→ MS Access Functions From W3S → Start Lernen / Flashcards Herunterladen MP3

Frage		Antworten
Asc Lernen beginnen		Returns the ASCII value for the specific character
Chr Lernen beginnen		Returns the character for the specified ASCII number code
Concat with & Lernen beginnen		Adds two or more strings together
CurDir Lernen beginnen		Returns the full path for a specified drive
Format Lernen beginnen		Formats a value with the specified format
InStr Lernen beginnen		Gets the position of the first occurrence of a string in another
InstrRev Lernen beginnen		Gets the position of the first occurrence of a string in another, from the end of string
LCase Lernen beginnen		Converts a string to lower-case
Left Lernen beginnen		Extracts a number of characters from a string (starting from left)
Len Lernen beginnen		Returns the length of a string
LTrim Lernen beginnen		Removes leading spaces from a string
Mid Lernen beginnen		Extracts some characters from a string (starting at any position)
Replace Lernen beginnen		Replaces a substring within a string, with another substring, a specified number of times
Right Lernen beginnen		Extracts a number of characters from a string (starting from right)
RTrim Lernen beginnen		Removes trailing spaces from a string
Space Lernen beginnen		Returns a string of the specified number of space characters
Split Lernen beginnen		Splits a string into an array of substrings
Str Lernen beginnen		Returns a number as string
StrComp Lernen beginnen		Compares two strings
StrConv Lernen beginnen		Returns a converted string
StrReverse Lernen beginnen		Reverses a string and returns the result
Trim Lernen beginnen		Removes both leading and trailing spaces from a string
UCase Lernen beginnen		Converts a string to upper-case
Abs Lernen beginnen		Returns the absolute value of a number
Atn Lernen beginnen		Returns the arc tangent of a number
Avg Lernen beginnen		Returns the average value of an expression
Cos Lernen beginnen		Returns the cosine of an angle
Count Lernen beginnen		Returns the number of records returned by a select query
Exp Lernen beginnen		Returns e raised to the power of a specified number
Fix Lernen beginnen		Returns the integer part of a number
Format Lernen beginnen		Formats a numeric value with the specified format
Int Lernen beginnen		Returns the integer part of a number
Max Lernen beginnen		Returns the maximum value in a set of values
Min Lernen beginnen		Returns the minimum value in a set of values
Randomize Lernen beginnen		Initializes the random number generator (used by Rnd()) with a seed
Rnd Lernen beginnen		Returns a random number
Round Lernen beginnen		Rounds a number to a specified number of decimal places
Sgn Lernen beginnen		Returns the sign of a number
Sqr Lernen beginnen		Returns the square root of a number
Sum Lernen beginnen		Calculates the sum of a set of values
Val Lernen beginnen		Reads a string and returns the numbers found in the string
Date Lernen beginnen		Returns the current system date
DateAdd Lernen beginnen		Adds a time/date interval to a date and then returns the date
DateDiff Lernen beginnen		Returns the difference between two dates
DatePart Lernen beginnen		Returns a specified part of a date (as an integer)
DateSerial Lernen beginnen		Returns a date from the specified parts (year, month, and day values)
DateValue Lernen beginnen		Returns a date based on a string
Day Lernen beginnen		Returns the day of the month for a given date
Format Lernen beginnen		Formats a date value with the specified format
Hour Lernen beginnen		Returns the hour part of a time/datetime
Minute Lernen beginnen		Returns the minute part of a time/datetime
Month Lernen beginnen		Returns the month part of a given date
MonthName Lernen beginnen		Returns the name of the month based on a number
Now Lernen beginnen		Returns the current date and time based on the computer's system date and time
Second Lernen beginnen		Returns the seconds part of a time/datetime
Time Lernen beginnen		Returns the current system time
TimeSerial Lernen beginnen		Returns a time from the specified parts (hour, minute, and second value)
TimeValue Lernen beginnen		Returns a time based on a string
Weekday Lernen beginnen		Returns the weekday number for a given date
WeekdayName Lernen beginnen		Returns the weekday name based on a number
Year Lernen beginnen		Returns the year part of a given date
CurrentUser Lernen beginnen		Returns the name of the current database user
Environ Lernen beginnen		Returns a string that contains the value of an operating system environment variable
IsDate Lernen beginnen		Checks whether an expression can be converted to a date
IsNull Lernen beginnen		Checks whether an expression contains Null (no data)
IsNumeric Lernen beginnen		Checks whether an expression is a valid number

MS Access functions from W3S

Sie müssen eingeloggt sein, um einen Kommentar zu schreiben.

Mehr