YoVDO

Access 2019 Essential Training

Offered By: LinkedIn Learning

Tags

Microsoft Access Courses Database Management Courses Data Validation Courses

Course Description

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
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
  • Generate forms from tables
  • Adjusting form elements in Layout view
  • Using the Form Wizard
  • Form Design 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
Conclusion
  • Next steps

Taught by

Adam Wilbert

Related Courses

Diseño de sistemas de información gerencial para intranet con Microsoft Access
Universidad del Rosario via edX
Competencias digitales de ofimática: Microsoft Access
Universitat Autònoma de Barcelona (Autonomous University of Barcelona) via Coursera
Diseño de software para la toma de decisiones organizacionales
Universidad del Rosario via edX
Excel to Access: Intro to Microsoft Access for Excel Users
Udemy
Access 2007: Shortcuts
LinkedIn Learning