MS Access

Colorado Computer Training, Ltd.
Fort Collins, Colorado, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Introducing Access
Examining the Projects
Understanding Database Design
Using Database Wizards
Using the Office Assistant
Understanding Tables
Using Design View
Opening, Saving and Closing Tables
Modifying Columns and Rows
Using the Table Wizard
Working with Field Properties
Entering and Importing Data
Importing Data to a New Table
Sorting Data and Deleting Data
Creating and Establishing Relationships
Enforcing Referential Integrity
Printing and Saving Relationships
Using Subdatasheets
Using Forms
Using the Form Wizard
Entering Data in a Form
Working in Design View
Formatting Form Controls
Filtering Data
Sorting Filtered Records
Creating Single-Table Queries
Using the Query Wizard
Creating Multi-Table Queries
Creating Reports and Auto Reports
Using the Report Wizard
Previewing Multiple Pages
Printing Reports
Using the Help Window
Using the Contents Card
Examining/Modifying Tables Design View
Adjusting Data Types
Changing Field Properties
Using Default Values
Looking at the Office Clipboard
Copying and Pasting Data
Understanding the Lookup Wizard
Using the Input Mask Wizard
Using Form Sections
Binding Controls and Data
Using Calculated Controls
Adding Other Controls
Creating Queries
Using the Query Wizard
Adding Tables and Fields
Specifying Criteria
Working with Query Fields
Creating Action Queries
Creating Calculated Fields
Customizing Reports
Using Report Sections
Modifying Report Controls
Changing Format Properties
Adding Controls
Using Calculated Controls
Working with HTML and Hyperlinks
Understanding Access on the Web
Creating Web Documents
Understanding Hyperlinks
Backing up Databases
Compacting and Repairing Databases
Using Name AutoCorrect
Printing Database Objects
Modifying Input Masks
Creating Lookup Fields
Assigning Multiple-filed Primary Keys
Establishing Relationships
Defining Cascade Updates and Deletes
Specifying Join Properties
Creating Forms in Design View
Modifying Control Properties
Customizing Form Properties
Using the Subform Control
Creating Switchboards
Modifying Queries
Creating Totals Queries
Creating Parameter Queries
Creating Action Queries
Modifying Query Properties
Creating Reports in Design View
Modifying Report/Control Properties
Setting Section Properties
Using the Subreport Control
Running Macros
Creating Macros
Starting Setup Options
Understanding the Web
Creating Data Access Pages
Grouping/Sorting Data Access Pages
Creating Hyperlinks
Using the Table Analyzer Wizard
Replacing Databases
Using Database Security
Using the Database Splitter
Using the Linked Table Manager
Converting Databases
Dragging-and-Dropping Data
Exporting Data to Excel
Creating Data Charts
Linking Existing Data
...''

Phone:(970) 222-2535

School Address:

731 Bonita Ave
Fort Collins, CO 80526 USA

Jobs & Resumes: Fort Collins
Houses & Roommates: Fort Collins

Outlook
PowerPoint
FrontPage
Excel
MS Word

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.