Microsoft

INT1109 - Application and Database Concepts

(ANC-INT1109.AI1)
Lessons
Lab
TestPrep

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

Related Courses

All Course