Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
edupls_header
certification
Filter by Categories

Access – Part 1

$590

Upgrade your tech skills with this , training course. Launch your career to the stars with AstraTech IT Certification Training!

Please select a Learning Method below to get started:

  • Microsoft Access
  • Microsoft Apps

Course Highlights

ILT DURATION: 2 Day(s)
SKILL LEVEL: 
  • Beginner

Access – Part 1 Course Outline

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.

0
  • Basic computer literacy
  • Basic PC operating system navigation skills
  • Basic Internet usage skills
  • Basic IP address knowledge
  • Navigate within the Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

1 – GETTING STARTED WITH ACCESS

  • Topic A: Launch Access and Open a Database
  • Topic B: Use Tables to Store Data
  • Topic C: Use Queries to Combine, Find, Filter, and Sort Data
  • Topic D: Use Forms to View, Add, and Update Data
  • Topic E: Use Reports to Present Data
  • Topic F: Get Help and Configure Options in Microsoft Access

2 – CREATING TABLES

  • Topic A: Plan an Access Database
  • Topic B: Start a New Access Database
  • Topic C: Create a New Table
  • Topic D: Establish Table Relationships

3 – CREATING QUERIES

  • Topic A: Create Basic Queries
  • Topic B: Perform Calculations in a Query
  • Topic C: Sort and Filter Data in a Query

4 – CREATING FORMS

  • Topic A: Start a New Form
  • Topic B: Enhance a Form

5 – CREATING REPORTS

  • Topic A: Start a New Report
  • Topic B: Enhance Report Layout

6 – PROMOTING QUALITY DATA INPUT

  • Topic A: Restrict Data Input Through Field Validation
  • Topic B: Restrict Data Input Through Forms and Record Validation

7 – IMPROVING EFFICIENCY AND DATA INTEGRITY

  • Topic A: Data Normalization
  • Topic B: Associate Unrelated Tables
  • Topic C: Enforce Referential Integrity