Access 2019: Level 2
Course Code:
No Course Code
Duration:
2 Days
Delivery Mode:
Instructor-led Training (ILT)
Start Date:
Contact Us
End Date:
Contact Us
Fees:
$543.91

This course focuses on the design and construction of an Access database – viewing, navigating, searching and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms and reports. Take Access 2019 – Level 1 to 3 to prepare for the MOS Certification exam for Microsoft Access 2019.

Course Outline

Lesson 1: Improving Table Usability
  • Create Lookups Within a Table
  • Work with Subdatasheets
Lesson 2: Creating Advanced Queries
  • Create Query Joins
  • Create Subqueries
  • Summarize Data
Lesson 3: Improving Form Presentation
  • Apply Conditional Formatting
  • Create Tab Pages with Subforms and Other Controls
Lesson 4: Creating Advanced Reports
  • Apply Advanced Formatting to a Report
  • Add a Calculated Field to a Report
  • Control Pagination and Print Quality
  • Add a Chart to a Report
Lesson 5: Importing and Exporting Table Data
  • Import and Link Data
  • Export Data
  • Create a Mail Merge
Lesson 6: Using Queries to Manage Data
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
Lesson 7: Creating Complex Reports and Forms
  • Create Subreports
  • Create a Navigation Form
  • Show Details in Subforms and Popup Forms
Lesson 8: Creating Access Macros
  • Create a Standalone Macro to Automate Repetitive Tasks
  • Create a Macro to Program a User Interface Component
  • Restrict Records by Using a Condition
  • Create a Data Macro
Lesson 9: Using VBA to Extend Database Capabilities
  • Getting started with VBA
  • Using VBA with Form Controls
Lesson 10: Managing a Database
  • Back Up a Database
  • Manage Performance Issues
  • Document a Database
Lesson 11: Distributing and Securing a Database
  • Split a Database for Multiple-User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Course Fee (inclusive of 9% GST)

$543.91 *Funding not available
Course Prerequisite
Access 2019 – Level 1
Important Notes
None.
Who Should Attend?
To be updated

Why ITEL?

  • Diverse Range of IT Courses

    We offer a diverse range of IT courses tailored to student needs. Our curriculum covers foundational to advanced topics, ensuring comprehensive learning. We stay updated with industry trends to deliver relevant courses.

  • Skilled & Experienced Instructors

    We are proud to have a team of highly skilled and experienced instructors. Our instructors are industry professionals with in-depth knowledge and expertise across various IT domains.

  • Practical & Hands-on Exercises

    Our courses feature hands-on exercises, projects, and simulations to build practical skills. Students gain confidence by applying knowledge to real-world scenarios.

Course Enquiry for Access 2019: Level 2

"*" indicates required fields

I want to find out more about:
Where did you hear of ITEL?*
*Note: If you chose Others, kindly provide more information in the Remarks/Comments/Questions box.
Consent*
Newsletter Subscription
This field is for validation purposes and should be left unchanged.