Access 2019: Level 1 - ITEL
Access 2019: Level 1
ENQUIRE NOW!
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: Getting Started with Access 2019
  • Launch Access and Open Database
  • Use Tables to Store Data
  • Use Queries to Combine, Find, Filter and Sort Data
  • Use Forms to View, Add and Update Data
  • Use Reports to Present Data
  • Get Help and Configure Options in Microsoft Access
Lesson 2: Creating Tables
  • Plan an Access Database
  • Start a New Access Database
  • Create a New Table
  • Establish Table Relationships
Lesson 3: Creating Queries
  • Create Basic Queries
  • Perform Calculations in a Query
  • Sort and Filter Data in a Query
Lesson 4: Creating Forms
  • Start a New Form
  • Enhance a Form
Lesson 5: Creating Reports
  • Start a New Report
  • Enhance Report Layout
Lesson 6: Promoting Quality Data Input
  • Restrict Data Input Through Field Validation
  • Restrict Data Input Through Forms and Record Validation
Lesson 7: Improving Efficiency and Data Integrity
  • Data Normalization
  • Associate Unrelated Tables
  • Enforce Referential Integrity

Course Fee (inclusive of 9% GST)

$543.91 *Funding not available
Course Prerequisite
To ensure success, students should have end-user skills with any current version of Windows, including being able to start programs, switch between program, locate saved files, close programs, and access websites using a web browser. To meet this prerequisite, you can take any one or more of the following Logical Operations courses:
  • Using Microsoft Windows 10
  • Microsoft Windows 10: Transition from Windows 7
Next Step(s) Access 2019 – Level 2  
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 1

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
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

Download Windows Server 2019 Administration (SF) Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Cloud Technology Solutions Architect Associate (SF) Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Security Analysis and Penetration Testing (SF) Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Information Systems Security (SF) [OLL] Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Microsoft Certified: Azure Fundamentals (AZ-900) Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Microsoft Certified Azure Network Engineer Associate (AZ-700) Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Cyber Threat Intelligence Analyst (SF) Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Cyber Forensics Investigator (SF) [OLL] Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Cyber Security Incident Handling and Response (SF) Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Certified Ethical Hacker (CEH) (SF) [OLL] Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Certified Ethical Hacker (CEH) (SF) Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download (SCTP) Advanced Certificate in Cyber Security Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download (SCTP) Higher Certificate in Network Administration Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Strategic Cyber Security Leadership (SF) Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Download Cisco Certified Network Associate (CCNA) (SF) Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Course Listing Download Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List

Cisco Certified Network Associate Download Course Brochure

This field is for validation purposes and should be left unchanged.
Sign Up For Our Mailing List