Microsoft Office Access 2016: Part 1 (Beginner)
4.3 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
238 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Office Access 2016: Part 1 (Beginner) to your Wishlist.

Add to Wishlist

Microsoft Office Access 2016: Part 1 (Beginner)

Learn the basics of building an Access database. Learn step-by-step how to create tables, queries, forms and reports.
4.3 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
238 students enrolled
Last updated 7/2017
English
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • Just basic computer skills.
Description

A relational database application such as Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. 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.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Who is the target audience?
  • This course is designed for you, if you wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
42 Lectures
02:26:22
+
Getting Started with Access
12 Lectures 43:36

You might use a database to store
records of assets or inventory, customer information, sales transactions, maintenance schedules, statistical data, quality measures, and so forth. In fact, virtually any sort of information that can be entered into a computer can be stored in a database. Let's get started. (Lesson Introduction)

Preview 03:04

You might use a database to store records of assets or inventory, customer information, sales transactions, maintenance schedules, statistical data, quality measures, and so forth. In fact, virtually any sort of information that can be entered into a computer can be stored in a database. Let's get started. (Lesson Introduction)

Orientation to Access
04:28

Learn when to choose Access over Excel. (Typical database management tasks Access handles better than Excel)

Preview 02:20

A table is a storage container that stores data in rows and columns. Learn to perform some basic tasks in a table. (Record Navigation Bar, Navigate, Edit, Save, Delete, New Record)

Navigate Tables
03:56

Forms provide a graphical user interface (GUI) for entering and modifying table data. (Forms, Record Navigation Bar, Edit, Save, Delete, New Record)

Navigate and Edit Data in Forms
02:05

You might have never worked with a relational database before, so let me explain what a relational database is.

Relational Databases
03:42

Tables give a database its structure, providing an organized place to store data. Data is useful, however, only if it can be located, retrieved, and presented in meaningful ways.

Use Queries - Introduction
01:32

Queries provide the means to locate and retrieve data in a database. (Queries, Filter Data)

Use Queries
01:50

Reports provide a publish-ready view of data that you can output to various pront or digital formats. (Print Preview)

Use Reports
02:28

You have opened and edited existing database objects like tables, queries etc. - now it's time to create your Access Database and the first table! (Database Templates, Field Data Types, Primary Key)

Create a New Database
06:56

As you work with Access, you might need to look for additional information. The Tell Me feature might help you save time find the command in the ribbon. (Help, Tell Me)

Get Help
05:12

Lern how to customize Access to your needs. (Options, Trust Center, Quick Access Toolbar)

Configure Options in Access
06:03

Microsoft Access 2016 Part 1 Quiz 1
3 questions
+
Working with Table Data
7 Lectures 16:13

You created the basic table structure within a database. To keep data in these tables current, you need to know how to add, delete, and update data in a table. (Lesson Introduction)

Preview 00:57

Learn how to modify table data. (Autocorrect, Commit, Save and Undo)

Record Modifications
02:45

The Record navigation bar Search text box provides a quick means to jump to a specific record. (Search box)

Use Quick Search to Find and Modify Records
02:30

The Find and Replace dialog box enables you to quickly locate and change database information. (Find, Replace)

Use Find and Replace to Modify Records
03:05

The term "ask questions" might be a little unfamiliar at first, but learn why database developers use that term frequently.

Ask Questions to a Table - Introduction
00:34

Learn how to use the Totals row to add summary values to a table. (Totals (count of records or the sum, average, maximum, minimum, standard deviation))

Add a Totals Row to a Datasheet
01:55

As you work with a database, it can be helpful to temporarily sort or filter a table to show only records that match certain criteria. (Sort, Filter)

Sort and Filter Records
04:27

Microsoft Access 2016 Part 1 Quiz 2
2 questions
+
Querying a Database
8 Lectures 23:40

Now it gets exciting, because queries allow you to work with data in a very flexible way. (Lesson Introduction)

Preview 01:25

The Simple Query Wizard prompts you through steps to create a query. (Query Wizard)

Create a Query by Using the Query Wizard
03:41

Learn how to use the Query Design feature to create a new query in Design view. This tool give you the maximum flexibility creating the queries you need. (Query Design, Naming Conventions)

Create a Query by Using Query Design
03:28

Learn how to use query criteria to specify which records should be included in a query result. (Comparison Operators (=, <, >, etc.). Logical Operators (AND, OR, NOT))

Filter a Query Using a Comparison Operator
03:05

You can use various wildcard characters in conjunction with query criteria. Wildcards enable you to match records based on patterns, rather than requiring a literal character-by-character match. (Wildcards (*, #, ?, etc))

Filter a Query by Using a Wildcard
04:03

(Date, Range, The Zoom Dialog Box)

Filter a Query by Using a Date Range
03:00

In a large table, it may be difficult to work with records if they are not displayed in a useful order. (Sort, Multi-Level-Sort)

Sort Records in a Query
01:53

In many instances, you will need to perform calculations on the data stored in your database. Because the tables already store the data that will be used to perform the calculations; therefore, the calculations should be executed in queries, forms, and reports. (Arithmetic Operators (+, -, *, /, ^), Expression Builder)

Preview 03:05

Microsoft Access 2016 Part 1 Quiz 3
3 questions
+
Using Forms
6 Lectures 21:31

If your Access desktop database is going to be used by multiple users, a well-designed form is essential for efficiency and data entry accuracy. (Lesson Introduction)

Preview 01:09

Working in a database will only takes you so far, Forms display and change data, accept new data, and interact with the user. (Form View, Form Wizard)

Create and Test a Form
04:29

Navigate in Forms, Search for Records, Filter Records, Sort Records

View and Change Data in a Form
04:35

Learn why properties are used extensivly in forms and reports.

Preview 01:02

Properties are named attributes of controls, fields, and database objects. Learn how to set properties to modify the characteristics of a control, field, or object. (Property Sheet, Hide Fields, Hide Ribbon Commands)

Set Form Properties
03:40

A lookup field is a field in one table that is bound to another value in a source data table or value list. The lookup field can a display a list of user friendly values to select from. (Lookup Fields, Relationships View, Foreign Key, Control Wizards, Combo Box, Referential Integrity)

Configure a Form Lookup Field
06:36

Microsoft Access 2016 Part 1 Quiz 4
2 questions
+
Generating Reports
8 Lectures 39:12

As your database starts to accumulate useful information, you may want to produce reports that you can use for analysis and subsequent publishing to print or digital form.

Preview 01:59

Learn how to create a report that includes all the fields in a table or query. 

Preview 02:47

The Report Wizard guides you through steps to create a report based on one or more tables or queries, enabling you to select which fields you want to include in the report. (The Report Wizard)

Use the Report Wizard
03:30

The various tools used to generate a report are often able to create most or all of the controls and layout for you. However, there are times when you will need to add controls manually. (The Report Design view, Report Sections (Headers, Detail, Footers), Controls)

Adjust the Report Control Layout
07:53

Access provides numerous options to enhance the appearance of a report. For example, you can apply color themes and font styles, and add graphics to any band in a report design. (Themes, Add Images)

Enhance the Appearance of a Report
03:29

When you print a report, you may find that the report contains too much information to fit within a page. It is often necessary to adjust page setup and layout options when you first set up a report for printing. (Page Size, Margins, Print Preview)

Prepare a Report for Print
02:20

Reports that use grouping or display summary information are easier to understand. In this topic, you will organize information this way. You'll expand upon simple report designs to create attractive, informative printouts. (Group, Sort, and Total Pane, Group Headers and Footers)

Report Modifications
06:51

You may want to enhance a report's appearance. In this topic, you will format reports as well as control pagination. This results in a professional-looking report that captures the reader's attention. (Report Control Properties, Report Pagination, Keep Together Property, Force New Page Property)

Format a Report
10:23

Microsoft Access 2016 Part 1 Quiz 5
6 questions
+
Course Follow Up
1 Lecture 02:10

Congratulations! You have completed the Microsoft Office Access 2016: Part 1 course. (What's next?)

Preview 02:10
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.4 Average rating
358 Reviews
6,233 Students
51 Courses
Training Company

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.