Introduction
Microsoft Access is a general-purpose, versatile and powerful database management software. In this course, you will build databases that store and retrieve data efficiently, as well as editing and modifying fields and records.
Furthermore, this course also teaches you how to generate basic queries and action queries, creating and designing forms, macros, and database maintenance.
Course Outline
- Introduction to Access
- Database concepts
- Understanding database files
- The Access workspace
- Tables
- Table structure and relationships
- Table creation and entering data
- Primary and foreign keys
- Importing tables
- Setting Field Properties
- Understanding relationships
- Table structure in Design view
- Masks
- Setting default values
- Validation rules
- Lookup fields and field properties
- Records
- Formatting columns
- Sorting and filtering data
- Find and replace
- Queries
- Understanding queries
- Creating simple queries
- Creating queries in design view
- Adding criteria
- Wildcards
- AND and OR statements
- Mathematical comparisons
- Parameter requests
- Building expressions
- Summary statistics
- Special queries
- Update queries
- Make table queries
- Unmatched records
- Delete and append queries
- Union query
- Forms
- Understanding forms
- Generating forms
- Using the form wizard
- Designing forms
- Adding components to forms
- Navigation forms
- Reports
- Understanding reports
- Using the report wizard
- Creating and editing reports
- Grouping and sorting
- Calculated totals
- Conditional formatting
- Labels
- Macros
- Understanding macros
- Creating and embedding simple macros
- Attaching data macros
- Database Maintenance
- Compacting and repairing databases
- Database object dependencies
- Database documenter tool
- Splitting databases
- Database protection