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
BRAND/TECHNOLOGY: 
TOPICS: 

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

Related Training Courses

Related products

  • End User Application

    Visio – Part 2
    Microsoft Apps
    Intermediate
    Microsoft? Visio? stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures?anything that can be represented by shapes…
    1 Day(s)
    $395.00
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • End User Application

    Word – Part 3
    Microsoft Apps
    Advanced
    Microsoft Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security…
    1 Day(s)
    $295.00
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • End User Application

    Word – Part 2
    Microsoft Apps
    Intermediate
    Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques…
    1 Day(s)
    $295.00
    Virtual Classroom
    Live, Instructor-Led (ILT)

Contact Info

Email address
info@ittrainingclasses.com
Phone number
(813) 425-3300

Our Company

AstraTech was established out of a passion for education and the core belief that knowledge is the ultimate super power. Our mission is to revolutionalize the IT education industry with our wide range of innovative & cost-effective IT certification training courses.