This course is for students who have never worked with an Access database before. The course introduces you to Microsoft Access 2016/19, which is a powerful database application software.
This course is for students who have never worked with an Access database before. The course introduces you to Microsoft Access 2016/19, which is a powerful database application software.
During this course, you will learn how to create simple tables, forms, queries, and reports. At the end of the course, you will be able to create your own simple database.
Design a Table
Design a table with various field types and properties to collect data.
Design a Form
Create a simple form based on a table to display the fields in a more user-friendly environment.
Use the formatting commands to design your form.
Use the property sheet or callouts located next to each section or control to design your form.
Create your own AutoFormats for future forms.
Create Queries
Create select queries using wildcards and operators to extract the information that you have collected on your table.
Create a calculated field in a query.
Run Delete and Update queries.
Create calculated fields in a query.
Create summary queries using SUM, AVERAGE, MAX, and MIN to summarize data.
Set up Relationships
Set up simple relationships between tables based on a key field.
Display related tables in a query.
Create a Report
Create a simple report based on tables or queries to display your data.
Place a calculated control on a report.
Validations and Restrictions
Add validations, restrictions, and input masks to fields to ensure the data is consistent.
Mail Merge
Create a query in Microsoft Access that is based on two tables, and then merge the query into a Word document.
Application Overview: Microsoft Access 2016/19
Microsoft Access is a relational database management system that combines the relational Microsoft Jet Database Engine with a graphical user interface. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container.
Get started quickly with prebuilt applications that you can modify or adapt to your needs. You can create and edit detailed reports that display sorted, filtered, and grouped information.
Using Microsoft Access, you can manage all your information from a single database file, run queries to find and retrieve just the data you want, and create forms to view, add, and update data in tables.
DPA Communications provides exceptional computer training on both Windows and Macintosh computers at your location in the Greater Toronto Area, including Ajax, Aurora, Brampton, Burlington, Markham, Milton, Mississauga, Newmarket, Oakville, Oshawa, Pickering, Richmond Hill, Vaughan, and Whitby.
Microsoft Excel course is offered by Academy Canada. We offer innovative programs that keep our clients on top of the latest trends and developments in their industries. They gain new skills and qualifications while their company benefits with increased productivity and efficiency.
In this course, you’ll learn the basics of creating, editing, and formatting documents in Word 2013. Discover how to leverage templates to build better documents, collaborate with other team members, create numbered and bulleted lists, and work with tables.
Microsoft Excel combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Participants will learn the basics of creating, editing, and saving worksheets.
All of the necessary learning tools are provided, including class notes, computers, and software. All we require is a meeting room. Our unique training style will ensure no topic is unexplored, no question remains unanswered, and all participants exit the course more knowledgeable than they entered...
This training helps you take advantage of the benefits of the Microsoft Power Platform (Office 365), in particular Power Automate. Power Automate lets you create workflows without the need to code to automate processes, even across different services and platforms.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy