Microsoft Access is a great database for small businesses or an excellent tool for data analysis in all businesses. The easy to use interface and feature pack, Microsoft Access is the industry leader in workgroup database software. Our 2 day course is design to teach any students how to setup and maintain a simple Access database.
When this course is over you will feel very comfortable creating a simple Access database by creating tables, forms, quires, reports, macro's, and customizing Access functions. Students will be able to take home their files that was created in class to practice. Also, students are welcome to come back for a free retake of the course, good for up to 6 months after their first course.
This is a perfect course for anyone looking to learn Microsoft Access for the first time or someone looking to learn more features. This is a 100% hands on course where everyone gets his or her own computer to work on.
What students will learn in this Access course?
Others | ||
---|---|---|
Microsoft Learning Solutions Partners | (Non Authorized training) | |
Better Business Bureau Accredited Business. | (Not an Accredited Business. No assurance if they are a real company) | |
Ultra Fast 4/6-Core Desktops with 19'-24' monitors | (old outdated computers) | |
Flexible Schedule (Weekday, Evening, and Weekend) | (Just Weekday classes) | |
Instructor with real world Experience. | (Instructors with no real world Experience) | |
Live instructor-led training. | ||
American owned and operated company. | (Non-American company) | |
A Free retake of the course within 6 months. | (No retakes allowed) | |
Flat tuition. | (Some providers charge for books or for using a credit card to pay) |
This is a live online course. You attend over the internet from you home or office.
Yes you will get a certificate of completion at the end of the class.
Yes the course fee includes a training manual.
Our tuition is much lower than other training providers because we have optimized our business processes to ensure quality training at a reasonable price. As a smaller school with lower overhead we are able to provide a great class and better value to our students.
We only hire the best instructors. All instructors have over 10 years’ experience in the filed they teach and over 5 years of experience teaching.
Choosing a training provider can be tough choice. We all claim to offer the best value, in terms of price and training quality. The Technical Institute of America offers the lowest price and teaches more PowerPoint than any other school.
No, we never cancel a class. If unforeseen circumstances arise such as bad weather, instructor health or family problems and we have to cancel a class, we will offer all students a 100% refund or reschedule to another class.
Lesson 1: Access Environment
Examine Database Concepts
Explore the User Interface
Use an Existing Access Database
Customize the Access Environment
Obtain Help
Lesson 2: Designing a Database
Describe the Relational Database Design Process
Define Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize Data
Designate Primary and Foreign Keys
Determine Table Relationships
Lesson 3: Building a Database
Create a New Database
Create a Table
Manage Tables
Create a Table Relationship
Save a Database as a Previous Version
Lesson 4: Managing Data in a Table
Modify Table Data
Sort Records
Work with Subdatasheets
Lesson 5: Querying a Database
Lesson 5: Filter Records
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
View Data Using an Access Form
Create a Form
Modify the Design of a Form
Lesson 7: Generating Reports
View an Access Report
Create a Report
Add a Custom Calculated Field to a Report
Format the Controls in a Report
Apply an AutoFormat Style to a Report
Prepare a Report for Print
Lesson 8: Creating Flexible Queries
Set Select Query Properties
Create Parameter Queries
Create Action Queries
Lesson 9: Improving Forms
Design a Form Layout
Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add a Command Button to a Form
Create a Subform
Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data in a Form
Lesson 10: Customizing Reports
Organize Report Information
Format the Report
Set Report Control Properties
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report
Include a Chart in a Report
Print Data in Columns
Create a Report Snapshot
Lesson 11: Sharing Data Across Applications
Import Data into Access
Export Data
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document
Lesson 12: Structuring Existing Data
Analyze Tables
Create a Junction Table
Improve Table Structure
Lesson 13: Writing Advanced Queries
Create Subqueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Create a PivotTable and a PivotChart
Lesson 14: Simplifying Tasks with Macros
Create a Macro
Attach a Macro
Lesson 15: Managing Switchboards
Create a Database Switchboard
Modify a Database Switchboard
Set the Startup Options
Lesson 16: Distributing and Securing Databases
Split a Database
Implement Security
Set Passwords
"A very good class. I absolutely came away feeling comfortable with the program."
Helena
"Instructor was extremely knowledgeable and a pleasure to work with!"
Denise
"Instructor was very friendly and thorough. He is very good and helped me tremendously"
Blake