LANTEC Logo
Lantec | Course: Access Intermediate

Access Level 2

$245.00
1 days
Audience
Prerequisites

Description:

This course provides the concepts and skills for the advanced use of Microsoft Access. This includes how to create advanced queries, forms, and reports, how to create macros, and how to manage your databases.

Outline:

Chapter 1: Advanced Queries

  • Module A: Grouping and summarizing
  • Module B: Updating, deleting, and relationships
  • Module C: Indexing for performance

Chapter 2: Advanced forms

  • Module A: Subforms 
  • Module B: Advanced control types
  • Module C: Specialized form types

Chapter 3: Advanced reports

  • Module A: Subreports 
  • Module B: Advanced grouping
  • Module C: Advanced formatting 

Chapter 4: Macros

  • Module A: Creating basic macros
  • Module B: Using variables
  • Module C: Troubleshooting macros

Chapter 5: Database Management

  • Module A: Compact & Repair
  • Module B: Restoring a database
  • Module C: Other maintenance tasks

Scheduled Courses

Jun 05, 2025
{
  "Params": {
    "source": "Event",
    "layout": "List for Course Detail Page",
    "filterby": "Course",
    "filtervalue": "9161",
    "sortby": "EventDateStart",
    "sortorder": "ASC",
    "limit": "9999",
    "enablepagination": "false",
    "emptymessage": "

This course isn't currently on the schedule, but we can add it. Just let us know.

", "object": "collection", "type": "module" }, "Pagination": { "CurrentPage": 0, "ItemsPerPage": 0, "NumberOfPages": 0, "TotalItemsCount": 0 }, "Parent": { "Id": 9161, "Name": "Access Level 2", "Url": "/course/access-level-2", "Url_List": [ "/course/access-level-2" ], "UrlSlug": "access-level-2", "ParentId": 5934, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Course", "Module_ID": 5934, "Enabled": true, "ReleaseDate": "2025-03-03T14:14:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "

Description:

\n

This course provides the concepts and skills for the advanced use of Microsoft Access. This includes how to create advanced queries, forms, and reports, how to create macros, and how to manage your databases.

Outline:

\n

Chapter 1: Advanced Queries

  • Module A: Grouping and summarizing
  • Module B: Updating, deleting, and relationships
  • Module C: Indexing for performance

Chapter 2: Advanced forms

  • Module A: Subforms 
  • Module B: Advanced control types
  • Module C: Specialized form types

Chapter 3: Advanced reports

  • Module A: Subreports 
  • Module B: Advanced grouping
  • Module C: Advanced formatting 

Chapter 4: Macros

  • Module A: Creating basic macros
  • Module B: Using variables
  • Module C: Troubleshooting macros

Chapter 5: Database Management

  • Module A: Compact & Repair
  • Module B: Restoring a database
  • Module C: Other maintenance tasks
    \n
", "Weighting": 0, "DisableForSiteSearch": false, "CreatedByMemberId": "0", "ItemCategories": [ "Courses", "Courses/Courses-Application", "Courses/Courses-Application/Microsoft" ], "ItemCategoryIdList": [ 8587, 8588, 8606 ], "ItemTags": [ "Microsoft" ], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "CourseTitle": "Access Level 2", "CourseFiles": "/Access Level 2 Exercise Files.zip", "CourseFilesTitle": "", "Intro": "This course provides the concepts and skills for the advanced use of Microsoft Access. This includes how to create advanced queries, forms, and reports, how to create macros, and how to manage your databases. ", "Days": "1", "Prerequisites": "The course assumes you have completed Access Level 1, or you have equivalent skills in using Access.", "Audience": "This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.", "Cost": "$245.00", "GoogleAnalyticsCode": "", "Popular": false, "Photo": "", "Disclaimer": "", "ShowPageForSearchEngine": true, "MetaTitle": "Lantec | Course: Access Intermediate", "SEOTitle": "Lantec | Course: Access Intermediate", "MetaDescription": "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 2016 will result in a robust, functional database for your users.", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.0, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": "", "type": "", "url": "", "locale": "", "image": "" }, "ExternalId": 9161, "Params": { "type": "snippet", "alias": "_template_header", "name": "_Template - Header", "content": "
\r\n
\r\n
\r\n
\r\n
\r\n
{% component type: \"menu\", alias: \"social_menu\", layoutGroup: \"Default\" %}
\r\n
\r\n
\r\n
\r\n {% component type: \"menu\", alias: \"utility_menu\", layoutGroup: \"Default\" %} \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \"LANTEC\r\n
\r\n
\r\n
\r\n
\r\n {% component type:\"menu\", alias: \"main_menu\", layoutGroup: \"Default\" %}\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\"LANTEC
\r\n \r\n
\r\n
\r\n \r\n {% assign brcr = \"BACK\" %}\r\n \r\n\t
\r\n\t BACK\r\n\t
\r\n
", "enabled": true } }, "Items": [ { "Id": 26260, "Name": "Access Level 2 - 06052025 - vILT", "Url": "/event/access-level-2-06052025", "Url_List": [ "/event/access-level-2-06052025" ], "UrlSlug": "access-level-2-06052025", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2025-01-16T00:00:00", "ExpiryDate": "2025-06-05T17:00:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "101a4007-691f-4421-bdd1-b0e465a1d705", "Price": 249.9000, "PriceHtml": "249.90", "priceWithTax": 249.90, "priceWithTaxHtml": "249.90", "RecommendedPrice": 245.0000, "RecommendedPriceHtml": "245.00", "RecommendedPriceWithTax": 245.00, "RecommendedPriceWithTaxHtml": "245.00", "HideWhenFull": false, "AllowMultipleSubscriptionPerEmail": false, "Capacity": 20, "Allocation": 0, "EventDateStart": "2025-06-05T08:00:00", "EventDateEnd": "2025-06-05T17:00:00", "taxRate": 0.0, "VolumeDiscount": [ { "Price": 249.9000, "Quantity": 0 } ], "CreatedByMemberId": "0", "ItemCategories": [], "ItemCategoryIdList": [], "ItemTags": [], "Author": 0, "Author_Name": "", "Author_Url": "", "Item_Rating": 0, "Course": 9161, "Course_Name": "Access Level 2", "Course_Url": "/course/access-level-2", "Location": "vILT", "ShowPageForSearchEngine": true, "MetaTitle": "", "SEOTitle": "", "MetaDescription": "", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.5, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": null, "type": null, "url": null, "locale": null, "image": null }, "ExternalId": 0, "Params": {} } ] }

Need to Request This Course On a Different Day?

LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.
Want to schedule it?


Ron Claude, CETCO Energy Services

"Great class. Had a blast learned a lot. Glad I decided to come."(Excel 2013 Basic)