BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Interactive Training 365 - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Interactive Training 365
X-ORIGINAL-URL:https://interactivetraining365.com
X-WR-CALDESC:Events for Interactive Training 365
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Edmonton
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20190310T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20191103T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20200308T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20201101T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20210314T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20211107T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Edmonton:20201109T090000
DTEND;TZID=America/Edmonton:20201110T150000
DTSTAMP:20260416T002422
CREATED:20200908T193259Z
LAST-MODIFIED:20200908T204736Z
UID:1957-1604912400-1605020400@interactivetraining365.com
SUMMARY:Microsoft Access Level I - NOVEMBER
DESCRIPTION:Microsoft Access Level I\n(Database Design)\n(2-day Course)\nOnline Format (Zoom\, WebEx\, Google Meet)\nGeneral Overview: \nAccess is Microsoft’s flagship database application which allows you to create and manage databases for many different purposes. Access incorporates features and connectivity options to make databases more accessible to the everyday user. \nLearning Objectives: \nBy the end of this 2-day course\, you will be comfortable with navigating the Access 2016 interface\, creating a new database from scratch\, querying a database\, performing calculations\, generating reports\, sharing data\, and much more. \nYou will: \n\nLearn the Access interface\nCreate an Access database\nWork with tables and records\nSort and filter records\, and create lookup fields\nQuery a database and perform calculations in a query\nCreate parameter queries and action queries\nGenerate reports and add controls\nDesign a relational database\nOrganize report information\, format reports\, and include charts and calculated fields\nImport and export data to other applications \n\nTarget Student: \nThis course is intended for individuals who are new to Microsoft Access who would like to get up to speed quickly and become familiar with using Access to create and to query a database\, perform calculations\, organize information\, generate reports\, and share data with others effectively.  The course will also include database design. \n\nCourse Outline: \nDay  1 \nSection 1: The Basics \n\nDatabase Concepts\nGetting Started\nCreating a Database\nConverting Access Files\nWorking with Objects\nUsing Access Help\nReview Exercise\n\nSection 2: Table Data \n\nTable Concepts\nViewing Data in a Table\nChanging the Database Appearance\nEntering and Editing Data\nApplying Filters\nReview Exercises\n\nSection 3: Table Design \n\nCreating a Table\nChanging the Table Design\nReview Exercises \n\nSection 4: Data Entry \n\nData Entry Concepts\nData Formats\nInput Masks\nInput Validation\nAdding Records\nReview Exercise\n\nSection 5: Relationships \n\nRelationship Between Tables\nCreating a Relationship\nReferential Integrity\nRemoving a Relationship\nPrinting Relationships\nReview Exercise\n\nDay II \nSection 6:  \n\nCreating a Form Using AutoForm\nCreating a Form Using the Form Wizard\nCreating a Form in Design View\nOpening a Form\nChanging a Form Design\nAdding Controls\nPlacing Controls\nMultiple-Choice Controls\nError Checking\nReview Exercise\n\nSection 7:  \n\nUsing the Query Wizard\nCreating a Query in Design View\nSelecting and Sorting in a Query\nCalculations\nAction Queries\nParameter Queries\nReview Exercise\n\nSection 8:  \n\nCreating Reports\nUsing the Report Wizard\nPreviewing Reports\nCreating Reports in Design View\nChanging Report Designs\nControl Operations\nControl Attributes\nReview Exercise\n\nSection 9: Importing and Exporting Data \n\nImporting and Exporting\nImporting a Text File\nImporting Data from an Access Database\nExporting Data\nTroubleshooting Importing and Exporting Problems\n\nSection 10: \n\nPrinting Objects\nPrint Preview\nCustomize General and Language Options\nCustomize the Ribbon and Quick Access Toolbar\n\n*All Classes are instructor led.\nClass recording will be made available after the class.
URL:https://interactivetraining365.com/event/microsoft-access-level-i-november/
LOCATION:VIRTUAL
CATEGORIES:Access
ATTACH;FMTTYPE=image/jpeg:https://interactivetraining365.com/wp-content/uploads/2020/09/MicrosoftAccessTraining.jpg
END:VEVENT
END:VCALENDAR