MS Access 2007 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 7: MS Access Built-In Functions
Step 1: MS Access Built-in Functions
Figure 7-1: Built-in functions available in Query Design View.
________________________________________
MS Access comes with lots of built-in functions. You can use the power
of these functions while building a query. To access these built-in
functions lets develop the query as a first step.
1. As shown Figure 7-1 with label 1, click the “Create” command on the
menu bar.
2. Click the “Query Design” command on the “Create” command’s ribbon as
shown with label 2 in Figure 7-1.
3. After clicking “Query Design”, select the already existing table(s)
or queries or both as shown in Figure 7-2 with labels 1 and 2. This will
be data-source for you new query.
4. Finally click the <Add> button.
Figure 7-2: Tables tab provides the list of all the tables whereas
Queries tab provides the list of all queries.
________________________________________
Chapter 7: MS Access Built-In Functions
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: