ANC-INT1109.AI1
INT1109 - Application and Database Concepts
- Practice in 16 Hands-On Labs — nothing to install
- 5 Interactive Lessons and 21 topics mapped to the official exam objectives
- 49 Practice Test Questions
Self-paced · 1 year access
16 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
5Interactive Lessons
21Topics
16LiveLab
49Practice Test Questions
50Flashcards
50Glossary of terms
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
5 Interactive Lessons · 21 topics01 Database fundamentals 4 topics · 2 LiveLab +
- Module A: Understanding general database terms
- Module B: Relational databases
- Module C: Access interface and objects
- Summary
2 LiveLab in this lesson — see the labs panel →
02 Tables 5 topics · 4 LiveLab +
- Module A: Creating tables
- Module B: Creating fields
- Module C: Data Validation
- Module D: Relationships and keys
- Summary
4 LiveLab in this lesson — see the labs panel →
03 Queries 4 topics · 4 LiveLab +
- Module A: Creating basic queries
- Module B: Modifying queries
- Module C: Using calculated fields
- Summary
4 LiveLab in this lesson — see the labs panel →
04 Forms 4 topics · 3 LiveLab +
- Module A: Creating simple forms
- Module B: Form design
- Module C: Form controls
- Summary
3 LiveLab in this lesson — see the labs panel →
05 Reports 4 topics · 3 LiveLab +
- Module A: Creating Reports
- Module B: Report controls
- Module C: Formatting reports
- Summary
3 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
16 LiveLabs- Importing a Flat File
- Creating a Database from a Template
- Creating a Blank Table
- Deleting a Table from a Database
- Creating a Primary Key
- Adding Records to a Database Table
- Creating a Select Query
- Creating an Update Query
- Sorting a Query
- Creating a Delete Query
- Creating and Viewing a Form in Form View
- Designing a Form
- Creating a Split Form
- Creating a Basic Report
- Creating a New Report and Binding it to a Query
- Grouping a Report and Adding a Group Summary Calculation
Labs run in your browser — nothing to install.
Prepare for INT1109 - Application and Database Concepts
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 16 LiveLab included
- Certificate of completion
No credit card required