Learn the many facets of Microsoft Access 2019, from basic functions like database objects, querying a database and creating reports to advanced reporting techniques, macros and database design.
This course prepares students for the Microsoft Access 2019 national certification exam.
Lesson 1: Database Basics
Lesson 2: Maintaining a Database and Creating Reports
Lesson 3: Advanced Reporting
Lesson 4: Advanced Form Techniques and Macros
Lesson 5: Administering Access and Using SQL
Lesson 6: Database Design
Upon successful completion of this course, students will be able to:
- Create a Microsoft Access database.
- Create a report from a database.
- Create queries in a database.
- Maintain a database by using action queries, formatting a datasheet and sorting records.
- Create reports and forms.
- Perform advanced report and form techniques.
- Create and modify macros in a database.
- Demonstrate the use of SQL language.
- Design a database.
Students must have a copy of Microsoft Office 365 in order to complete coursework.
Students have 12 months to complete this self-paced online course.
System Requirements:Internet Connectivity Requirements:
- Cable and DSL internet connections recommended for best experience.
- CPU: 1 GHz or higher
- RAM: 2 GB or higher
- Resolution: 1280 x 720 or higher
- Speakers / Headphones
- Microphone (Webinar / Live Online sessions)
- Microsoft Windows 7 or 10 (Home, Pro)
- Mac OSX 10 or higher.
- Latest Chrome OS
- Latest Linux Distributions
NOTE: While our courses can be viewed on Android and iPhone devices, we do not recommend using these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online-based courses.Web Browser Requirements:
- Latest Google Chrome recommended for best experience.
- Latest Mozilla Firefox
- Latest Microsoft Edge
- Latest Apple Safari
- Office suite software (Microsoft Office, OpenOffice or LibreOffice)
- PDF reader program (Adobe Reader, FoxIt)
- Courses may require other software as denoted in above course outline.