Skip to search results
PRODUCT
Office.com results
REVOKE Statement
Article Revokes specific privileges from an existing user or group. Syntax REVOKE { privilege [, privilege , …]} ON {TABLE table | OBJECT object | CONTAINTER conta...
Access 2007
PROCEDURE Clause
Article Defines a name and optional parameters . Note The PROCEDURE clause has been superseded by the PROCEDURE statement. Although the PROCEDURE clause is still...
Access 2007
SELECT Statement
Article Instructs the Microsoft Access database engine to return information from the database as a set of records. Syntax SELECT [ predicate ] { * | table .* | [ ta...
Access 2007
LEFT JOIN, RIGHT JOIN Operations
Article Use the LEFT JOIN and RIGHT JOIN operations to combine source-table records when used in any FROM clause.
Access 2010, Access 2007
INNER JOIN Operation
Article Combines records from two tables whenever there are matching values in a common field. Syntax FROM table1 INNER JOIN table2 ON table1 . field1 compopr t...
Access 2007
INSERT INTO Statement
Article Use INSERT INTO to add a single record to a table or to append a set of records from another table or query.
Access 2010, Access 2007
In Operator
Article Determines whether the value of an expression is equal to any of several values in a specified list. Syntax expr [ Not ] In( value1, value2, . . . ) Remarks T...
Access 2007
Like Operator
Article Use the Like operator to find values in a field that match the pattern you specify. For example, Like “Smith” or Like “Sm*”.
Access 2010, Access 2007
ODBC Scalar Functions
Article Microsoft Access SQL supports the use of the ODBC defined syntax for scalar functions. For example, the query: SELECT DAILYCLOSE, DAILYCHANGE FROM DAILYQUOTE ...
Access 2007
HAVING Clause
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 a...
Access 2010, Access 2007
PARAMETERS Declaration
Article Declares the name and data type of each parameter in a parameter query . Syntax PARAMETERS name datatype [, name datatype [, ...] ] The PARAMETERS decla...
Access 2007
IN Clause
Article Identifies tables in any external database to which the Microsoft Access database engine can connect, such as a dBASE or Paradox database or an external Mic...
Access 2007
Min, Max Functions
Article Use these functions to return the minimum or maximum of a set of values contained in a specified field on a query.
Access 2010, Access 2007
ORDER BY Clause
Article Sorts a query's resulting records on a specified field or fields in ascending or descending order. Syntax SELECT fieldlist FROM table WHERE selectcriteria [O...
Access 2007
SELECT...INTO Statement
Article Creates a make-table query . Syntax SELECT field1 [, field2 [, ...]] INTO newtable [IN externaldatabase ] FROM source The SELECT...INTO statement has the...
Access 2007
GROUP BY Clause
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 you inc...
Access 2010, Access 2007
GRANT Statement
Article Grants specific privileges to an existing user or group. Syntax GRANT { privilege [, privilege , …]} ON {TABLE table | OBJECT object | CONTAINER container...
Access 2007
ALL, DISTINCT, DISTINCTROW, TOP Predicates
Article Specifies records selected with SQL queries. Syntax SELECT [ALL | DISTINCT | DISTINCTROW | [TOP n [PERCENT]]] FROM table A SELECT statement containing thes...
Access 2007
FROM Clause
Article Specifies the tables or queries that contain the fields listed in the SELECT statement. Syntax SELECT fieldlist FROM tableexpression [IN externaldatabase ] ...
Access 2007
Avg Function
Article To calculate the average for a set of numbers, use the AVG function.
Access 2010, Access 2007
CREATE VIEW Statement
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-Microso...
Access 2007
CREATE USER or GROUP Statement
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 gr...
Access 2007
CREATE PROCEDURE Statement
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, with...
Access 2007
EXECUTE Statement
Article Used to invoke the execution of a procedure . Syntax EXECUTE procedure [ param1 [ , param2 [, ...]] The EXECUTE statement has these parts : Part Descriptio...
Access 2007
DROP Statement
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 does n...
Access 2007
PREV123NEXT
Didn't find what you were looking for?Search all of Office.com