Article Adds one or more existing user s to an existing group . Syntax ADD USER user [ , user , …] TO group The ADD USER statement has these parts: Part Description...
Article Specifies records selected with SQL queries. Syntax SELECT [ALL | DISTINCT | DISTINCTROW | [TOP n [PERCENT]]] FROM table A SELECT statement containing...
Article Modifies the design of a table after it has been created with the CREATE TABLE statement. Note The Microsoft Access database engine does not support...
Article Changes the password for an existing user or for a database. Syntax ALTER DATABASE PASSWORD newpassword oldpassword ALTER USER user PASSWORD newpassword...
Article Calculates the arithmetic mean of a set of values contained in a specified field on a query. Syntax Avg ( expr ) The expr placeholder represents a string...
Article Determines whether the value of an expression falls within a specified range of values. You can use this operator within SQL statements . Syntax expr ...
Article You can use the string expression argument in an SQL aggregate function to perform a calculation on values in a field. For example, you could calculate...
Article Microsoft Access database engine SQL is generally ANSI -89 Level 1 compliant. However, certain ANSI SQL features are not implemented in Microsoft Access...
Article A constraint is similar to an index , although it can also be used to establish a relationship with another table. You use the CONSTRAINT clause in...
Article Syntax: Count(expr)
Article Creates a new index on an existing table. Note For non-Microsoft Access databases, the Microsoft Access database engine does not support the use of...
Article Creates a stored procedure . Note The Microsoft Access database engine does not support the use of CREATE PROCEDURE, or any of the DDL statements...
Article Creates a new table. Note The Microsoft Access database engine does not support the use of CREATE TABLE, or any of the DDL statements, with non...
Article Creates one or more new users or groups. Syntax Create a user: CREATE USER user password pid [, user password pid , …] Create a group: CREATE GROUP...
Article Creates a new view . Note The Microsoft Access database engine does not support the use of CREATE VIEW, or any of the DDL statements, with non...
Article Creates a delete query that removes records from one or more of the tables listed in the FROM clause that satisfy the WHERE clause. Syntax DELETE [ table...
Article Deletes an existing table, procedure, or view from a database, or deletes an existing index from a table. Note The Microsoft Access database engine...
Article Deletes one or more existing user s or group s, or removes one or more existing user s from an existing group . Syntax Delete one or more user s or...
Article The following table lists ANSI SQL data types, their equivalent Microsoft Access database engine SQL data types, and their valid synonyms. It also lists...
Article Used to invoke the execution of a procedure . Syntax EXECUTE procedure [ param1 [ , param2 [, ...]] The EXECUTE statement has these parts : Part Description...
Article Return a field value from the first or last record in the result set returned by a query. Syntax First( expr ) Last( expr ) The expr placeholder represents...
Article Specifies the tables or queries that contain the fields listed in the SELECT statement. Syntax SELECT fieldlist FROM tableexpression [IN externaldatabase...
Article Grants specific privileges to an existing user or group. Syntax GRANT { privilege [, privilege , …]} ON {TABLE table | OBJECT object | CONTAINER container } TO
Article Show All Hide All Combines records with identical values in the specified field list into a single record. A summary value is created for each record if...
Article Show All Hide All Specifies which grouped records are displayed in a SELECT statement with a GROUP BY clause. After GROUP BY combines records, HAVING displays...
