BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//AdvantEdge Training & Consulting - ECPv6.15.19//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://www.advantedge-training.com
X-WR-CALDESC:Events for AdvantEdge Training & Consulting
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Denver
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20220313T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20221106T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20230312T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20231105T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20240310T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20241103T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20230130T080000
DTEND;TZID=America/Denver:20230201T160000
DTSTAMP:20260422T011125
CREATED:20230110T150954Z
LAST-MODIFIED:20230110T150954Z
UID:10000090-1675065600-1675267200@www.advantedge-training.com
SUMMARY:Access Boot Camp
DESCRIPTION:Microsoft Access Boot Camp Training\nClass Duration: 3 days\nDo you need to master building and managing databases in a hurry?  Our Boot Camp is an intensive crash course in Access. You will start with the basics\, such as navigation and basic forms\, and work your way through to the advanced features of the application\, such as macros and writing statements in SQL.  There will be ample of hands-on activities that allow you to be sure you have mastered each lesson\, and our experienced educators will be there to lead you to a thorough understanding of the material. This intensive three-day Access Boot Camp will take you from beginner to master of this powerful database application. \nTraining Class Goal\nStudents who complete this Access Boot Camp will learn to navigate\, build\, and manage databases.  They will learn to work with forms\, fields\, records\, and queries.  Students will be able to generate reports of their data\, and give it visual impact with PivotTables and Charts.  They will understand how to use macros and to write statements in SQL\, as well as to integrate internet applications into their databases. \nPrerequisites\nStudents should enter this Microsoft Access Boot Camp possessing intermediate computer skills\, and have some experience with Microsoft Excel and other Microsoft Office programs. \nTopics Covered\n\n\nDesign versus Datasheet View\nDatabase wizard\nCreating blank databases\nCreating tables\n\nWorking with Fields\n\nAdding fields\nIdentifying primary key fields\nAdding records\nChanging table designs\nModifying field names\nDeleting and inserting fields\n\nRecords\n\nFinding and editing records\nSorting and filtering records\nSetting field properties\nInput Masks\nValidation Rules\nIndexes\n\nQueries\n\nCreating Queries\nFiltering Queries\nModifying query results\nOperations in Queries\nUsing Calculators\nAverage and Count functions\nCreating forms to enter data\nFormatting and customizing forms\nUsing forms to find\, sort\, and filter records\nCreating reports through the report wizard\nField properties\n\nRelational databases\n\nDatabase normalization\nTable Relationships\nReferential integrity\n\nRelated Tables\n\nCreating lookup fields\nModifying lookup fields\nSub-datasheets\n\nComplex queries\n\nJoining tables in a query\nUsing calculated fields\nSummarizing and grouping values\n\nAdvanced form design\n\nAdding unbound controls\nGraphics\nAdding combo boxes\n\nReports and printing\n\nCustomized headers and footers\nCalculated values\nLabels\n\n\nCharts in forms and reports\nPivot Tables and Pivot Charts\n\nQuerying with SQL\n\nSQL and Access\nWriting SQL statements\nAttaching SQL queries to controls\n\nAdvanced Queries\n\nCreating parameter queries\nUsing Action queries\n\nMacros\n\nCreating\, running\, and modifying macros\nAttaching macros to the events of database objects\n\nAdvanced Macros\n\nCreating macros to provide user interaction\nCreating macros that require user input\nCreating the AutoKeys and AutoExec macros\nCreating macros for data transfer\n\nImporting\, Exporting\, and Linking\n\nImporting objects\nExporting objects\nInteracting with XML documents\nLinking Access objects\nWorking with Windows SharePoint Services\n\nDatabase Management\n\nOptimizing resources\nProtecting databases\nSetting options and properties\n\nInternet Integration\n\nHyperlink fields\nWorking with Outlook\nNavigation Forms\nTabbed Forms\nSwitchboards\nSplash Screens\nRead-Only Forms\nWorkshop – Instructor led assistance on individual student databases\n\nGet a database crash course with our Microsoft Access Boot Camp and go from novice to master in just five knowledge-packed days! Our courses are designed specifically for companies and their employees. \n\n 
URL:https://www.advantedge-training.com/class/access-boot-camp-2023-1-30/
CATEGORIES:Access
ATTACH;FMTTYPE=image/png:https://www.advantedge-training.com/wp-content/uploads/2020/02/access.png
END:VEVENT
END:VCALENDAR