Skip to main content
Employment
RFQ/RFPs
Contact Us
+ Login
+ Register
CenSARA
Central States Air Resource Agencies
Home
Board of Directors
Member Organization Information
Policies / Procedures
Staff Contacts
What is the mission of CenSARA?
Calendars
About the Different Calendars
CenSARA Business Calendar
National Meetings And Conferences
Upcoming Training Calendar
Training and Workshops
Course Catalog
Upcoming Training
Upcoming Training Calendar
Requesting Travel Assistance
Links
Materials
Helpful Links
RH Committee Call Notes
RH - Ramboll
Committees
Committee Files
Committees
User
Login
Create a CenSARA Account
User Transcript
User Certificates
Create an EPA AirKnowledge Account
Search
150 CenSARA Introduction to Microsoft Access (4/16/2024 - 4/17/2024)
Breadcrumb
Home
Information
Description
(active tab)
Who Should Attend
Objectives
Pre-Requisites
Classroom Requirements
File Uploads
Change History
Description
Description
This 2 1/2 day accelerated course is designed to jump start students into the world of databases using Access
Who Should Attend
Who Should Attend
Anyone that has to manage databases using Microsoft Access
Objectives
Leaning Objectives
Student upon completion will be able to:
• Use the Access 2010 Interface
• Create a database
• Avoid Reserved words
• Creat Tables, Queries, Forms, Reports, and Macros
• Import Data
• Fields – Properties
• Relationships – Primary Keys
• Calculations and functions in queries
• Create comboboxes
• Database Management
• Split a Database
• Creating Switchboards
•ODBC connections and SQL
Pre-Requisites
Pre-Requisites
Microsoft Word or Excel
Classroom Requirements
Classroom Requirements
Must be held in a computer lab or the agency must supply laptops.
File Uploads
Other Files
Concat.docx
(16.31 KB)
EmployeesDelta.txt
(10.32 KB)
How to Create a Multivalued Field.docx
(156.89 KB)
Reserve Words in Access.doc
(31 KB)
Employees.accdb
(316 KB)
Employees.xls
(35 KB)
EmployeesWithData.accdb
(6.31 MB)
States.xls
(43 KB)
150 CenSARA Student Exercises.pdf
(41.16 MB)
Change History
Dates
04/16/2024 - 03:30 PM
-
04/17/2024 - 10:00 PM
Instructor1
Ron Hensley
Location Address
707 N. Robinson
73102 OK
United States
Map Address
Classroom Hours
12
Class Capacity
15
