Overview
-
Wrangle your data by leveraging the power of Microsoft Access 2019. Learn how to use Access to build databases that help you store and retrieve your data more efficiently.
Syllabus
-
Introduction
- Building databases with Access
- What you should know
- Database concepts
- Create the database file
- Understand the Trust Center
- Digging into Ribbon tabs
- The 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
- Importing tables
- Relationships and referential integrity
- Editing table structure in Design view
- Control input with masks
- Set a default value
- Data validation rules
- Data lookup fields
- Additional field properties
- Sorting table data
- Filtering table data
- Deleting records
- Searching and replacing values
- What are queries?
- The Simple Query Wizard
- Build queries in Design view
- Establishing constraints with criteria
- Specifying criteria with wildcards
- Incorporating AND and OR statements
- Filtering with mathematical comparisons
- Create flexible queries with parameters
- Build expressions
- Obtain summary statistics
- Understand the role of forms
- Generate forms from tables
- Adjusting form elements in Layout view
- Using the Form Wizard
- Form Design view
- Find records
- Introducing reports
- The Report Wizard
- Edit a report in Design view
- Edit a report in Layout view
- Group and sort records
- Creating 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
