Microsoft Access

Microsoft Access фундаментальный уровень

Microsoft Access промежуточный уровень

Microsoft Access расширенный уровень

Microsoft Access эксперт уровень


Microsoft Access фундаментальный уровень

• Getting Started
• Starting Out
• What is Microsoft Access?
• What’s New in Access ?
• Basic Terminology
• Opening Microsoft Access
• Interface Overview
• Closing Microsoft Access
• Step-By-Step
• Skill Sharpener
• Using the Getting Started Window
• Overview of the Window
• Navigating Through the Window
• Creating a Database from a Template
• Creating a Blank Database
• Step-By-Step
• Skill Sharpener
• The Trust Center
• Warnings You May See when Opening a Database
• Enabling Content
• About Digital Signatures
• About Trusted Locations
• Opening the Trust Center
• Assigning a Password to your Database
• Step-By-Step
• Skill Sharpener
• Getting Help
• Opening the Help Screen
• Overview of the Help Screen
• Online Help vs. Offline Help
• Searching for Help
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• The New Interface
• Using the Quick AccessToolbar
• About the Default Buttons
• Adding Buttons
• Removing Buttons
• Customizing the Toolbar
• Step-By-Step
• Skill Sharpener
• Basics of Ribbons
• About Ribbons
• Opening Dialogue Boxes from the Ribbon
• About the Office Menu
• Step-By-Step
• Skill Sharpener
• The Home Ribbon
• Views
• Clipboard
• Font
• Rich Text
• Records
• Sort and Filter
• Find
• Step-By-Step
• Skill Sharpener
• Create Ribbon
• Tables
• Forms
• Reports
• Other
• Step-By-Step
• Skill Sharpener
• External Data Ribbon
• Import
• Export
• Collect and Data
• SharePoint Lists
• Step-By-Step
• Skill Sharpener
• Database Tools Ribbon
• Macro
• Show/Hide
• Analyze
• Move Data
• Database Tools
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Creating a Database
• First Steps
• Planning a Database
• Creating a Database from a Template
• Creating a Blank Database
• Using Database Objects
• Setting Navigation Options
• Step-By-Step
• Skill Sharpener
• About Records
• What is a Record?
• Navigation Tips
• Adding Records
• Editing Records
• Deleting Records
• E-Mailing Records
• Printing Records
• Step-By-Step
• Skill Sharpener
• Creating a Table
• About Tables
• Creating a Table
• Entering Data into a Table
• Formatting a Table
• Step-By-Step
• Skill Sharpener
• Formatting Text
• Using the Zoom Box
• Selecting Data
• Cutting, Copying, and Pasting
• Using the Format Painter
• Using Undo and Redo
• Checking your Spelling
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Doing More with your Database
• Creating Forms
• What is a Form?
• Bound vs. Unbound Controls
• Creating a Form with the Wizard
• Using Design View to Modify Your Form
• Using Forms
• Step-By-Step
• Skill Sharpener
• Creating Queries
• What is a Query?
• Creating a Query with the Wizard
• Using Design View to Modify a Query
• Using Queries
• Step-By-Step
• Skill Sharpener
• Reports
• What is a Report?
• Creating a Report with the Wizard
• Using Design View to Modify a Report
• Using Reports
• Step-By-Step
• Skill Sharpener
• Sorting and Filtering Data
• Using Find and Replace
• Sort Ascending or Descending
• Toggling Filter
• Using Selection Sort
• Using Advanced Sort
• Step-By-Step
• Skill Sharpener
• Viewing Data
• Using the View Menu
• Using the View Icons
• Using the Tabs
• Closing Individual Tabs
• Step-By-Step
• Skill Sharpener
• Printing a Database Object
• Using the Quick Print Icon
• Using the Print Menu
• Using Print Preview
• Using the Print Preview Ribbon
• Printing vs. Exporting
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions


Microsoft Access промежуточный уровень

• Advanced File Tasks
• Using My Computer within Access
• Navigating with My Computer
• Performing Basic Tasks with My Computer
• Changing Views with my Computer
• Using the My Places Toolbar
• Step-By-Step
• Skill Sharpener
• Database Management
• Compact and Repair a Database
• Backing up Your Database
• Editing Database Properties
• Step-By-Step
• Skill Sharpener
• Saving Your Files
• Using the Save As Dialogue
• Using the Save As Menu
• Using File Properties
• Using AutoRecover
• Step-By-Step
• Skill Sharpener
• Exporting Files
• Exporting to PDF or XPS
• Exporting to Word or Excel
• Exporting to Other Destinations
• Using Saved Exports
• Exporting to a CAB File
• Exporting to Older Versions of Access
• Step-By-Step
• Skill Sharpener
• Linking Files
• Linking to an Excel Spreadsheet
• Linking to Another Database
• Linking to a SharePoint Site
• Other Types of Linked Documents
• Creating a Hyperlink
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Working with Tables
• Customizing Tables
• Understanding Field Properties
• Adding a Primary Key to a Table
• Indexing a Field
• Inserting, Deleting, and Moving Fields
• Importing a Table from another Source
• Step-By-Step
• Skill Sharpener
• Formatting Tables
• Formatting Number Fields
• Formatting Text Fields
• Adding Field Descriptions
• Changing Field Data Types
• Adding Captions
• Step-By-Step
• Skill Sharpener
• Controlling Table Data Entry
• Setting a Default Value
• Setting a Required Value
• Creating and Using Input Masks
• Creating and Removing Table Relationships
• Step-By-Step
• Skill Sharpener
• Managing Table Data Entry
• How to Validate Data
• Creating a Lookup Field
• Modifying a Lookup Field
• Creating a Value List
• Modifying a Value List
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Working with Forms
• Basic Form Controls
• Adding a Control
• Using the Control Wizard
• Cutting, Copying, Pasting, and Moving a Control
• Formatting a Control
• Step-By-Step
• Skill Sharpener
• Advanced Form Controls
• Modifying a Control’s Properties
• Changing a Control’s Data Source
• Changing a Control’s Default Value
• Creating a Calculated Control
• Using Form Properties
• Step-By-Step
• Skill Sharpener
• Formatting Your Form
• Formatting Gridlines
• Modifying the Font
• Adding Logos
• Changing the Layout
• Step-By-Step
• Skill Sharpener
• Formatting Controls
• Changing the Color of a Control
• Using Control Properties
• Aligning Controls
• Applying Special Effects
• Step-By-Step
• Skill Sharpener
• Formatting Records
• Modifying Fonts
• Using AutoFormat
• Using the Formatting Ribbon
• Using the Arrange Ribbon
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Working with Reports
• Organizing Report Data
• Adding and Removing Fields
• Using Report Sections
• Changing Section Properties
• Grouping and Sorting in a Report
• Changing Group Properties
• Using Calculated Controls in a Report
• Step-By-Step
• Skill Sharpener
• Formatting Reports
• Formatting Gridlines
• Modifying the Font
• Adding Logos
• Changing the Layout
• Using AutoFormat
• Step-By-Step
• Skill Sharpener
• Common Report Tasks
• Adding a Photo
• Adjusting Page Properties
• Adding Headers and Footers
• Adding Page Numbers
• Using the Label Wizard
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Working with Queries
• Basic Queries
• Review of Queries
• Creating a Query
• Sorting a Query
• Filtering a Query
• Hiding Fields
• Using AND OR Operators
• Use of IIF Functions
• Step-By-Step
• Skill Sharpener
• Multiple Table Queries
• Creating a Multiple Table Query
• Creating a Calculated Field
• Using the Expression Builder
• Using Queries to Summarize
• Step-By-Step
• Skill Sharpener
• Using Advanced Queries
• Creating a Parameter Query
• Using Parameter Queries
• Creating Crosstab Queries
• Using Crosstab Queries
• Using Make-Table Queries
• Step-By-Step
• Skill Sharpener
• Management Queries
• Append Queries
• Delete Queries
• Update Queries
• Exporting Queries
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions


Microsoft Access расширенный уровень

• Advanced Data Management
• Referential Integrity
• Using the Relationships View and Ribbon
• Types of Relationships
• Establishing Referential Integrity
• Enforcing Referential Integrity
• Testing Referential Integrity
• Step-By-Step
• Skill Sharpener
• Table Relationships
• About Join Lines
• Normalizing Tables
• Using Cascade Delete and Cascade Update
• Setting Fields for Indexing
• Using the Index
• Step-By-Step
• Skill Sharpener
• Switchboards
• Using a Switchboard vs. Using the Navigation Pane and Ribbon
• Using the Switchboard Manager
• Creating a Switchboard
• Editing a Switchboard
• Deleting a Switchboard
• Step-By-Step
• Skill Sharpener
• Modal Dialogue Boxes
• Creating a Modal Dialogue Box
• Adding Controls
• Setting Properties
• Formatting your Dialogue Box
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Advanced Form Tasks
• Using Subforms
• Creating a Subform
• Modifying a Subform
• Working with a Subform
• Synchronizing Subform Data with a Main Form
• Displaying a Subform within a Main Form
• Step-By-Step
• Skill Sharpener
• Advanced Form Tasks
• Limiting User Access to a Form
• Creating Check Boxes and Command Buttons
• Creating Event Procedures
• Customizing Error Messages
• Step-By-Step
• Skill Sharpener
• Exporting Your Form
• Sending a Form via E-Mail
• Managing Replies
• Exporting your Form to XML
• Step-By-Step
• Skill Sharpener
• Using Outlook and SharePoint with Access
• Creating an RSS Feed for Outlook
• Importing Contacts from Outlook
• Importing Contacts from a SharePoint Server
• Moving your Database to a SharePoint Server
• Publishing to a Web Server
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Pivoting Data
• Creating a PivotTable
• About PivotTables
• Creating a PivotTable
• More about PivotTable Fields
• Completing your PivotTable
• Step-By-Step
• Skill Sharpener
• Creating a PivotChart
• About PivotCharts
• Creating a PivotChart
• More about PivotChart Fields
• Completing Your PivotChart
• Step-By-Step
• Skill Sharpener
• Using PivotTables and PivotCharts
• Using a PivotTable
• Using a PivotChart
• Editing a PivotTable or a PivotChart
• Common PivotTable and PivotChart Editing Commands
• Creating a PivotTable and PivotChart from the Same Object
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Access and Windows
• Access and Windows
• Recovering Access
• Starting Access on Windows Boot
• Using Office Diagnostics
• Checking for Updates
• Step-By-Step
• Skill Sharpener
• Using the Access Viewer
• What is the Access Viewer?
• Downloading the Viewer
• Using the Viewer
• Step-By-Step
• Skill Sharpener
• An Introduction to SQL
• What is SQL?
• Parts of an SQL Statement
• SQL Keywords
• Adding Where Clauses
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions


Microsoft Access эксперт уровень

• Add-ons to Access
• COM Add-Ins
• What is a COM Add-In?
• Using the Add-Ins Tab
• Opening the Add-In Manager
• Loading Add-Ins
• Using the Trust Center
• Step-By-Step
• Skill Sharpener
• Digital Signatures
• What is a Digital Signature?
• Obtaining a Digital Signature
• Attaching Your Signature to a Database
• Skill Sharpener
• Smart Tags
• What is a Smart Tag?
• Inserting Smart Tags into a Database
• Customizing Smart Tags
• Setting Smart Tag Options
• Step-By-Step
• Skill Sharpener
• Managing Your Database
• Analyzing Performance
• Analyzing Tables
• Viewing Object Dependencies
• Splitting a Database
• Database Replication
• Step-By-Step
• Skill Sharpener
• Customizing Access
• Opening the Options Dialogue
• Overview of the Options Dialogue
• Changing User Information
• Setting Security Options
• Making Access Work Backwards
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Using Scripts in Access
• Macro Basics
• Creating Macros
• Playing Macros
• Macro Security
• Deleting Macros
• Step-By-Step
• Skill Sharpener
• Other Macro Tasks
• Embedding a Macro
• Assigning a Macro to a Keystroke
• Assigning a Macro to an Event
• Assigning a Macro to a Control
• Step-By-Step
• Skill Sharpener
• Visual Basic and Macros
• Opening the Visual Basic Editor
• Adding Code to your Macro
• Adding Comments to VBA Code
• Declaring Variables
• Prompting for User Input
• Using If-Then-Else Statements
• Step-By-Step
• Skill Sharpener
• Macro Groups
• Creating a Macro Group
• Running a Macro Group
• Editing a Macro Group
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• Using Access to Collaborate
• SharePoint Basics
• What is SharePoint?
• System Requirements
• Creating a Workspace
• Accessing a Workspace
• Publishing to a Workspace
• Step-By-Step
• Skill Sharpener
• SharePoint Data
• Using Offline Lists
• Exporting a List
• Restricting Permission for Data Objects
• Skill Sharpener
• Your Personal SharePoint Space
• Public and Private Views
• Shared and Private Documents
• Creating a List
• Creating a Page
• Personalizing your Space
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions
• SQL and Microsoft Access
• Understanding SQL
• What is an SQL Database?
• What is an SQL Statement?
• What is an SQL Convention?
• What is SQL Syntax?
• Linking a Database to an SQL Server
• Step-By-Step
• Skill Sharpener
• Using the SELECT Statement
• Selecting All Data
• Selecting Specific Data
• Selecting Conditional Data
• Using the ORDER BY Statement
• Step-By-Step
• Skill Sharpener
• Using Subqueries
• What is a Subquery?
• Creating a Subquery
• Subqueries with Equality
• Subqueries with Aggregate Functions
• Nested Subqueries and Uses of the IN Keyword
• Step-By-Step
• Skill Sharpener
• Using SQL Joins
• Creating Simple Joins
• Using an Alias
• Sorting Joins
• Creating Outer Joins
• Step-By-Step
• Skill Sharpener
• Case Study
• Review Questions

Связаться с Нами
+1 (514) 868-6262
Имя:
e-mail:
Телефон:
Страна:
Программы:
Вопросы / Комментарии:
CAPTCHA Image

Different Image
www.collegecanada.com          www.collegecanada.com          www.collegecanada.com          www.collegecanada.com/ielts.php          http://collegecanada.com/aca_lan_tesol.php          www.collegecanada.com/tef.php          www.collegecanada.com/tefaq.php
Montreal: 1118 Sainte-Catherine W. #403, Montreal, Quebec, H3B 1H5 Tel: 514 868 6262 Fax: 514 868 0869 info@collegecanada.com
Toronto: 180 Bloor street West suite 1102, Toronto, ON, Canada, M5S 2V6 Tel: 416 926 0540     www.ccet.ca     study@ccet.ca