Microsoft Access 2013

Profile photo of Trainer #2 Teacher: Trainer #2
₦5,000.00
0 student

0 rating


Course Description

MsAcces
Learn Microsoft Access 2013

This hands-on Microsoft Access 2013 introductory course will teach students how to use essential features of Microsoft Access 2013 and discover how to build a database and store your data more efficiently.

Accurate data is essential in a successful business. Microsoft Access 2013 course shows how to manage, create, and analyze effective databases. It starts with Access fundamentals and moves on to topics like filters, queries, forms, and reports.

Access is now much more than a way to create desktop databases. It’s an easy-to-use tool for quickly creating browser-based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure than ever, and you can easily share your applications with colleagues.

What Will I Learn?

  • The Fundamentals
  • Creating and Working with a Database
  • Finding, Filtering, and Formatting Data
  • Working with Tables
  • Creating Relational Databases
  • Working with Queries
  • Working with Forms
  • Working with Reports
  • Advanced Topics

Click here to enroll in this course.

Course Curriculum

  • The Fundamentals

    • Lesson 1a: Understand the Screen, Open and Save a Database, Work with Database Objects
      Viewing Completed Lesson
    • Lesson 1b: Tour of Tables, Tour of Queries, Tour of Forms, Tour of Reports, Help, Close and Exit Access
      Viewing Completed Lesson
  • Creating and Working with a Database

    • Lesson 2a: Plan a Database, Create a Database, Add, Edit, and Delete Records, Select Data, Cut, Copy, and Paste Data
      Viewing Completed Lesson
    • Lesson 2b: Use Undo and Redo, Check Spelling, Use the Zoom Box, Preview and Print
      Viewing Completed Lesson
  • Finding, Filtering, and Formatting Data

    • Lesson 3a: Find and Replace Data, Sort Records, Use Common Filters, Filter by Selection, Filter by Form, Create an Advanced Filter
      Viewing Completed Lesson
    • Lesson 3b: Adjust Rows and Columns, Change Gridlines and Cell Effects, Freeze a Column, Hide a Column
      Viewing Completed Lesson
  • Working with Tables

    • Lesson 4a: Create a Table, Understand Field Types and Properties, Index a Field, Add a Primary Key, Insert, Reorder, and Delete Fields, Add Field Descriptions and Captions, Change the Field Size, Format Number, Currency, and Date/Time Fields
      Viewing Completed Lesson
    • Lesson 4b: Format Text Fields, Set a Default Value, Require Data Entry, Validate Data, Create an Input Mask, Create a Lookup Field, Create a Value List, Modify a Lookup List
      Viewing Completed Lesson
  • Creating Relational Datebases

    • Lesson 5a: Table Relationships and Relationship Types, Create Relationships Between Tables, Enforce Referential Integrity, Print and Delete Relationships
      Viewing Completed Lesson
  • Working with Queries

    • Lesson 6a: Create a Query, Sort a Query, Use AND and OR operators in a Query, Create a Multiple Table Query, Create a Calculated Field, Work with Expressions and the Expression Builder
      Viewing Completed Lesson
    • Lesson 6b: Use an IIF Function, Summarize Groups of Records, Display Top or Bottom Values, Parameter Queries, Find Duplicate Records, Find Unmatched Records
      Viewing Completed Lesson
    • Lesson 6c: Crosstab Queries, Delete Queries, Append Queries, Make-Table Queries, Update Queries
      Viewing Completed Lesson
  • Working with Forms

    • Lesson 7a: Create a Form with the Form Wizard, Create and Use a Form, Modify a Form in Layout View, Form Design View Basics, Change the Tab Order, Work with Control Properties, Work with Form Properties
      Viewing Completed Lesson
    • Lesson 7b: Change a Control’s Data Source, Create a Calculated Control, Change a Control’s Default Value, Create a Subform, Work with and Modify Subforms
      Viewing Completed Lesson
  • Working with Reports

    • Lesson 8a: Create a Report, Use the Report Wizard, Use the Label Wizard, Work in Layout View, Format Fonts, Copy Formatting, Change Text Alignment
      Viewing Completed Lesson
    • Lesson 8b: Insert a Logo, Adjust Page Margin and Orientation, Add Page Numbers and Dates, Group and Sort, Summarize Data using Totals, Understand Report Sections
      Viewing Completed Lesson
  • Advanced Topics

    • Lesson 9a: Use Conditional Formatting, Work with Number Formatting, Use Themes, Import Information, Export Information, Link External Information
      Viewing Completed Lesson
    • Lesson 9b: Mail Merge Records to Word,Use Hyperlink Fields, Database Object Dependencies, Compact and Repair a Database, Convert an Access Database
      Viewing Completed Lesson