Microsoft Access O365/2019 - Level 1 / Intro
Microsoft Access O365/2019 - Level 1 / Intro Course Details:
You can use it as a personal data management tool, or you can use it to develop applications for a department or an entire organization. In this course, you will use Access 2019/O365 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Call (919) 283-1653 to get a class scheduled online or in your area!
Getting Started with Access
- Orientation to Microsoft Access
- Create a Simple Access Database
- Get Help and Configure Options in Microsoft Access
Working with Table Data
- Modify Table Data
- Sort and Filter Records
Querying a Database
- Create Basic Queries
- Sort and Filter Data in a Query
- Perform Calculations in a Query
Using Forms
- Create Basic Access Forms
- Work with Data on Access Forms
Generating Reports
- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
- Organize Report Information
- Format Reports
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
Students will learn,
- Getting Started with Access
- Working with Table Data
- Querying a Database
- Using Forms
- Generating Reports
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.