Description
In this course, you will learn:
- How to wrangle your data and gain deeper insights by leveraging the power of Microsoft Access 2019.
- How to use Access to build databases that help you store and retrieve your data more efficiently.
- How to build tables—the foundation of any database—as well as how to define the relationships between tables and use queries to find and filter data.
- How to build an interface for the database from forms, complete with combo boxes; create reports for printing and sharing; and take steps to maintain your database.
Syllabus:
- Introduction
- Building databases with Access
- What you should know
1. Getting Started
- 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
2. Creating Tables
- Table structures and relationships
- Create a table and set data types
- Enter data
- Primary and foreign keys
- Importing tables
3. Setting Field Properties
- 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
4. Organizing Records
- Sorting table data
- Filtering table data
- Deleting records
- Searching and replacing values
5. Using Queries
- 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
6. Creating Forms
- Understand the role of forms
- in Layout view
- Using the Form Wizard
- Sign view
- Find records
7. Creating Reports
- 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
8. Maintaining the Database
- 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