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 FREE BOOK

Receive my Amazing Textbook “Pivot Tables From Zero To Hero” Totally FREE when you subscribe below to our emailing list.
SUBSCRIBE NOW
close-link