LANTEC Logo
Lantec | Course: Access Basic

Access Level 1

$245.00
1 days
Audience
Prerequisites

Description:

This course provides the basic concepts and skills to start using Microsoft Access: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports.

Outline:

Chapter 1: Database Fundamentals

  • Module A: Understanding general database terms
  • Module B: Relational databases
  • Module C: Access interface and objects

Chapter 2: Tables

  • Module A: Creating tables
  • Module B: Creating fields
  • Module C: Data validation
  • Module D: Relationships and keys

Chapter 3: Queries

  • Module A: Creating basic queries
  • Module B: Modifying queries
  • Module C: Using calculated fields

Chapter 4: Forms

  • Module A: Creating simple forms
  • Module B: Form design
  • Module C: Form controls

Chapter 5: Reports

  • Module A: Creating reports
  • Module B: Report controls

Scheduled Courses

May 09, 2025
{
  "Params": {
    "source": "Event",
    "layout": "List for Course Detail Page",
    "filterby": "Course",
    "filtervalue": "9160",
    "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": 9160, "Name": "Access Level 1", "Url": "/course/access-level-1", "Url_List": [ "/course/access-level-1" ], "UrlSlug": "access-level-1", "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 basic concepts and skills to start using Microsoft Access: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports.

Outline:

\n

Chapter 1: Database Fundamentals

  • Module A: Understanding general database terms
  • Module B: Relational databases
  • Module C: Access interface and objects

Chapter 2: Tables

  • Module A: Creating tables
  • Module B: Creating fields
  • Module C: Data validation
  • Module D: Relationships and keys

Chapter 3: Queries

  • Module A: Creating basic queries
  • Module B: Modifying queries
  • Module C: Using calculated fields

Chapter 4: Forms

  • Module A: Creating simple forms
  • Module B: Form design
  • Module C: Form controls

Chapter 5: Reports

  • Module A: Creating reports
  • Module B: Report controls
    \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 1", "CourseFiles": "/Access Level 1 Exercise Files.zip", "CourseFilesTitle": "", "Intro": "This course provides the basic concepts and skills to start using Microsoft Access: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports. ", "Days": "1", "Prerequisites": "The course assumes you know how to use a computer, and that you are familiar with Microsoft Windows. It does not assume that you have used a different version of Access or another database system before.", "Audience": "You will benefit most from this course if you want to gain a basic understanding of Access and be able to design and create simple tables, queries, forms, and reports.", "Cost": "$245.00", "GoogleAnalyticsCode": "", "Popular": false, "Photo": "", "Disclaimer": "", "ShowPageForSearchEngine": true, "MetaTitle": "Lantec | Course: Access Basic", "SEOTitle": "Lantec | Course: Access Basic", "MetaDescription": "A relational database application such as Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.\n\n", "CanonicalLink": "", "SocialMetaTags": "", "SeoPriority": 0.0, "EnableAMP": false, "AMPContent": "", "OpenGraphProperties": { "title": "", "type": "", "url": "", "locale": "", "image": "" }, "ExternalId": 9160, "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": 26258, "Name": "Access Level 1 - 05092025 - vILT", "Url": "/event/access-level-1-05092025", "Url_List": [ "/event/access-level-1-05092025" ], "UrlSlug": "access-level-1-05092025", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2025-01-16T00:00:00", "ExpiryDate": "2025-05-09T17:00:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "f2656662-2bb5-47d9-9725-910ace1f2405", "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-05-09T08:00:00", "EventDateEnd": "2025-05-09T17: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": 9160, "Course_Name": "Access Level 1", "Course_Url": "/course/access-level-1", "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?


Erica Fontenette, Arc of Acadiana

"The instructor was very knowledgable and thorough. He made it very easy to understand and interact."