Chapter 6. Database

[ 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 ]  


ICDL Exam Cram 2
ICDL Exam Cram 2
ISBN: 0789730928
EAN: 2147483647
Year: 2006
Pages: 142

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net