2031 – Microsoft Access 2013 Core EssentialsDownload Course Outline
Title: Microsoft Access 2013 Core Essentials 2031; 2 Day; Instructor-led
Description: This two-day introduction course to access covers the skills that students will need to make the most of Microsoft Access 2013. The course begins with the basics and progresses through several modules which cover databases, tables and records, forms, reports, queries and much more.
At Course Completion:
Audience & Prerequisites:
Course Outline Details: Module 1: The Basics Lessons Create and save a database Open an existing database Database terminology Module 2: Your First Database Lessons Search for objects Open various database objects Manage views Manage objects Data relationships Module 3: Working with Tables Lessons Tables and records Create a table Add and edit database records Search and browse records Delete and print records Module 4: Formatting Tables Lessons Delving deeper into tables Select data Apply text formatting and fill color and apply gridlines Perform a spell check Module 5: Creating Forms Lessons Create forms from an object Creating forms using the wizard Create forms from scratch and how to use form views Use the Format Painter Add fields to a form Add controls and images to a form Module 6: Creating Reports Lessons Create reports Use report views and print reports Group and sort data in reports Adding controls, images, logos, page numbers, headers, and footers to reports Module 7: Creating Basic Queries Lessons Create a query Run a query Sort and filter a query Use and apply query views Module 8: Creating Advanced Queries Lessons Use parameter queries, multiple table queries and crosstab queries Action queries will be learned: make-table queries, append queries, delete queries, and update queries Module 9: Managing Your Database Lessons Compact and repair a database Encrypt a database using a password Back up a database Export a database and database objects
Start Date: 05/06/2019
End Date: 05/07/2019