Microsoft Access: Up to Speed

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Welcome to Microsoft Access - Up To Speed:

This course helps you to get up and running quickly with the latest version of Microsoft’s powerful database application, Access 2019. This handy step-by-step class starts from scratch, starting with basic topics and moving on to more advanced features of the application, designed to help you to become more productive more quickly.

In no time at all you’ll be navigating Microsoft Access’s interface, create databases, entering data, creating data entry forms for users, and reports. You’ll also learn how to filter your data using queries, create relationships between your tables, and how to create macros to automate your tasks. Additionally, you’ll learn how to import data from other applications into Access and how to export your Access data to other applications. You’ll end by managing your databases using Access’s various database tools.


Who is this course for?

This course was created for people new to databases as well as database designers looking to learn a new and powerful database management application. This course will also be helpful for those coming from a previous version of Microsoft Access or those looking to delve more deeply into the Access application.

What does this course include?

· Step-by-step instructional videos that are easy to follow

· Downloadable lesson files allowing you to follow along with the instructor

· Support for any questions you may have

What You’ll Learn:

· The Basics. We’ll begin by creating a new Microsoft Access database file and then take a look at the Access environment. You’ll set Access options, learn about database templates, how to open an existing Access database and how to create a new database. We’ll also take a brief look at the various objects in Access: Tables, Forms, Queries and Reports. Then, you’ll learn how to obtain help when necessary.

· Working with Tables. You’ll start by creating a table using Application Part and we’ll move on to entering data into a table. You’ll discover how to create a table from scratch, add new fields to a table, change column width and height, delete fields from a table, change field properties and design while in Datasheet View. You’ll also learn all about setting Primary Keys.

· Working with Data. In this section, we’ll begin working with data. You’ll learn how to enter, edit, and format data. You’ll sort records, filter data by selection and form, select records and delete records. You’ll learn how to hide, unhide, freeze and rearrange columns. You’ll also import Excel data and data from a text file into an Access table. Lastly, you’ll learn how to display column totals in a datasheet.

· Advanced Tables. Next, we dive more deeply into working with Tables. Here, you’ll learn how to limit data entry be creating validation rules. You work with formatting and indexing fields, as well as how to require data entry in a field. Here, you’ll learn how to facilitate the data entry process by creating an Input Mask, a Lookup Field and a Value List. You’ll look at Primary Keys more in depth and learn how to create calculated fields in your tables.

· Working with Queries. Now we begin working with Queries. We’ll create queries both from scratch and using the Query Wizard. You’ll learn how to add fields to and remove fields from a query, rearrange query columns, how to add single or criteria to a query, and sort query data. You’ll also work with saving and running queries.

· Database Relationships. At this stage, you’ll learn all about database relationships. You’ll start by creating one-to-one relationships and then move on to one-to-many relationships and finally to many-to-many relationships. In order to maintain data integrity and to ensure that you never end up with orphaned records, you’ll learn how to cascade delete related records, enforce referential integrity and casted update related fields. You end up by creating and then printing a relationship report.

· Advanced Queries. Next, we’ll delve more deeply into the query object. We’ll learn how to create multi-table queries, using calculations in queries and change query properties. We’ll create expressions both manually and using the expression builder. You learn how to prompt a user for criteria by creating a Parameter Query as well as summarize data using a Totals Query. Using queries, you’ll find duplicate records in your table as well as find unmatched records between tables. You’ll also learn how to modify query joins in this section.

· Action Queries. In this section, we begin working with Action Queries; that is to say, queries that change the data in your tables. We’ll add data to a table using a Make-Table Query, adding data to an existing table using an Append Query, change data in your tables using an Update Query and delete data using a Delete Query. We’ll even take a brief look at creating an SQL query.

· Working with Forms. We now begin working with Forms. Here, we’ll create a form using the Form Wizard and then learn how to enter data into a form. We’ll change the layout of a form using Design view, add fields to forms, finding records in a form and modify the form from Layout view. You’ll also work with changing the properties of controls on your form.

· Advanced Forms. In this section, we’ll delve into some of the more advanced features of Forms. We’ll add headers and footers to a form, learn how to add various controls to a form as well as move and size controls. We’ll also perform calculations using calculated controls and modify individual control properties. Additionally, you’ll learn how to change form properties, modify the tab order in a form, insert graphics and lookup data in a table or query using a Lookup control. We’ll also learn how to add a subform and why you may need to.

· Working with Reports. Next, we’ll begin working with Access reports. We’ll begin by creating a basic report, applying a theme to an existing report and move to creating a more advanced report using the Report Wizard. We’ll look at the different report views and learn how to modify reports from design view. We’ll also learn how to print reports and create a label merge using the Label Wizard.

· Advanced Reports. In this stage, we’ll begin working with some more advanced report features. We’ll work with the various report sections, add controls to reports and modifying control properties. You’ll learn how to create a calculated control and how to change a control’s data source. We’ll take a look at how to sort and group report data, change report section properties and even change a report’s data source. You learn how to insert graphics and apply conditional formatting to a report.

· Advanced Features of Forms and Reports. Here, you’ll learn how to add a subform or subreport using the Subform/Subreport tool. You’ll learn how to modify a subform, align controls relative to one another and creating options groups. We’ll also look at how to insert total fields in reports, edit sorting and grouping levels in a report and add some pizazz to our reports using lines, rectangles and borders.

· Importing and Exporting Data. Now we delve deeply into exporting and importing data to and from Access. You’ll learn how to import data from a text file, Excel or from another Access database. You’ll also learn how to link data between databases. We’ll then work with exporting data to a variety of formats: a PDF file, to another Access database, to Excel, to Microsoft Word as an RTF file and even performing a Microsoft Word mail merge directly from within Access.

· Working with Macros. In this section, we begin working with Microsoft Access macros. Here, you’ll learn how to create a macro, add macro actions and executing a macro step-by-step. We assign a macro to a command button, use macro groups and use macro conditions. You’ll learn how to create an AutoExec macro that executes when a database is first opened, an AutoKeys Macro which executes after certain keystroke combinations are pressed and even a Data Macro which is a macro that is added to events in your tables. We’ll end by learning how to add a macro to the Quick Access Toolbar.

· Creating a System Menu. In order to make your database as user-friendly as possible, you’ll learn how to create a Switchboard. You’ll learn how to add items to a switchboard, edit a switchboard, setting startup options and create a navigation form.

· Database Tools and Maintenance. We’ll finish off the course by learning how to maintain your databases. You’ll learn how to compact and repair databases, change database properties, document and analyze your databases and view database dependencies. We’ll also learn how to back up a database and split a database into a front end and back end. Lastly, we’ll learn how to password-protect a database.


By the end of this course, you’ll learn how to create, organize and manage your Access databases, allowing you to effectively remain in control of your data.


My Promise to You!

I'll be here for you every step of the way so if you have any questions at all that come up as you’re working through the course, please let me know. Feel free to post your question in the course or send me an email.

I want to ensure that this is the best course on how to use Microsoft Access so if you have any suggestions on how I can improve the course, please let me know.

Are you ready to begin your Microsoft Access journey? Then, click the enroll icon and let’s get started!

- Roger

Who this course is for:

  • Beginning students who wish to learn Microsoft Access.

Expected Outcomes

  1. How to create, design and maintain databases using Microsoft Access. Requirements Should be familiar with the Windows operating system. Description Welcome to Microsoft Access - Up To Speed: This course helps you to get up and running quickly with the latest version of Microsoft’s powerful database application, Access 2019. This handy step-by-step class starts from scratch, starting with basic topics and moving on to more advanced features of the application, designed to help you to become more productive more quickly. In no time at all you’ll be navigating Microsoft Access’s interface, create databases, entering data, creating data entry forms for users, and reports. You’ll also learn how to filter your data using queries, create relationships between your tables, and how to create macros to automate your tasks. Additionally, you’ll learn how to import data from other applications into Access and how to export your Access data to other applications. You’ll end by managing your databases using Access’s various database tools. Who is this course for? This course was created for people new to databases as well as database designers looking to learn a new and powerful database management application. This course will also be helpful for those coming from a previous version of Microsoft Access or those looking to delve more deeply into the Access application. What does this course include? · Step-by-step instructional videos that are easy to follow · Downloadable lesson files allowing you to follow along with the instructor · Support for any questions you may have What You’ll Learn: · The Basics . We’ll begin by creating a new Microsoft Access database file and then take a look at the Access environment. You’ll set Access options, learn about database templates, how to open an existing Access database and how to create a new database. We’ll also take a brief look at the various objects in Access: Tables, Forms, Queries and Reports. Then, you’ll learn how to obtain help when necessary. · Working with Tables. You’ll start by creating a table using Application Part and we’ll move on to entering data into a table. You’ll discover how to create a table from scratch, add new fields to a table, change column width and height, delete fields from a table, change field properties and design while in Datasheet View. You’ll also learn all about setting Primary Keys. · Working with Data. In this section, we’ll begin working with data. You’ll learn how to enter, edit, and format data. You’ll sort records, filter data by selection and form, select records and delete records. You’ll learn how to hide, unhide, freeze and rearrange columns. You’ll also import Excel data and data from a text file into an Access table. Lastly, you’ll learn how to display column totals in a datasheet. · Advanced Tables. Next, we dive more deeply into working with Tables. Here, you’ll learn how to limit data entry be creating validation rules. You work with formatting and indexing fields, as well as how to require data entry in a field. Here, you’ll learn how to facilitate the data entry process by creating an Input Mask, a Lookup Field and a Value List. You’ll look at Primary Keys more in depth and learn how to create calculated fields in your tables. · Working with Queries. Now we begin working with Queries. We’ll create queries both from scratch and using the Query Wizard. You’ll learn how to add fields to and remove fields from a query, rearrange query columns, how to add single or criteria to a query, and sort query data. You’ll also work with saving and running queries. · Database Relationships. At this stage, you’ll learn all about database relationships. You’ll start by creating one-to-one relationships and then move on to one-to-many relationships and finally to many-to-many relationships. In order to maintain data integrity and to ensure that you never end up with orphaned records, you’ll learn how to cascade delete related records, enforce referential integrity and casted update related fields. You end up by creating and then printing a relationship report. · Advanced Queries. Next, we’ll delve more deeply into the query object. We’ll learn how to create multi-table queries, using calculations in queries and change query properties. We’ll create expressions both manually and using the expression builder. You learn how to prompt a user for criteria by creating a Parameter Query as well as summarize data using a Totals Query. Using queries, you’ll find duplicate records in your table as well as find unmatched records between tables. You’ll also learn how to modify query joins in this section. · Action Queries. In this section, we begin working with Action Queries; that is to say, queries that change the data in your tables. We’ll add data to a table using a Make-Table Query, adding data to an existing table using an Append Query, change data in your tables using an Update Query and delete data using a Delete Query. We’ll even take a brief look at creating an SQL query. · Working with Forms. We now begin working with Forms. Here, we’ll create a form using the Form Wizard and then learn how to enter data into a form. We’ll change the layout of a form using Design view, add fields to forms, finding records in a form and modify the form from Layout view. You’ll also work with changing the properties of controls on your form. · Advanced Forms. In this section, we’ll delve into some of the more advanced features of Forms. We’ll add headers and footers to a form, learn how to add various controls to a form as well as move and size controls. We’ll also perform calculations using calculated controls and modify individual control properties. Additionally, you’ll learn how to change form properties, modify the tab order in a form, insert graphics and lookup data in a table or query using a Lookup control. We’ll also learn how to add a subform and why you may need to. · Working with Reports. Next, we’ll begin working with Access reports. We’ll begin by creating a basic report, applying a theme to an existing report and move to creating a more advanced report using the Report Wizard. We’ll look at the different report views and learn how to modify reports from design view. We’ll also learn how to print reports and create a label merge using the Label Wizard. · Advanced Reports. In this stage, we’ll begin working with some more advanced report features. We’ll work with the various report sections, add controls to reports and modifying control properties. You’ll learn how to create a calculated control and how to change a control’s data source. We’ll take a look at how to sort and group report data, change report section properties and even change a report’s data source. You learn how to insert graphics and apply conditional formatting to a report. · Advanced Features of Forms and Reports. Here, you’ll learn how to add a subform or subreport using the Subform/Subreport tool. You’ll learn how to modify a subform, align controls relative to one another and creating options groups. We’ll also look at how to insert total fields in reports, edit sorting and grouping levels in a report and add some pizazz to our reports using lines, rectangles and borders. · Importing and Exporting Data . Now we delve deeply into exporting and importing data to and from Access. You’ll learn how to import data from a text file, Excel or from another Access database. You’ll also learn how to link data between databases. We’ll then work with exporting data to a variety of formats: a PDF file, to another Access database, to Excel, to Microsoft Word as an RTF file and even performing a Microsoft Word mail merge directly from within Access. · Working with Macros. In this section, we begin working with Microsoft Access macros. Here, you’ll learn how to create a macro, add macro actions and executing a macro step-by-step. We assign a macro to a command button, use macro groups and use macro conditions. You’ll learn how to create an AutoExec macro that executes when a database is first opened, an AutoKeys Macro which executes after certain keystroke combinations are pressed and even a Data Macro which is a macro that is added to events in your tables. We’ll end by learning how to add a macro to the Quick Access Toolbar. · Creating a System Menu. In order to make your database as user-friendly as possible, you’ll learn how to create a Switchboard. You’ll learn how to add items to a switchboard, edit a switchboard, setting startup options and create a navigation form. · Database Tools and Maintenance. We’ll finish off the course by learning how to maintain your databases. You’ll learn how to compact and repair databases, change database properties, document and analyze your databases and view database dependencies. We’ll also learn how to back up a database and split a database into a front end and back end. Lastly, we’ll learn how to password-protect a database. By the end of this course, you’ll learn how to create, organize and manage your Access databases, allowing you to effectively remain in control of your data. My Promise to You! I'll be here for you every step of the way so if you have any questions at all that come up as you’re working through the course, please let me know. Feel free to post your question in the course or send me an email. I want to ensure that this is the best course on how to use Microsoft Access so if you have any suggestions on how I can improve the course, please let me know. Are you ready to begin your Microsoft Access journey? Then, click the enroll icon and let’s get started! - Roger Who this course is for: Beginning students who wish to learn Microsoft Access. Show more Show less Course content 18 sections • 160 lectures • 8h 38m total length Expand all sections Access Basics 13 lectures • 41min Before You Begin Preview 01:03 Introduction Preview 05:31 Understanding Databases Preview 03:49 Using Database Templates Preview 03:51 Opening an Existing Database 04:08 The Access Environment 04:06 A Look at Tables 03:25 A Look at Forms 03:45 A Look at Queries 02:24 A Look at Reports 01:54 Creating a Blank Database 01:20 Setting Access Options 02:07 Getting Help 03:48 Working with Tables 10 lectures • 35min Creating a Table Using Application Parts 03:13 Entering Data into a Table 01:55 Adding New Fields to a Table 04:10 Creating a Table from Scratch 06:53 Setting a Primary Key 02:39 Changing the Column Width and Row Height 01:55 Rearranging Fields 01:22 Inserting and Deleting Fields 02:04 Changing Field Properties 07:10 Designing in Datasheet View 03:53 Working with Data 14 lectures • 39min Editing Data 02:58 Formatting Table Data 03:14 Importing Excel Data into an Existing Table 04:08 Importing a Text File into a New Table 05:35 Selecting and Deleting Records 01:30 Sorting Records 03:07 Finding and Replacing Data 04:46 Filtering Data by Selection 02:21 Filtering Data by Form 01:55 Using Common Filters 02:37 Hiding and Unhiding Columns 01:40 Freezing Columns 01:50 Rearranging Columns 01:22 Displaying Column Totals in a Datasheet 02:02 Delving Deeper into Tables 11 lectures • 35min Setting Validation Rules 05:30 Formatting Fields 05:42 Indexing Fields 03:31 Requiring Data Entry 01:14 Creating an Input Mask 04:49 Creating a Lookup Field 04:13 Creating a Value List 01:20 Modifying a Value List 01:20 Creating Calculated Fields 01:58 Creating Multiple Primary Keys 03:15 Creating Multiple Field Values 02:27 Working with Queries 10 lectures • 19min Working in Query Design View 04:08 Creating a Query in Design View 00:57 Adding Field to a Query 02:46 Removing Fields from a Query 00:34 Saving a Query 00:56 Running a Query 01:16 Adding Criteria to a Query 02:00 Specifying Multiple Criteria 03:00 Sorting Data in a Query 01:28 Moving Columns in a Query 01:28 Database Relationships 8 lectures • 26min A Look at Relationships 02:49 Creating a One-to-One Relationship 03:30 Creating a One-to-Many Relationship 02:53 Creating a Many-to-Many Relationship 03:08 Enforcing Referential Integrity 04:28 Cascade Update Related Fields 04:00 Cascade Delete Related Records 03:04 Creating and Printing a Relationship Report 02:28 Delving Deeper into Queries 9 lectures • 30min Creating Multi-Table Queries 02:30 Using Calculations in Queries 03:25 Changing Query Properties 01:20 Working with the Expression Builder 04:46 Creating a Totals Query 04:05 Creating a Parameter Query 05:01 Creating a Find Duplicates Query 02:02 Creating a Find Unmatched Records Query 02:32 Modifying Query Joins 04:01 Working with Action Queries 6 lectures • 23min About Action Queries 02:28 Creating a Make-Table Query 04:47 Creating an Append Quey 04:29 Creating an Update Query 03:03 Creating a Delete Query 03:41 Creating a SQL Query 04:05 Creating Forms 7 lectures • 20min Using the Form Wizard 03:46 Entering Data into a Form 02:31 A Look at Design View 03:10 Adding a Field to a Form 01:42 Changing Control Properties 02:51 Using Layout View 02:33 Finding Records in a Form 03:08 Delving Deeper into Forms 10 lectures • 40min Adding Headers and Footers 05:06 Adding Controls to a Form 01:59 Moving and Resizing Controls 02:32 Creating a Calculated Control 03:20 Changing Control Properties 06:18 Changing Form Properties 02:58 Changing the Tab Order 04:30 Adding a Lookup Control 06:30 Inserting Graphics 02:47 Creating a Subform 03:45 8 more sections Instructor Roger Hyttinen Course Designer and Instructor 4.3 Instructor Rating 22 Reviews 105 Students 8 Courses I am a writer, photographer, course developer and software and I’ve run my own computer courseware company for the past 20 years. I’ve also worked at a courseware designer, programmer, technical writer, public speaker, curriculum developer, and college-level instructor. I’m currently based in Milwaukee, WI and I graduated with a Masters of Arts from the University of Wisconsin-Milwaukee in 1990. Have questions about me or any of my courses? Feel free to ask away as I love hearing from people. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781ddca8a52dbf7',m:'a149e97075f5cb098e0d99efafcb688da7e0e39b-1627850268-1800-AVuLyJ4GgKIrHtrFu+dkfMfPOgTJZmhmxkj8MO0Pgon8o3hOz2KH2sIwuakkRa2gqFxv3S0ZgQ6V5oTZ0SF1OYVtUmac2tiv7gXruRkyEI3Fuim1eL/k5isk+yA/XHDSDeB4i+KBuE99VfCc5qXmJpS8UqUjAwCdhilDGQNEsWz3',s:[0xd7f5d3cde7,0x14df9508b3],}})();