[ LiB ] |
Terms you'll need to understand:
Database
Relational database
Table
Row
Field/column
Record
Data type
View mode
Design view
Primary key
Index
Relationship
Query
Criteria
Report
Techniques you'll need to master:
Creating and modifying database objects such as tables, queries, forms, and reports
Applying appropriate data types and understanding the consequences of your choices
Understanding how a relational database works and the purpose of primary keys
Knowing when and how to index a field or fields
Searching for text in a table or form
Creating queries to limit data
Limiting data using criteria expressions
Creating and printing reports
Grouping and summarizing data in a report
Knowing your way around a database can be a great asset: it's a growing expertise, and you need to know how to enter and manipulate stored data. This module on database applications covers the following topics:
Using the application
Tables
Forms
Retrieving data
Reports
Preparing outputs
Access database toolbar.
Access table datasheet toolbar.
Access table design toolbar.
Access relationships toolbar.
Access query datasheet toolbar.
Access query design toolbar.
Access form view toolbar.
Access form design toolbar.
Access formatting (form/report) toolbar.
Access print preview toolbar.
Access report design toolbar.
[ LiB ] |