MS Access

Expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports.  Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.  The Microsoft Access course gives you basic database management skills, such as creating tables, designing forms and reports, and building queries.

Course Objectives:

Day 1

  •  Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.

  •  Organize and manage data stored within Access tables.

  •  Use queries to join, sort, and filter data from different tables.

  •  Use forms to make it easier to view, access, and input data.

  •  Create and format custom reports.

Day 2

  •  Design a relational database.

  •  Join tables to retrieve data from unrelated tables.

  •  Validate data entered into a database.

  •  Use advanced queries to manipulate your data.

  •  Organize a database for efficiency and performance, and to maintain data integrity.

  •  Customize reports to organize the displayed information and produce specific print layouts.

Day 3

  •  Customize a form layout to improve usability and efficiency of data entry.

  •  Share data across applications.

  •  Use macros to improve user interface design.

  •  Use VBA to enhance tasks.

  •  Organize data into appropriate tables to ensure data dependency and minimize redundancy.

  •  Lock down and prepare a database for distribution to multiple users.

  •  Create and modify a database switchboard and set the startup options.

Contact us to customize this class with your own dates, times and location at info@cynwavesolutions.com or call 1-706-828-1891.

  • phone-receiver (1)
706-828-1891
  • location
238 Edenbridge Way Evans, GA 30809