LANTEC Logo
Lantec | Course: Access Basic

Access Level 1

$245.00
1 days
Audience
Prerequisites

Description:

A relational database application such as Microsoft® Office Access® 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 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Outline:

Lesson 1: Getting Started with Access

  • Topic A: Orientation to Microsoft Access
  • Topic B: Create a Simple Access Database
  • Topic C: Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data

  • Topic A: Modify Table Data
  • Topic B: Sort and Filter Records

Lesson 3: Querying a Database

  • Topic A: Create Basic Queries
  • Topic B: Sort and Filter Data in a Query
  • Topic C: Perform Calculations in a Query

Lesson 4: Using Forms

  • Topic A: Create Basic Access Forms
  • Topic B: Work with Data on Access Forms

Lesson 5: Generating Reports

  • Topic A: Create a Report
  • Topic B: Add Controls to a Report
  • Topic C: Enhance the Appearance of a Report
  • Topic D: Prepare a Report for Print
  • Topic E: Organize Report Information
  • Topic F: Format Reports

Scheduled Courses

Feb 21, 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": "2016-09-26T00:00:00", "ExpiryDate": "9999-01-01T01:00:00", "SiteSearchKeywords": [], "Description": "\n

Description:

\n

A relational database application such as Microsoft® Office Access® can help you and your organization collect and manage large amounts of data. Access\n 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\n for an entire department or organization. In this course, you will use Access to manage your data, including creating a new database; constructing\n tables; designing forms and reports; and creating queries to join, filter, and sort data.

\n

Outline:

\n

Lesson 1: Getting Started with Access

\n
    \n
  • Topic A: Orientation to Microsoft Access
  • \n
  • Topic B: Create a Simple Access Database
  • \n
  • Topic C: Get Help and Configure Options in Microsoft Access
  • \n
\n

Lesson 2: Working with Table Data

\n
    \n
  • Topic A: Modify Table Data
  • \n
  • Topic B: Sort and Filter Records
  • \n
\n

Lesson 3: Querying a Database

\n
    \n
  • Topic A: Create Basic Queries
  • \n
  • Topic B: Sort and Filter Data in a Query
  • \n
  • Topic C: Perform Calculations in a Query
  • \n
\n

Lesson 4: Using Forms

\n
    \n
  • Topic A: Create Basic Access Forms
  • \n
  • Topic B: Work with Data on Access Forms
  • \n
\n

Lesson 5: Generating Reports

\n
    \n
  • Topic A: Create a Report
  • \n
  • Topic B: Add Controls to a Report
  • \n
  • Topic C: Enhance the Appearance of a Report
  • \n
  • Topic D: Prepare a Report for Print
  • \n
  • Topic E: Organize Report Information
  • \n
  • Topic F: Format Reports
  • \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": "/_assets/img/Team/091045Data.exe", "CourseFilesTitle": "", "Intro": "A relational database application such as Microsoft® Office Access® 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 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.", "Days": "1", "Prerequisites": "Knowledge of basic computer functions- Windows 7 or Windows 10", "Audience": "This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.", "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": 23707, "Name": "Access Level 1 - VILT - 022125", "Url": "/event/access-level-1-vilt-022125", "Url_List": [ "/event/access-level-1-vilt-022125" ], "UrlSlug": "access-level-1-vilt-022125", "ParentId": 1827, "ParentId_List": [ -1 ], "ParentName": "", "ParentUrl": "", "TemplateName": "", "Module_Alias": "Event", "Module_ID": 1827, "Enabled": true, "ReleaseDate": "2023-12-13T00:00:00", "ExpiryDate": "2025-02-21T17:00:00", "SiteSearchKeywords": [], "Description": "", "Weighting": 0, "DisableForSiteSearch": false, "SKUCode": "ebec0578-0827-4421-a9c1-3cf799dfb4e7", "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-02-21T08:00:00", "EventDateEnd": "2025-02-21T17: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?


Alicia Plumer, Woman's Hospital

"This course was EXCELLENT! I enjoyed this & will definitely use what I learned in my work."