Download Now
Sold by teachucomp on Tradebit
The world's largest download marketplace
2,919,295 satisfied buyers
Shopper Award

Microsoft Access Training Tutorial V. 2013, 2010, 2007

Course Title: Mastering Access Made Easy
Versions Covered: 2013, 2010 & 2007
Hours of Content: 6
Video Lessons: 111
Manuals: 3 (Introductory, Intermediate & Advanced)

Learn Microsoft Access with this comprehensive course from TeachUcomp, Inc. Mastering Access Made Easy features 111 video lessons with over 6 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises. You will learn all about relational databases, advanced queries, creating forms, reporting, macros and much more.

Whether you are completely new to Access or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply launch the easy-to-use interface, click to start a video lesson or open one of the manuals and you’re on your way to mastering Access.

Topics Covered:

Getting Acquainted with Access
1. Creating a New Database - 2013
2. Creating a New Database - 2010:2007
3. Overview of a Database
4. The Access Interface
5. Touch Mode
6. Viewing Database Objects in the Navigation Bar
7. Opening and Closing Databases - 2013
8. Opening and Closing Databases - 2010:2007

Creating Relational Database Tables
1. The Flat File Method of Data Storage
2. The Relational Model of Data Storage
3. Tips for Creating a Relational Database
4. Creating Relational Database Tables
5. Assigning a Primary Key to a Table

Using Tables
1. Using Datasheet View
2. Navigating in Datasheet View
3. Adding Records in Database View
4. Editing and Deleting Records in Datasheet View
5. Inserting New Fields
6. Renaming Fields
7. Deleting Fields

Field Properties
1. Setting Field Properties
2. The Field Size Property
3. The Format Property for Date/Time Fields
4. The Format Property for Logical Fields
5. Setting Default Values for Fields
6. Setting Input Masks
7. Setting Up Validation Rules and Responses
8. Requiring Field Input
9. Allowing Zero Length Entries

Joining Tables in a Database
1. The Relationships Window
2. Enforcing Referential Integrity
3. Creating Lookup Fields

Indexing Tables
1. Indexes
2. Creating Indexes
3. Deleting Indexes

1. Using the Simple Query Wizard
2. Designing Queries
3. Joining Tables in a Query
4. Adding Criteria to the QBE Grid
5. Running A Query
6. How is Using the QBE Grid Writing SQL Code?
7. Sorting Query Results
8. Hiding Fields in a Query
9. Using Comparison Operators
10. Using AND and OR Conditions

Advanced Queries
1. Using the BETWEEN...AND Condition
2. Using Wildcard Characters in Criteria
3. Creating a Calculated Field
4. Creating Top Value Queries
5. Function Queries
6. Parameter Queries

Advanced Query Types
1. Make-Table Queries
2. Update Queries
3. Append Queries
4. Delete Queries
5. Crosstab Queries
6. The Find Duplicates Query
7. The Find Unmatched Query

Creating Forms
1. Forms Overview
2. The Form Wizard
3. Creating AutoForms
4. Using Forms
5. Form and Report Layout View
6. Form and Report Design View
7. Viewing the Ruler and Gridlines
8. The Snap to Grid Feature
9. Creating a Form in Design View

Form & Report Controls
1. Selecting Controls
2. Deleting Controls
3. Moving and Resizing Controls
4. Sizing Controls To Fit
5. Nudging Controls
6. Aligning, Spacing and Sizing Controls
7. Formatting Controls
8. Viewing Control Properties

Using Controls
1. The Controls Group
2. Adding Label Controls
3. Adding Logos and Image Controls
4. Adding Line and Rectangle Controls
5. Adding Combo Box Controls
6. Adding List Box Controls
7. Setting Tab Order

1. Creating Subforms
2. Using the Subform/Subreport Control

1. Using the Report Wizard
2. Using Basic Reports
3. Creating a Report in Design View
4. Sorting and Grouping Data in Reports
5. Creating Calculated Fields

1. Creating Subreports

Charting Data
1. Using Charts

Macros in Access 2007
1. Creating and Using Macros
2. Macro Actions
3. Assigning Macros to a Command Button
4. Conditional Macros and Option Groups
5. Using Group Names in Macros
6. Creating Autoexec Macros

Macros in Access 2013:2010
1. Creating a Standalone Macro
2. Assigning Macros to a Command Button
3. Using Program Flow with Macros
4. Creating Autoexec Macros
5. Creating Data Macros

Switchboard and Navigation Forms
1. Creating a Switchboard Form
2. Creating a Navigation Form - 2013:2010
3. Controlling Startup Behavior - 2007
4. Controlling Startup Behavior - 2013:2010

Advanced Features
1. Getting External Data
2. Exporting Data
3. Setting a Database Password - 2007
4. Setting a Database Password - 2013:2010
5. Using Help
File Data

This file is sold by teachucomp, an independent seller on Tradebit.

File Size 993 megabytes
File Type ZIP
Our Reviews
© Tradebit 2004-2020
All files are property of their respective owners
Questions about this file? Contact teachucomp
DMCA/Copyright or marketplace issues? Contact Tradebit