Integrity Training – Microsoft Office Access 2016 Basic
The Microsoft Office Access 2016: L1 course helps the individuals and their organizations to collect and manage large amounts of data. Microsoft Office Access 2016: L1 course allows the candidates to use Microsoft Office Access 2016 as a personal data management tool, or to develop applications for a department or an entire organization. The course focuses on the Access 2016 to manage the data by creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Microsoft Office is critical to the day to day operations of any organization. This course is specifically focused on the Microsoft Office Access 2016 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2016.
Course Curriculum
- Start
Course Introduction (1:15)
- Start
Courseware (0:15)
- Start
Instructor Introduction (1:02)
- Start
Getting Started with Access (0:59)
- Start
Topic A: Orientation to Microsoft Access (0:11)
- Start
Transform Data into Knowledge (1:54)
- Start
Using Access Instead of Excel (2:09)
- Start
Using Access Instead of Other Databases (1:11)
- Start
Access as a Web Development Tool (1:23)
- Start
Demo – Launching Access and Opening a Database (4:26)
- Start
Access 2016 Window Components (3:54)
- Start
Record Navigation Bar (1:10)
- Start
Table Relationship (2:10)
- Start
Demo – Navigating and Editing Data in Tables (6:47)
- Start
Demo – Navigating and Editing Data in Forms (3:59)
- Start
A Query Join (1:24)
- Start
Demo – Using Queries (2:05)
- Start
Sample Report (0:38)
- Start
Demo – Using Reports (1:38)
- Start
Demo – Exploring Access Ribbon Commands (3:00)
- Start
Topic B: Create a Simple Access Database (0:06)
- Start
Database Templates (1:10)
- Start
Web App Templates (0:24)
- Start
Demo – Creating a New Database (8:09)
- Start
Topic C: Get Help and Configure Options in Microsoft Access (0:08)
- Start
Access Help Window (0:42)
- Start
Access Options (0:45)
- Start
Demo – Getting Help and Setting Access Options (3:09)
- Start
Chapter 01 Review (0:49)
- Start
Chapter 01 Quiz
- Start
Working with Table Data (0:38)
- Start
Topic A: Modify Table Data (0:09)
- Start
Autocorrect Menu (2:14)
- Start
Demo – Undoing Record Modifications (3:33)
- Start
Record Navigation Bar (1:17)
- Start
Demo – Using Quick Search to Find and Modify Records (1:50)
- Start
Find and Replace Dialog Box (1:05)
- Start
Demo – Using Find and Replace to Modify Records (2:49)
- Start
Datasheet Totals (0:51)
- Start
Demo – Adding a Totals Row to a Datasheet (2:46)
- Start
Topic B: Sort and Filter Records (0:08)
- Start
Sorting by Dept (1:08)
- Start
Demo – Sorting and Filtering Records (3:25)
- Start
Chapter 02 Review (0:35)
- Start
Chapter 02 Quiz
Get Integrity Training – Microsoft Office Access 2016 Basic at tenco.pro
Reviews
There are no reviews yet.