Microsoft Access 2013 Level 1

////Microsoft Access 2013 Level 1
Microsoft Access 2013 Level 1 2018-05-08T16:42:00+00:00

Microsoft Access 2013 Level 1

Course Length :  35 Hours

Course Description

This Microsoft® Access 2013 Certification Guide teaches students how to design data tables, select appropriate data types and relate tables logically. Students will create and modify database objects including tables, forms, reports, queries and macros, and will apply intermediate skills to streamline data entry, ensure data integrity, automate tasks and analyze data.
Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Office Specialist Access 2013 Exam #77-424. Successful completion of the certification exam provides a competitive advantage by validating the knowledge and skill sets for individuals who may be seeking employment or further job opportunities in their careers.

Course Prerequisites

This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse. The course assumes that students have completed the Microsoft Windows course or have equivalent Microsoft Windows knowledge and experience.

  • start and run Windows
  • use the taskbar
  • use the Start button
  • use the Help feature
  • use Minimize, Restore Down/Maximize, or lose
  • use the left and right mouse buttons appropriately
  • understand file management techniques
  • navigate between files, folders, or drives

Outline

Lesson 1: Exploring the Access Environment

  • An Introduction to Databases
  • Databases in Spreadsheets
  • Relational Database Management Systems (RDBMS)
  • What is Access?
  • Access Database File
  • Database Objects
  • Desktop Databases and Access Web Apps
  • Components of the Access 2013 User Interface
  • The Ribbon
  • The Navigation Pane
  • Backstage View
  • Looking at the Screen
  • Viewing Screen Tips
  • Using the Quick Access Toolbar
  • Access 2013 and Backward Compatibility
  • Exporting Data to Alternate Formats
  • Setting Access Options
  • Starting Access and Working with Database Files
  • Database Wizards
  • Templates
  • Closing a Database
  • Opening an Existing Database
  • Using the Navigation Pane
  • Viewing Objects
  • Sorting and Filtering Objects
  • Copying Objects
  • Renaming Objects
  • Deleting Objects
  • Setting Navigation Options
  • Saving and Exporting Databases
  • Saving Databases to Different Locations
  • Saving a Database as a Template
  • Viewing Related Data

Lesson 2: Building Tables

  • Table Basics
  • Planning Tables
  • Planning Fields
  • Naming Rules and Conventions
  • A Model of Table Structure
  • Data Types
  • Field Size Property
  • Table Views
  • Creating Tables in Design View
  • Modifying Tables in Design View
  • Primary Keys
  • Selecting a Primary Key
  • Creating Tables in Datasheet View
  • Reusing Design Elements
  • Using Quick Start Fields
  • Using Application Parts
  • Using User Templates
  • Importing Data
  • Importing Tables from Other Databases
  • Importing Data from Excel
  • Importing Data as a Linked Table
  • Working in Datasheet View
  • Navigating a Datasheet
  • Adding, Updating and Deleting Records
  • Manipulating a Datasheet
  • Printing Datasheet Records
  • Constraining Input
  • Validation Rules
  • Input Masks
  • Default Values
  • Auto-incrementing Fields
  • Table Relationships
  • Relationship Types
  • Creating Relationships in a Database
  • Creating Lookup Fields

Lesson 3: Retrieving the Data You Want

  • Retrieving Data
  • Finding Records
  • Finding and Replacing Data
  • Using Wildcards
  • Sorting Records
  • Filtering Records
  • Filter by Selection
  • Filter by Form
  • Creating Queries
  • Creating a Select Query in Query
  • Design View
  • Creating a Select Query with the Query Wizard
  • Modifying Queries
  • Adjusting Fields
  • Sorting Query Fields
  • Hiding Query Fields
  • Adding Query Criteria
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • Special Operators
  • Working with Joined Tables
  • Performing Calculations in Queries
  • Adding Calculated Fields to a Query
  • Formatting Query Fields
  • Using the Expression Builder
  • Displaying Totals in a Query Result Set Datasheet
  • Grouping and Summarizing Query Data
  • Creating Parameter Queries
  • Using Conditional Logic in a Query
  • Creating Action Queries
  • Creating Update Queries
  • Creating Make-Table Queries
  • Creating Append Queries
  • Creating Delete Queries
  • Creating Crosstab Queries
Online Course Fee Payment
Other Amount:
Your Email Address:

Microsoft Access 2013 Level 1

  • Duration :   35 Hours
  • Certificates :   Yes
Online Course Fee Payment
Other Amount:
Your Email Address:

Quick Facts

This Microsoft® Access 2013 Certification Guide teaches students how to design data tables, select appropriate data types and relate tables logically. Students will create and modify database objects including tables, forms, reports, queries and macros, and will apply intermediate skills to streamline data entry, ensure data integrity, automate tasks and analyze data.
Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Office Specialist Access 2013 Exam #77-424. Successful completion of the certification exam provides a competitive advantage by validating the knowledge and skill sets for individuals who may be seeking employment or further job opportunities in their careers.