MS Access (Beginner)

by Computers Etc Software Training Claim Listing

Our Access Beginning class is aimed at users who only need to enter data and run queries and reports. We cover a wide variety of techniques for filtering data in many different types of queries.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Computers Etc Software Training Logo

img Duration

Please Enquire

Course Details

Our Access Beginning class is aimed at users who only need to enter data and run queries and reports. We cover a wide variety of techniques for filtering data in many different types of queries.

 

Access Queries:

Create a number of different Queries that will sort and filter data using different criteria such as name, amount, and date. Use multiple criteria (text, numbers, dates) to narrow a search, use wildcards, use parameters, filter data by text, a range of dates or amounts, etc.

  • Create queries based on existing queries/tables, rename queries, and delete queries. Add calculated fields that don't exist in table (i.e. a field that will calculate sales tax).
  • Select Queries (basic queries)
  • Parameter Queries (ask for user input to narrow results)
  • Unmatched Records Queries (records not found in related table)
  • Duplicate Records Queries (find duplicate records)
  • CrossTab Queries (summarize data in columns and rows)
  • Append Queries (add data to a table)
  • Delete Queries (remove data from a table
  • Update Queries (update a large number of records)
  • Make Table Queries (new table based on another table)
  • Summary Queries
  • San Diego Branch

    6920 Miramar Rd - Suite 206, San Diego

Check out more MS Access courses in USA

Training Washington Logo

Microsoft Word (Quickstart)

In this course, you’ll learn the basics of creating, editing, and formatting documents in Word 2013. Discover how to leverage templates to build better documents, collaborate with other team members, create numbered and bulleted lists, and work with tables.

by Training Washington [Claim Listing ]
Sonic Training, Inc. Logo

Microsoft Access Training

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools.

by Sonic Training, Inc. [Claim Listing ]
TechSherpas 365 Logo

Microsoft Office Excel 2016 (Part 2)

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage.

by TechSherpas 365 [Claim Listing ]
Vijay Computer Academy Logo

Excel & Advanced Excel

Our Excel & Advanced Excel course is focused in efficiency. The Advanced Microsoft Excel is designed for the student who wants to move to the next level and focus on core competencies in Excel.

by Vijay Computer Academy [Claim Listing ]
Full Circle Computing Logo

Word Introduction

Learn about the Microsoft ribbon interface, entering and editing text, cut, copy, paste, paragraph spacing, alignment, formats, spellcheck.

by Full Circle Computing [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy