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 Events Calendar
Upcoming Training Calendar
Training and Workshops
Course Catalog
Upcoming Events
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 (6/19/2012 - 6/21/2012)
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
06/19/2012 - 12:00 AM
-
06/21/2012 - 12:00 AM
Location Address
1730 East Elm
65101 MO
United States
Map Address
Notes
Introduction to Microsolf Access 2010
Class Capacity
12
