Access – Part 2

$590

Upgrade your tech skills with this Microsoft Access, Microsoft Apps 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:

Intermediate

BRAND/TECHNOLOGY:

TOPICS:

End User Application

Access – Part 2 Course Outline

In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users. Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.

Access – Part 1 or equivalent experience.

Provide input validation features to promote the entry of quality data into a database.
Organize a database for efficiency and performance, and to maintain data integrity.
Improve the usability of Access tables.
Create advanced queries to join and summarize data.
Use advanced formatting and controls to improve form presentation.
Use advanced formatting and calculated fields to improve reports.

1 – IMPROVING TABLE USABILITY

Topic A: Create Lookups Within a Table
Topic B: Work with Subdatasheets

2 – CREATING ADVANCED QUERIES

Topic A: Create Query Joins
Topic B: Create Subqueries
Topic C: Summarize Data

3 – IMPROVING FORM PRESENTATION

Topic A: Apply Conditional Formatting
Topic B: Create Tab Pages with Sub forms and Other Controls

4 – CREATING ADVANCED REPORTS

Topic A: Apply Advanced Formatting to a Report
Topic B: Add a Calculated Field to a Report
Topic C: Control Pagination and Print Quality
Topic D: Add a Chart to a Report

5 – IMPORTING AND EXPORTING TABLE DATA

Topic A: Import and Link Data
Topic B: Export Data
Topic C: Create a Mail Merge

6 – USING QUERIES TO MANAGE DATA

Topic A: Create Action Queries
Topic B: Create Unmatched and Duplicate Queries

7 – CREATING COMPLEX REPORTS AND FORMS

Topic A: Create Sub reports
Topic B: Create a Navigation Form
Topic C: Show Details in Sub forms and Popup Forms

8 – CREATING ACCESS MACROS

Topic A: Create a Standalone Macro to Automate Repetitive Tasks
Topic B: Create a Macro to Program a User Interface Component
Topic C: Restrict Records by Using a Condition
Topic D: Create a Data Macro

9 – USING VBA TO EXTEND DATABASE CAPABILITIES

Topic A: Getting Started with VBA
Topic B: Using VBA with Form Controls

10 – MANAGING A DATABASE

Topic A: Back Up a Database
Topic B: Manage Performance Issues
Topic C: Document a Database

11 – DISTRIBUTING AND SECURING A DATABASE

Topic A: Split a Database for Multiple-User Access
Topic B: Implement Security
Topic C: Convert an Access Database to an ACCDE File
Topic D: Package a Database with a Digital Signature

Access – Part 2

Access – Part 2 Course Outline

1 – IMPROVING TABLE USABILITY

2 – CREATING ADVANCED QUERIES

3 – IMPROVING FORM PRESENTATION

4 – CREATING ADVANCED REPORTS

5 – IMPORTING AND EXPORTING TABLE DATA

6 – USING QUERIES TO MANAGE DATA

7 – CREATING COMPLEX REPORTS AND FORMS

8 – CREATING ACCESS MACROS

9 – USING VBA TO EXTEND DATABASE CAPABILITIES

10 – MANAGING A DATABASE

11 – DISTRIBUTING AND SECURING A DATABASE

Word – Part 2

Live, Instructor-Led (ILT)

Visio – Part 2

Live, Instructor-Led (ILT)

Word – Part 1

Live, Instructor-Led (ILT)

Contact Info

Our Company

Access – Part 2

Access – Part 2 Course Outline

1 – IMPROVING TABLE USABILITY

2 – CREATING ADVANCED QUERIES

3 – IMPROVING FORM PRESENTATION

4 – CREATING ADVANCED REPORTS

5 – IMPORTING AND EXPORTING TABLE DATA

6 – USING QUERIES TO MANAGE DATA

7 – CREATING COMPLEX REPORTS AND FORMS

8 – CREATING ACCESS MACROS

9 – USING VBA TO EXTEND DATABASE CAPABILITIES

10 – MANAGING A DATABASE

11 – DISTRIBUTING AND SECURING A DATABASE

Related End User Application Training Courses

Related products

Word – Part 2

Live, Instructor-Led (ILT)

Visio – Part 2

Live, Instructor-Led (ILT)

Word – Part 1

Live, Instructor-Led (ILT)

Contact Info

Our Company