MS Access (2016, 2019, 365) – Level 1

by PMC (Performance Management Consultants) Claim Listing

This two-day course will help you understand how to identify and work with database components; open tables to locate, edit and enter data; create and customize tables; use input masks and data validation techniques.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

PMC (Performance Management Consultants) Logo

img Duration

2 Days

Course Details

This two-day course will help you understand how to identify and work with database components; open tables to locate, edit and enter data; create and customize tables; use input masks and data validation techniques; create table relationships ensuring data integrity; create and customize table forms; work with queries to extract, edit and perform calculations with table data; create and customize reports; import and export data into tables and preview and print data objects.

 

Learning Outcomes:

  • Work with Tables, Forms, Queries and Reports
  • Enter, edit and filter table data
  • Create and set custom options for inputting table data
  • Relate tables to one another using referential integrity
  • Create and customize forms
  • Work with different types of queries
  • Create and print reports
  • Import and export data to Excel and other formats
     

Workshop Topics:

  • The Basics
  • Database Concepts
  • Getting Started
  • Creating a Database
  • Converting Access Files
  • Working with Objects
  • Using Access Help
  • Table Data
  • Table Concepts
  • Viewing Data in a Table
  • Changing the Database Appearance
  • Entering and Editing Data
  • Applying Filters
  • Table Design
  • Creating a Table
  • Changing the Table Design
  • Data Entry
  • Data Entry Concepts
  • Data Formats
  • Input Masks
  • Input Validation
  • Adding Records
  • Relationships
  • Relationships Between Tables
  • Creating a Relationship
  • Referential Integrity
  • Removing a Relationship
  • Printing Relationships
  • Creating and Using Forms
  • Creating a Form Using AutoForm
  • Creating a Form Using the Form Wizard
  • Creating a Form in Design View
  • Opening a Form
  • Changing a Form Design
  • Adding Controls
  • Placing Controls
  • Multiple-Choice Controls
  • Error Checking
  • Queries
  • Using the Query Wizard
  • Creating a Query in Design View
  • Selecting and Sorting in a Query
  • Calculations
  • Action Queries
  • Parameter Queries
  • Reports
  • Creating Reports
  • Using the Report Wizard
  • Previewing Reports
  • Creating Reports in Design View
  • Changing Report Design
  • Control Operations
  • Control Attributes
  • Importing and Exporting Data
  • Importing and Exporting
  • Importing a Text File
  • Importing Data from an Access Database
  • Exporting Data
  • Troubleshooting Importing and Exporting Problems
  • Printing
  • Printing Objects
  • Print Preview
  • Ottawa Branch

    858 Bank Street, Suite 109, Ottawa

Check out more MS Access courses in Canada

Global Knowledge Logo

Microsoft Visio 2016

Learn how to use the core features of Visio 2016 to create and manipulate various business drawings, such as flowcharts, process diagrams, and organizational charts.

by Global Knowledge [Claim Listing ]
ES Computer Training Logo

Microsoft Publisher

All of the necessary learning tools are provided, including class notes, computers, and software. All we require is a meeting room. Our unique training style will ensure no topic is unexplored, no question remains unanswered, and all participants exit the course more knowledgeable than they entered...

by ES Computer Training [Claim Listing ]
Office Instructor Logo

Microsoft Office Specialist

Microsoft Office Specialist (MOS) 2016 provides industry-leading assessments of skills and knowledge through our new project-based testing, giving students and professionals real-world exercises to appraise their understanding of Microsoft Office.

by Office Instructor [Claim Listing ]
Academy of Learning Logo

Microsoft Excel (Level 1)

In this course, students learn to create and manage Excel worksheets and workbook files, enter data, and create basic formulas to perform calculations. They learn to format cell content, view and format work-sheets, and practice preparing, previewing, and printing workbooks.

by Academy of Learning [Claim Listing ]
(BTT) Business And Technical Training College Logo

Microsoft PowerPoint

Organizations use Microsoft PowerPoint to design presentations that include slide shows, animation, sounds, and video. At BTT College, we provide two different levels of Microsoft PowerPoint.

by (BTT) Business And Technical Training College

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