150 CenSARA Introduction to Microsoft Access (12/12/2023 - 12/14/2023)

Information
Description
This 2 ½ day accelerated course is designed to jump start students into the world of databases using Access
Who Should Attend
Anyone that has to manage databases using Microsoft Access
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
Microsoft Word or Excel
Classroom Requirements
Must be held in a computer lab or the agency must supply laptops.
Other Files
Concat.docx, EmployeesDelta.txt, How to Create a Multivalued Field.docx, Reserve Words in Access.doc, Employees.accdb, Employees.xls, EmployeesWithData.accdb, States.xls, 150 CenSARA Student Exercises.pdf (16.31 KB)
EmployeesDelta.txt (10.32 KB)
How%20to%20Create%20a%20Multivalued%20Field.docx (156.89 KB)
Reserve%20Words%20in%20Access.doc (31 KB)
Employees.accdb (316 KB)
Employees.xls (35 KB)
EmployeesWithData.accdb (6.31 MB)
States.xls (43 KB)
150%20CenSARA%20Student%20Exercises.pdf (41.16 MB)
Dates
-
Location Address

12100 Park 35 Circle, Building A, Room 173
78753 TX
United States

Map Address
Classroom Hours
16
Class Capacity
15
Registration Reports
Instructor1
Ronald Hensley