ACCESS review LIST

tables

field

record

primary key

autonumber

data type

required field

validation rule

datasheet view

queries

filters

sorting

how to specify searching conditions using operators such as > >= < <= = etc.

parameter query

how to sort

criteria

forms

reports

relationship

queries from two tables, multiple tables

special matching characters such as * match any characters and ? match a single character

statistic functions

group by

count

Summation

By default, an access application file extension for a database is .accdb after Office 2007.

Before 2007 version, the access file uses .mdb as extension name.

Excel and ACCESS