Microsoft Access Private Tutor (Basic To Advanced) VIEW COURSE OUTLINE

Posted Jun 13      Owerri North, Imo State, Nigeria
Post Ad like this for FREE
Private Teacher
IT & Software
IT Certifications
Service Features
Home Lessons
Services Rendering at Client Location

Ad details

Module 1: Access Basics
 Database concepts and terminology
 Starting Access
 Creating a new file
 Trusting a file
 The Quick Access toolbar
 Backstage view
 Exploring ribbons
 Using the Navigation pane
 Getting help
Module 2: Creating a first Database and Using the Tools
 Planning and designing your database
 Creating tables using Application Parts
 Creating tables in layout view with Quick Start
 Creating and editing tables in Design view
 Setting a primary key
 Creating a lookup field
 Creating multi-value fields
 Using calculated fields
Module 3: Setting Up the Data
 Setting field properties
 Setting input masks
 Setting validation rules
Module 4: Building Structure
a. Creating relationship and enforcing referential integrity
b. Viewing subdatasheets
Module 5: Formatting and Appearance
 Entering data into your tables
 Formatting tables
 Finding, sorting and filtering records
Module 6: Forms
 Creating data entry forms
 Using the Form Wizard
 Modifying a form in layout view
 Using Design view
 Setting tab stops
 Adding buttons to a form
 Using navigation forms
Module 7: Queries
 Introduction to queries
 Using the Query Wizard
 Creating a query in Design view with criteria
 Creating wildcard queries
 Creating reusable parameter queries
 Creating yes/no queries
 Creating "and" and "or" queries
 Building calculation queries
 Creating statistical queries
 Using update queries
 Using delete queries
 Creating crosstab queries
Module 8: Reports
 Introduction to reports
 Using the Report Wizard
 Formatting reports in layout view
 Identifying report structure in Design view
 Adding group and sort capabilities to a report
 Adding existing fields from other tables
 Adding totals and subtotals to a report
 Adding conditional formatting and data bars to a report
 Creating multi-table reports
 Creating mailing labels
 Printing reports
Module 9: Putting Data to Work
 PivotTables
 PivotCharts
Module 10: Automating with Macros
 Creating macros
 Attaching macros to objects
 Using data macros
Module 11: Using Other Applications with Access
 Importing Excel and text data
 Exporting data into Excel
 Exporting to PDf
 Exporting into a Word Mail Merge
 Publishing to a web browser in HTML or XML
 Sharing via mail
 Collecting data over email
 Using Package and Sign
 Publishing to SharePoint
 Importing and exporting with SharePoint
Module 12: Advanced Tools in the Database
 Compacting and repairing a database
 Using data analysis tools
 Encrypting a database and setting a password
 Splitting a database
Module 13: Customization
 Customizing the ribbons
 Setting Access options
Module 14: Review and Exercise files
070 xxx

Similar adverts

Show more ads >>>
Last seen 1 week ago
070 xxx
Tell seller that you found ad on
Please read safety tips
  • Do not pay in advance even for the delivery.
  • Please, check the background of the company!
  • DO NOT PAY for ANY certificates, form applications, etc.