Access 2019 E-Learning

Access 2019 E-Learning Cursus

Bestel deze geweldige, bekroonde Access 2019 E-Learning cursus online, 1 jaar 24/7 toegang tot uitgebreide interactieve video's, toespraken, praktische taken en voortgangsbewaking. Na de cursus ontvang je een certificaat van deelname.

Cursusinhoud

Access 2019: Working with Databases

open the application and open a database
use database templates to quickly create a database
navigate the interface to locate the tools available to manage and create a database
customize the application's interface and theme
customize the Quick Access toolbar
customize the tool ribbon

Access 2019: Saving, Printing & Exporting Databases

save your data as database or object
repair, backup and adjust your database save settings
protect your database by adding password encryption
print your database items
export you data from the database into different formats include Excel, PDF and HTML
send your database table via email

Access 2019: Tables, Fields & Entries

understand the key features of your data base such as table, field, value, query and form
create a table automatically or manually in a database
organize, filter and hide database items
insert fields into table
format database fields
edit database field properties
link data in different tables
manage data relationships
visualize object dependencies

Access 2019: Inserting, Importing & Formatting Data

insert data into a table
modify the default navigation settings
use Excel data in a database
import an address book from Outlook
format text in the data
create a dropdown menu
create data validation rules
create labels

Access 2019: Finding & Organizing Data

sort the data in the data tables
filter the data in the data tables
search and find data values
replace data values
edit database indexes
find duplicate values in a database

Access 2019: Creating Forms & Queries

create a data entry form using the wizard
Using different form types
Creating a data entry form from scratch
Inserting text in a form
Creating a simple query
Creating a crosstab query
Performing a simple calculation
Creating a calculated field

Access 2019: Customizing Forms

format the text boxes you have inserted into your form
insert a list box in a form
insert checkboxes in a form
insert buttons in a form
reorganize the elements in a form
edit information in a form
customize the appearance of a form
edit the forms properties

Access 2019: Using the Report & Analysis Tools

create a quick report
create a database report from scratch
customize a report
clean up a database
analyze a database