→ MS Access Functions From W3S → Start Learning / Flashcards Téléchargement MP3

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

MS Access functions from W3S

Vous devez vous connecter pour poster un commentaire.

plus