Logical Imagination offers Microsoft Access training via our live, instructor-led online classes or as onsite classes at your location.

Microsoft Access is now much more than a way to create desktop databases. It’s an easy-to-use tool for quickly creating browser-based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure and scalable than ever, and you can easily share your applications with colleagues.*

*Product details provided by Microsoft. Check out more product details at Microsoft.com.

  • Access 2013 / 2016 - Introduction

    $285.00
    Access 2013 / 2016 - Introduction Logo
    This course covers the basic skills and concepts students need to use Microsoft Access 2013 or 2016 productively and efficiently. After an introduction to the Access environment, students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules. They will learn how to create basic queries and how to work with forms and reports. This course will help students prepare. . .

    Access 2013 / 2016 - Introduction

    • Getting started
      • Database Concepts
      • Exploring the Access environment
    • Databases and tables
      • Planning and designing databases
      • Exploring tables
      • Creating tables
    • Fields and records
      • Changing the design of a table
      • Finding and editing records
      • Organizing records
    • Data Entry rules
      • Setting field properties
      • Working with input masks
      • Setting validation rules
    • Basic queries
      • Creating and using queries
      • Modifying query results and queries
      • Performing operations in queries
    • Using forms
      • Creating forms
      • Using Design view
      • Sorting and filtering records
    • Working with reports
      • Creating reports
      • Modifying and printing reports
  • Access 2013 / 2016 - Intermediate

    $285.00
    Access 2013 / 2016 - Intermediate Logo
    This course builds on the skills and concepts taught in the Introduction course. Students will learn relational database concepts and techniques, advanced queries, advanced form and report building, and how to create charts. This course will help students prepare for the Microsoft Office Specialist exam for Access 2016. For comprehensive certification training, students should complete the Introduction, Intermediate, and Advanced courses for . . .

    Access 2013 / 2016 - Intermediate

    • Relational databases
      • Database normalization
      • Table relationships
      • Referential integrity
    • Related tables
      • Creating lookup fields
      • Modifying lookup fields
      • Subdatasheets
    • Complex queries
      • Joining tables in queries
      • Using calculated fields
      • Summarizing and grouping values
    • Advanced form design
      • Adding unbound controls
      • Graphics
      • Adding calculated values
      • Adding combo boxes
      • Advanced form types
    • Reports and printing
      • Report formatting
      • Calculated values and subreports
      • Printing
      • Label printing
    • Charts
      • Charts in forms
      • Charts in reports
  • Access 2013 / 2016 - Advanced

    $285.00
    Access 2013 / 2016 - Advanced Logo
    This course builds on the skills and concepts taught in the Introduction and Intermediate courses. Students will learn advanced querying techniques, how to work with macros, how to import, export and link objects, and how to utilize advanced database management techniques. This course will help students prepare for the Microsoft Office Specialist exam for Access 2016. For comprehensive certification training, students should complete the Introduction,. . .

    Access 2013 / 2016 - Advanced

    • Querying with SQL
      • SQL and Access
      • Writing SQL statements
      • Attaching SQL queries to controls
    • Advanced queries
      • Creating crosstab queries
      • Creating parameter queries
      • Using action queries
    • Macros
      • Creating, running, and modifying macros
      • Attaching macros to the events of database objects
    • Advanced macros
      • Creating macros to provide user interaction
      • Creating macros that require user input
      • Creating AutoKeys and AutoExec macros
      • Creating macros for data transfer
    • Importing, exporting, and linking objects
      • Importing objects
      • Exporting objects
      • Working with XML documents
      • Linking Access objects
      • Using hyperlink fields
    • Database management
      • Optimizing resources
      • Protecting databases
      • Setting options and properties