ACCESS BASIC COURSE – TWO DAYS (COULD BE 1 DAY)

Prerequisites

Students should be familiar with Microsoft Windows and Office. No Access knowledge required.

Course Overview

A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool, which means you can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization.

In this course, you will learn how to use Access 2013 to manage your data by creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.

Access Basic Topics

  1. What is Access? What is a Database?
  2. What are RelatedTables?
  3. Database Concept
  4. Getting Started Screen
  5. Opening a database & Exploring Environment (blank- Template- Existing)
  6. Differences from Excel- Similarities with PowerPoint
  7. Getting Help
  8. How to plan a database?
  9. Explore tables in datasheet & design views
  10. Creating tables in datasheet view
  11. Creating tables in design View
  12. Changing the Design of A Table
  13. Effective & Ineffective field names
  14. Deleting, inserting & Moving Fields
  15. Attachment Data Type
  16. Add a Total row
  17. Finding and Editing Records
  18. Sorting records
  19. Filtering a table
  20. Setting Field Properties
  21. Working with Input Masks
  22. Setting Validation Rules
  23. What is a query?
  24. Create Queries using a Wizard
  25. Creating and Using in Design view
  26. Modifying Query Results And Queries
  27. Performing Operations In Queries
  28. What is a form
  29. Form Views
  30. Creating Forms by using form Button
  31. Creating Forms by using the Wizard
  32. Using Design View to create a form
  33. Sorting and Filtering Records in a form
  34. What is a Report?
  35. Different views of a Report
  36. Change default view
  37. How to create a report by using the wizard
  38. Create a Report in Design view
  39. 7 Sections of a report- Properties
  40. Grouping feature in Reports
  41. Modifying and printing reports

Share This Post
Have your say!
0 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

SUBSCRIBE To Our Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.
SUBSCRIBE NOW
close-link