Global eTraining Logo

Global eTraining – GeT Everything Library
including Microsoft Access

Microsoft Access Complete Guide provides training on all the essential functions of Access, covering introductory through advanced topics.

Contact Us Buy Online

Microsoft Access: The Complete Guide

Sign up for Global eTraining’s “Get Everything” library and get access to all their courses including Microsoft Access.

Microsoft Access Complete Guide provides training on all the essential functions of Access. This course covers introductory through advanced topics. In Unit 1 introduce students to the concept of a database and the four database objects: tables, forms, queries, and reports. Students design a database, use forms, build queries and create reports. In Unit 2 cover advanced topics related to the four objects, maintaining a database, and integrating Access with Word, Excel and Outlook. In Unit 3, students are introduced to complex forms, calculated controls, complex reports, sub-reports, database customization, splitting databases, customizing the user interface, and more.

The Microsoft® Office Complete Guide series has been designed from the ground up for Global eTraining’s world-leading, online, on-demand GeT Interactive eTraining platform. With text from internationally recognized content matter experts, professional narration, video demonstrations by leading instructors, and Let Me Try exercises for users to get practical experience with the software, using downloadable datasets aligned with the presentation content.

To get the most out of this course, we strongly recommend you review every topic .within the course and take advantage of the different tools and activities to help to ensure you retain the important information within. We also encourage you to take all the progress tests to ensure you have retained the knowledge, and most importantly practice with the hundreds of real-world, Let Me Try examples.

Course Outline:

  1. Exploring Access
    • Defining Access Databases
    • Exploring the Access Environment
    • Introducing Objects & Exiting
  2. Designing a Database and Creating Tables
    • Designing & Normalizing
    • Linking Tables
    • Creating Tables
    • Retrieving Data
  3. Working with Forms
    • Form Design & Creation
    • Modifying Form Controls
    • Modifying Form Layout
    • Printing & Using Help
  4. Querying a Database
    • Creating Select Queries
    • Setting Query Criteria
    • Sorting & Performing Calculations
    • Creating Special Types of Queries
  5. Using Reports to Display Information
    • Designing Reports
    • Modifying Reports
    • Exploring Other Report Tools
    • Printing Reports
  6. Refining Table Design
    • Creating and Modifying Relationships
    • Modifying Table Structures
    • Formatting A Table Datasheet Layout
    • Setting Field Properties
    • Setting Lookup Fields with the Lookup Wizard
  7. Customizing Input Forms
    • Creating a Main Form with a Subform
    • Adding Calculations to Forms
    • Setting Properties to Assist and Control Data Entry
  8. Creating Complex Queries
    • Creating and Running Action Queries
    • Identifying Advanced Query Features
    • Creating and Running Parameter Queries
    • Creating a Calculated Field in a Query
  9. Customizing Reports
    • Customizing Reports
    • Adding a Subreport to a Main Report
    • Creating a Report from a Subreport
    • Numbering Items in a Report
    • Creating Calculated Controls on a Subreport
    • Setting Page Breaks and Customizing Controls
    • Analyzing Report Performance
  10. Customizing The Database Interface and Startup Options
    • Set Access Options
    • Splitting a Database
    • Customizing the Database Interface
  11. Importing and Exporting Data Using Word, Excel and HTML
    • Attaching Files to Database Records
    • Integrating Access with Word
    • Integrating Access with Excel
    • Displaying Access Data on the Web
  12. Maintaining a Database
    • Improving and Maintaining a Database
    • Creating Macros to Improve Efficiency
    • Managing Database Objects
    • Analyzing and Documenting Databases
    • Compacting and Repairing a Database
    • Setting Database Security
    • Exploring Microsoft Cloud Storage
Global eTraining Logo

Next Steps

If you have any questions about this course or any other Global eTraining offering please contact us.