|
If databases are your preference, then this manual could be for you. It covers all aspects required by the ECDL/ICDL Advanced AM5 syllabus, but could assist those wishing to further their database knowledge. Included are exercises ranging from creating a database to creating complex grouped reports and performing action queries. Useful data files, which allow you to practise the different software features, are available on the web. Approved by the ECDL Foundation.
This title contains approximately 160 pages and covers the following topics:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
| | Creating a New Database
Using Wildcards in Queries
Performing Various Queries
Applying Relationships
Applying Joins
Referential Integrity
Querying Multiple Tables
Lookup Fields
Default Values
Setting a Mandatory Field
Validation Rules/Text
Input Masks
Using Forms with Subforms
Calculated Fields
Command Buttons
Combo Boxes
Other Form Controls
Creating and Printing Reports
Grouped Reports
Importing and Exporting Data
Using Action Queries
Using Query Wizards
Creating and Using Macros
Other Macros
|
|