Inserting Importing & Formatting Data in Access 2019 for Windows
In this 8-video course "Access 2019: Inserting Importing and Formatting Data" learners will discover how to enter and import data change formatting settings create dropdown menus enforce data validation and create labels with data. Begin the course by learning how to insert data into a table and then explore how to modify the default navigation settings. In Access you can import data that has been created or edited in a different program which can save you the time required to manually reenter your data values or records. You will next learn how to use Excel data in a database. This leads into exploring how to import an address book from Outlook. Thereafter learners will delve into formatting text in their data; creating a dropdown menu; and also creating data validation rules which can be used to place limits on the information that can be inserted into access data tables. The course concludes by demonstrating how to create labels.