Microsoft Access Intermediate

TrainACE's Microsoft Access 2013 Intermediate training course will expand your understanding of Access 2013 and enable you to create, maintain and query small to medium sized relational databases. This Instructor-Led Training course builds on concepts learned in our Microsoft Access 2013 Basic training to give the student a well-rounded understanding of database concepts and Microsoft Access in particular. In our Microsoft Access 2013 Intermediate training you will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms, and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.   Enroll today, by selecting a class' date, to the right   Got Questions? For more information about your specific needs call us at (301) 220 2802 or complete the form below:   Learn More About Microsoft Access 2013 Intermediate Training Training   Jump to: Class Schedule Why Take Microsoft Access 2013 Intermediate Training Training? Prerequisites Exam and Certification Requirements Skills and Concepts Class Schedule   Location Start End Days & Times Get your Microsoft Office training in our convenient IT training centers in Maryland or Virginia. Why Take Microsoft Access 2013 Intermediate Training training in Maryland?   Our Microsoft Access 2013 Intermediate training will expand your understanding of the basic principles and functions of Microsoft Access 2013 and give you a firmer footing in the implementation and use of relational databases. In this Instructor-Led Course (ILT) you will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms, and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms, and subreports, navigation forms, and calculated fields. Signup today for our convenient Microsoft Access 2013 Basic Bootcamp! Enroll Today!   What you need to know before taking Microsoft Access 2013 Intermediate training   Although there are no strict prerequisites for this course the typical student will have a basic understanding of Microsoft Access and database concepts. The course is ideal for anyone looking to maintain, create and query office databases, or who are starting out in a database administration career. Exam and Certification Requirements:   Microsoft Access 2013 Intermediate is one of several MS Office classes that will prepare you for the Microsoft Office Specialist (MOS) certification. What You Will Learn in Microsoft Access 2013 Intermediate training Unit 1: Relational databases Topic A: Database normalization Topic B: Table relationships Topic C: Referential integrity Unit 2: Related tables Topic A: Creating lookup fields Topic B: Modifying lookup fields Topic C: Subdatasheets Unit 3: Complex queries Topic A: Joining tables in queries Topic B: Using calculated fields Topic C: Summarizing and grouping values Unit 4: Advanced form design Topic A: Adding unbound controls Topic B: Graphics Topic C: Adding calculated values Topic D: Adding combo boxes Topic E: Advanced form types Unit 5: Reports and printing Topic A: Report formatting Topic B: Calculated values and subreports Topic C: Printing Topic D: Label printing Unit 6: Charts Topic A: Charts in forms Topic B: Charts in reports   Enroll Today!