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.

​