BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Black Atlas Training - ECPv6.18.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://blackatlastraining.com
X-WR-CALDESC:Events for Black Atlas Training
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Regina
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Regina:20261203T083000
DTEND;TZID=America/Regina:20261203T163000
DTSTAMP:20261013T231908Z
CREATED:20261013T231655Z
LAST-MODIFIED:20261013T231908Z
UID:10000240-1796286600-1796315400@blackatlastraining.com
SUMMARY:Microsoft Access: Intermediate
DESCRIPTION:Microsoft Access: Intermediate				\n				\n				\n				\n					\n		\n	Dec 3\, 2026 @ 8:30am to 4:30pm	\n\n				\n				\n				\n				\n							\n					\n				\n					\n				\n				\n																														\n				\n				\n				\n							\n						\n				\n					\n				\n				\n				\n						\n				\n				\n				\n							\n					\n				\n					\n				\n				\n									Instructor:  Brandon Mack\nDelivery: In-person\nLength: 1 Day\nDifficulty: Advanced								\n				\n				\n				\n					Join us for this course\nRegister Now				\n				\n					\n				\n				\n				\n						\n				\n				\n				\n							\n					\n				\n					\n				\n				\n					Course Overview				\n				\n				\n				\n									Your training and experience using Microsoft Access has given you basic database management skills\, such as creating tables\, designing forms and reports\, and building queries. In this course\, you will expand your knowledge of relational database design\, write advanced queries\, structure existing data\, validate data entered into a database\, and customize reports. Extending your knowledge of Microsoft Access will result in a robust\, functional database for your users. 								\n				\n				\n				\n					Prerequisites				\n				\n				\n				\n									You should have basic knowledge of Windows including opening applications and opening files from File Explorer. You should have a working knowledge of all topics covered in Access Novice. 								\n				\n				\n				\n					What You Will Learn				\n				\n				\n				\n					\n\n01\nDesigning a Relational Database\n\n\n\nRelational Database Design\n\n\n\nCreate a Table\n\n\n\nCreate Table Relationships\n\n\n02\nJoining Tables\n\n\n\nCreate Query Joins\n\n\n\nRelate Data Within a Table\n\n\n\nWork with Subdatasheets\n\n\n03\nUsing Data Validation\n\n\n\nUse Field Validation\n\n\n\nUse Form and Record Validation\n\n\n04\nCreating Advanced Queries\n\n\n\nCreate Parameter Queries\n\n\n\nSummarize Data\n\n\n\nCreate Subqueries\n\n\n\nCreate Action Queries\n\n\n\nCreate Unmatched and Duplicate Queries\n\n\n05\nOrganizing a Database for Efficiency\n\n\n\nData Normalization\n\n\n\nCreate a Junction Table\n\n\n\nImprove Table Structure\n\n\n06\nUsing Advanced Reporting Techniques\n\n\n\nInclude Control Formatting in a Report\n\n\n\nAdd a Calculated Field to a Report\n\n\n\nAdd a Subreport to an Existing Report\n\n				\n				\n				\n				\n					Included With The Course				\n				\n				\n				\n					\n\n\nProfessional textbook (physical and digital)\n\n\n\nUnused copy of any files referenced throughout the textbook.\n\n\n\nCertificate of completion signed by the instructor.\n\n				\n				\n				\n				\n					Associated Certifications				\n				\n				\n				\n									Not applicable. 								\n				\n				\n				\n					Frequently Asked Questions				\n				\n				\n				\n									We understand that you may have questions\, and we’re here to help! Some of the most commonly asked questions about this course are covered below but if they don’t cover what you are looking for feel free to reach out to us through our contact page\, and we’ll respond promptly to ensure you get the assistance you require. Your satisfaction is our priority\, and we’re committed to making sure you have all the information necessary for a seamless experience. 								\n				\n				\n				\n					\n\n\n\n01. What version of OneNote does this course prepare me for?\n\n\n\nThere are a few different versions of OneNote out there. There is the online version that comes with Microsoft 365\, the version that comes installed with Windows\, and the Microsoft 365 desktop application. This course covers the Microsoft 365 desktop application but a lot of the features can be found in the others as well. \nYou can find additional information on the different versions of OneNote by clicking here. \n\n\n\n\n				\n				\n					\n				\n				\n				\n						\n				\n				\n				\n					Registration				\n				\n				\n				\n									Use the registration form below to register attendees for this course. Once you are registered we will be in touch to coordinate payment. We look forward to seeing you! 								\n				\n				\n				\n							\n	\n\n		\n		\n		\n\n		\n\n\n		\n\n\n\n	Seats\n\n		\n	\n	\n		The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.	\n\n\n		\n\n	\n		\n				Microsoft Access: Intermediate	\n\n\n\n	\n		\n		\n				\n					$\n					495.00\n				\n						\n\n\n	\n\n\n	\n	\n\n\n	\n\n\n	\n						\n	Decrease ticket quantity for Microsoft Access: Intermediate\n	-\n				\n\n	\n		Quantity	\n	\n\n					\n	Increase ticket quantity for Microsoft Access: Intermediate\n	+\n			\n\n	\n		\n	\n\n\n		\n\n	\n	\n	\n		Seats:	\n	0\n\n\n	\n	\n		Total:	\n	\n		\n				\n					$\n					0.00\n				\n				\n\n\n	\n	Reserve Seat(s)
URL:https://blackatlastraining.com/calendar/2026-12-03-microsoft-access-intermediate/
LOCATION:Black Atlas Training\, 127 22nd Street West\, Saskatoon\, Saskatchewan\, S7M 5M2\, Canada
CATEGORIES:Microsoft Access: Intermediate,Microsoft Office
ORGANIZER;CN="Black Atlas Training":MAILTO:hello@blackatlastraining.com
END:VEVENT
END:VCALENDAR