BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Executrain - ECPv4.9.12//NONSGML v1.0//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALNAME:Executrain X-ORIGINAL-URL: X-WR-CALDESC:Events for Executrain BEGIN:VTIMEZONE TZID:Europe/Helsinki BEGIN:DAYLIGHT TZOFFSETFROM:+0200 TZOFFSETTO:+0300 TZNAME:EEST DTSTART:20190331T010000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0300 TZOFFSETTO:+0200 TZNAME:EET DTSTART:20191027T010000 END:STANDARD END:VTIMEZONE BEGIN:VEVENT DTSTART;TZID=Europe/Helsinki:20190304T083000 DTEND;TZID=Europe/Helsinki:20190305T163000 DTSTAMP:20210919T175437 CREATED:20170226T091854Z LAST-MODIFIED:20190218T113638Z SUMMARY:Access 2016 - Basic (2 Days) DESCRIPTION:Most organisations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored\, linked\, and managed using a single relational database application and its associated tools. In this course\, you will examine the basic database concepts\, and create and modify databases and their various objects using the Microsoft® Office AccessTM 2013 relational database application. \n\n\nWho is this course for?\nThis course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities\, and to understand the advantages that using a relational database program can bring to their business processes. The Basic course is for the individual whose job responsibilities include designing and creating new databases\, tables and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database \nPre-requisites\n\nWindows XP: Introduction\nWindows 7: Basic or equivalent experience\n\nObjectives\nUpon successful completion of this course\, students will be able to: \n\nExamine the basic database concepts and explore the Microsoft Office Access 2013 environment.  design and build a simple database with related tables\nManage the data in a table.\nQuery a database using different methods.\nDesign forms and generate reports.\n\n\n\nCourse contents\nUnit 1:\n\nGetting started\nDatabase concepts\nExploring the Access environment\nGetting help\n\nUnit 2:\n\nDatabases and tables\nPlanning and designing databases\nExploring tables\nCreating tables\n\nUnit 3:\n\nFields and records\nChanging the design of a table\nFinding and editing records\nOrganizing records\n\nUnit 4:\n\nData entry rules\nSetting field properties\nWorking with input masks\nSetting validation rules\n\nUnit 5:\n\nBasic queries\nCreating and using queries\nModifying query results and queries\nPerforming operations in queries\n\nUnit 6:\n\nUsing forms Creating forms\nUsing Design view\nSorting and filtering records\n\nUnit 7:\n\nWorking with reports\nReports\nModifying and printing reports\n\n\n\n URL: LOCATION:Johannesburg\, ExecuTrain\, 3rd Floor\, One Vdara\, 41 Rivonia Road\, Sandhurst\, Gauteng\, South Africa CATEGORIES:Microsoft Office Courses END:VEVENT END:VCALENDAR