In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Duration: 1 day
Cork Date: 18 Aug, 26 Oct, 12 Dec
Dublin Date: 20 Jul, 05 Sep, 13 Nov
This course is also available as a customised client specific course.
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. For example, you can obtain this level of skills and knowledge by taking either of the following courses, or any similar courses in general Microsoft Windows skills:
Using Microsoft Windows 10
Microsoft Windows 10: Transition from Windows 7
In this course, you will create and manage an Access 2016 database.
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.
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