Skip to main content

Microsoft Access - Level 1

ID : 38713   
« back to classes page
COURSE OUTLINE

Understanding Relational Databases
•    Learn about Access Objects & Terminology
•    Discuss Design & Planning a Database
Create an Access Database
•    Navigate the Different Views
•    Work with Field Properties & Data Types
•    Understand the Concept of Primary Keys
•    Work with Relationships and Referential Integrity
•    Discuss Join Types
Data Basics
•    Add, Save and Find Records
•    Work with Filters and Sorting
•    Move and Copy Data
•    Learn data entry shortcuts
Creating the Basic Query
•    Create Select Queries
•    Understand the Design Grid
•    Use Comparison Operators
•    Learn And and Or Conditions
Use Queries for Calculations
•    Perform Calculations in a Query
•    Calculate Groups & Aggregate Functions
Create Variable Queries
•    Use Variables to Create Dynamic Queries
•    Use Variable in Calculations
•    Work with Query Parameters

Class Details

1 Sessions
Weekly - Tue

Location
NMJC Training & Outreach Facility

Instructor
Darla Cloud 

Tuition: 

$99.00


Registration Closes On
Monday, October 1, 2018 @ 12:00 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s) Instructional Method
10/2/2018 - 10/2/2018 Weekly - Tue 9:00 AM - 4:00 PM Hobbs, NMJC Training & Outreach Facility  Map Darla Cloud  ClassRoom