Overview
-
Harness the power of databases using Microsoft Access. Learn how to build tables, define relationships, create queries, and more, using the Office 365 version of the program.
Syllabus
-
Introduction
- Build databases with Access
- What you should know
- Database concepts
- Create the database file
- Understand the Trust Center
- Dig into ribbon tabs
- Database navigation pane
- Customize the Quick Access Toolbar
- Create a database backup
- Table structures and relationships
- Create a table and set data types
- Enter data
- Primary and foreign keys
- Import tables
- Relationships and referential integrity
- Edit table structure in Design view
- Control input with masks
- Set a default value
- Data validation rules
- Data lookup fields
- Additional field properties
- Sort table data
- Filter table data
- Delete records
- Search and replace values
- What are queries?
- Simple Query Wizard
- Build queries in Design view
- Establish constraints with criteria
- Specify criteria with wildcards
- Incorporate AND and OR statements
- Filter with mathematical comparisons
- Create flexible queries with parameters
- Build expressions
- Obtain summary statistics
- Understand the role of forms
- Generate forms from tables
- Adjust form elements in Layout view
- Use the Form Wizard
- Form Design view
- Find records
- Introduce reports
- Report Wizard
- Edit a report in Design view
- Edit a report in Layout view
- Group and sort records
- Create calculated totals
- Apply conditional formatting rules
- Create labels
- Adjust print settings
- Customize groups in the navigation pane
- Compact and repair the database
- Examine database object relationships
- Document your thought process
- Print the blueprint of your database
- Split a database into front and back ends
- Protect the database with a password
- Set startup options
- Next steps
