In this course, students will learn how to use Access 2013 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data

Lessons

Lesson 1: Getting Started with Access

  • Orientation to Microsoft Access 
  • Create a Simple Access Database 
  • Get Help in Microsoft Access

Lesson 2: Working with Table Data

  • Modify Table Data 
  • Sort and Filter Records 
  • Create Lookups 

Lesson 3: Querying a Database

  • Join Data from Different Tables in a Query 
  • Sort and Filter Data in a Query 
  • Perform Calculations in a Query

Lesson 4: Creating Advanced Queries

  • Create Parameter Queries 
  • Create Action Queries 
  • Create Unmatched and Duplicate Queries 
  • Summarize Data

Lesson 5: Generating Reports

  • Create a Report 
  • Add Controls to a Report 
  • Enhance the Appearance of a Report 
  • Prepare a Report for Print

Lesson 6: Customizing the Access Environment

  • The Access Options Dialog Box 

Lesson 7: Designing a Relational Database

  • Relational Database Design 
  • Create a Table 
  • Create Table Relationships

Lesson 8: Joining Tables

  • Create Query Joins 
  • Join Tables That Have No Common Fields 
  • Relate Data within a Table 
  • Work with Subdatasheets 
  • Create Subqueries 

Lesson 9: Organizing a Database for Efficiency

  • Data Normalization 
  • Create a Junction Table 
  • Improve Table Structure

Lesson 10: Sharing Data Across Applications

  • Import Data into Access 
  • Export Data to Text File Formats 
  • Export Access Data to Excel 
  • Create a Mail Merge

Lesson 11: Advanced Reporting

  • Organize Report Information 
  • Format Reports 
  • Include Control Formatting in a Report 
  • Add a Calculated Field to a Report 
  • Add a Subreport to an Existing Report

Founded and headquartered in Anaheim, California, New Horizons Learning Centers was named the world's largest independent training company by IDC.

The Company is both an operator and franchisor of training centers that offer a broad range of Technical Training, Desktop Application, Business Skills and English Language courses for all levels of users in multiple delivery methods and formats.

New Horizons provides approximately three million student days of instruction annually with location around the globe.

New Horizons sets the pace of innovative training programs that meet the changing needs of the industry. With 2400 qualified instructors in over 2100 classrooms at 300 centers in 60 counters around the world.

New Horizons offers more courses, at more times, in more delivery methods than any other training company.

See all New Horizons Egypt courses

Contact information not available.

Courses you can instantly connect with... Professional Diploma in Microsoft Office Exceligent Academy Certificate in Accounting by Excel Exceligent Academy

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or