YoVDO

Access Essential Training (Office 365/Microsoft)

Offered By: LinkedIn Learning

Tags

Microsoft Access Courses Database Management Courses Data Validation Courses

Course Description

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
1. Getting Started
  • 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
2. Creating Tables
  • Table structures and relationships
  • Create a table and set data types
  • Enter data
  • Primary and foreign keys
  • Import tables
3. Setting Field Properties
  • 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
4. Organizing Records
  • Sort table data
  • Filter table data
  • Delete records
  • Search and replace values
5. Using Queries
  • 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
6. Creating Forms
  • Understand the role of forms
  • Generate forms from tables
  • Adjust form elements in Layout view
  • Use the Form Wizard
  • Form Design view
  • Find records
7. Creating Reports
  • 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
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