Microsoft Access 2007
Basic
Outline
- Unit 1: Getting started
- Database concepts
- Exploring the Access environment
- Getting help
- Closing a database and Access
- Unit 2: Databases and tables
- Planning and designing databases
- Exploring tables
- Creating tables
- Unit 3: Fields and records
- Changing the design of a table
- Finding and editing records
- Organizing records
- Unit 4: Data entry rules
- Setting field properties
- Working with input masks
- Setting validation rules
- Using indexes
- Unit 5: Simple queries
- Creating and using queries
- Modifying query results and queries
- Performing operations in queries
- Unit 6: Using forms
- Creating forms
- Using the Form Wizard
- Using Design view
- Finding, sorting, and filtering records
- Unit 7: Working with reports
- Creating reports
- Modifying and printing reports
Intermediate
Outline
- Unit 1: Relational databases
- Database normalization
- Relating tables
- Implementing referential integrity
- Unit 2: Working with related tables
- Lookup fields
- Modifying Lookup fields
- Subdatasheets
- Unit 3: Complex queries
- Joining tables in queries
- Creating calculated fields
- Summarizing and grouping values
- Unit 4: Advanced form design
- Adding unbound controls
- Graphics
- Adding calculated values
- Adding combo boxes
- Unit 5: Advanced reports
- Customized headers and footers
- Adding calculated values
- Sub reports
- Unit 6: Charts
- Charts in forms
- Charts in reports
- Unit 7: PivotTables and PivotCharts
- PivotTables
- Modifying PivotTables
- PivotCharts
- Unit 8: Internet integration
- Hyperlink fields
- Working with data access pages
Advanced
Outline
- Unit 1: Querying with SQL
- SQL and Access
- Writing SQL statements
- Attaching SQL queries to controls
- Unit 2: Advanced queries
- Creating cross tab queries
- Creating parameter queries
- Using action queries
- Unit 3: Macros
- Creating, running, and modifying macros
- Attaching macros to the events of database objects
- Unit 4: 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
- Unit 5: Importing, exporting, and linking objects
- Importing objects
- Exporting objects
- Interacting with the XML documents
- Linking Access objects
- Working with Windows SharePoint Services
- Unit 6: Database management
- Optimizing resources
- Replicating and synchronizing databases
- Unit 7: Security fundamentals
- Protecting databases
- Encrypting and decrypting databases
- User-level security
