|
| |
Microsoft Access
2003
Basic
- Getting Started: Database concepts, exploring
the Access environment, getting help, closing a database and Access
- Databases and tables: Planning and designing
databases, exploring tables, creating tables
- Fields and records: Changing the design of a
table, finding and editing records, organizing records
- Data Entry rules: Setting field properties,
working with input masks, setting validation rules, using indexes
- Simple queries: Creating and using queries,
modifying query results and queries, performing operations in queries
- Using forms: Creating forms, using the Form
Wizard, using Design view, finding, sorting, and filtering records
- Working with reports: Creating reports,
modifying and printing reports
Intermediate
- Relational databases: Database normalization,
relating tables, implementing referential integrity
- Working with related tables: Lookup fields,
modifying Lookup fields, subdatasheets
- Complex queries: Joining tables in queries,
creating calculated fields, summarizing and grouping values
- Advanced form design: Adding unbound controls,
graphics, adding calculated values, adding combo boxes
- Advanced reports: Creating customized headers
and footers, adding calculated values, subreports
- Charts: Charts in forms, charts in reports
- PivotTables and PivotCharts: PivotTables,
modifying PivotTables, PivotCharts
- Internet integration: Hyperlink fields,
working with data access pages
Advanced
- Querying with SQL: SQL and Access, Writing SQL
statements, attaching SQL queries to controls
- Advanced queries: Creating crosstab queries,
creating parameter queries, using action queries
- Macros: Creating, running, and modifying
macros, attaching macros to the events of database objects
- Advanced Macros: Creating macros to provide
user interaction, creating macros that require user input, creating the
AutoKeys and AutoExec macros, creating macros for data transfer
- Importing, exporting, and linking objects:
Importing objects, exporting objects, interacting with the XML documents,
linking Access objects, working with Windows SharePoint services
- Database management: Optimizing resources,
replicating and synchronizing database
- Security fundamentals: Protecting databases,
encrypting and decrypting databases, user-level security
|
