Live Webinar - Cybersecurity Career Advancement & Protecting Organizations

closeClose

Microsoft Access 2013 Level 1 - Data Entry and Reports

Course Details
Code: 7782
Tuition (USD): $275.00 $247.50 • Classroom (1 day)

This course with hands on labs provides you with the knowledge and skills to become familiar with introductory features and functionality relating to entering data, and managing queries and reports using Microsoft Access 2013.

This course includes access to our exclusive Microsoft Office Online Support Program, enabling you to build your skills and expertise after class. The program provides 24x7 access for 60 days to online mentoring via chat from Microsoft Office experts.

Certification:

This course is one of four recommended to help you prepare for Microsoft Exam 77-424: Access 2013, which is required for the Microsoft Office Specialist (MOS): Microsoft Office Access 2013 certification.

Skills Gained

  • Identify the components of a database, and work with those components
  • Open a table, find information stored there, and enter data
  • Create several query types, edit and run queries, and use action and calculation queries
  • Create several report types, enhance reports, and print preview reports
  • Preview and print database objects, and change the page setup options

Who Can Benefit

This course is intended for participants who are new to Microsoft Access 2013

Course Details

1. The Basics

  • Database Concepts
  • Getting Started
  • Creating a Database
  • Converting Access 2013 Files
  • Working with Objects
  • Using Access Help

2. Table Data

  • Table Concepts
  • Viewing Data in a Table
  • Changing the Datasheet Appearance
  • Entering and Editing Data
  • Applying Filters

3. Queries

  • Using the Query Wizard
  • Creating a Query in Design View
  • Selecting and Sorting in a Query
  • Calculations
  • Action Queries
  • Parameter Queries

4. Reports

  • Creating Reports
  • Using the Report Wizard
  • Previewing Reports
  • Creating Reports in Design View
  • Changing Report Design
  • Control Operations
  • Control Attributes

5. Printing

  • Printing Objects
  • Print Preview

6. Customizing the Access Environment

  • The Access Options Dialog Box