Microsoft

INT1109 - Application and Database Concepts

(ANC-INT1109.AI1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Database fundamentals

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

Tables

  • Module A: Creating tables
  • Module B: Creating fields
  • Module C: Data Validation
  • Module D: Relationships and keys
  • Summary
3

Queries

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

Forms

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

Reports

  • Module A: Creating Reports
  • Module B: Report controls
  • Module C: Formatting reports
  • Summary

1

Database fundamentals

  • Importing a Flat File
  • Creating a Database from a Template
2

Tables

  • Creating a Blank Table
  • Deleting a Table from a Database
  • Creating a Primary Key
  • Adding Records to a Database Table
3

Queries

  • Creating a Select Query
  • Creating an Update Query
  • Sorting a Query
  • Creating a Delete Query
4

Forms

  • Creating and Viewing a Form in Form View
  • Designing a Form
  • Creating a Split Form
5

Reports

  • Creating a Basic Report
  • Creating a New Report and Binding it to a Query
  • Grouping a Report and Adding a Group Summary Calculation

Why Do Learners Love This Course?

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses