Subject
Computer Science
Business
Humanities
Data Science
Personal Development
Art & Design
Programming
Engineering
Health & Medicine
Mathematics
Science
Social Sciences
Education & Teaching
Online degrees
Microcredentials
Provider
Unitersity
Institution
Picture book
SignIn
SignUp
Subject
Computer Science
Business
Humanities
Data Science
Personal Development
Art & Design
Programming
Engineering
Health & Medicine
Mathematics
Science
Social Sciences
Education & Teaching
Online degrees
Microcredentials
Provider
Unitersity
Institution
Picture book
SignIn
SignUp
Access 2019 Essential Training
0
Join & Subscribe
LinkedIn Learning
Free Trial Available
English
Certificate Available
3-4 hours worth of material
selfpaced
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
CompTIA Security+ (SY0-601) Cert Prep: 4 Identity and Access Management Design and Implementation
SSCP Cert Prep: 1 Access Controls
Access 2019: Queries
Access Quick Tips
Access 2016: Reporting to Web Systems
Access 2019 Essential Training