Microsoft Access for Beginners

Who this course is for, what to expect and a first look at the database we will be creating in this course.  

Explore the templates available in Access and create a contacts database using the template.

Learn how to create a database, save it to a specific location, and how to open existing databases.

Understand the Access Interface including the different workspace elements, the ribbons, and the backstage area. 

Get Help on demand when working in Access. 

Learn how to work with the ribbons in Access and add frequently used commands to the Quick Access Toolbar.

In this lesson, we will learn about tables in Access, and then setup our first table and add fields. 

Understand indexing and the concept of primary key fields to identify records. We will then start to build our database by adding our first records to the Trip table. 

Control the information entered into a field by creating a drop-down list using the Lookup Wizard. 

Add three numeric fields to the table and set the properties for each including data validation rules. 

Import additional data from an Excel file and a Text File into Access and append it to the bottom of the Ticket table.

Explore the options for designing in the datasheet view.

Organize and refine records in a table using sorting and filtering in datasheet view. 

Learn some useful tips for entering data into Datasheet view.

Understand how relationships work in Access and why they are fundemental to building a functional database. 

Start the process of creating a relationship between two tables by setting up a link table.

Create a third table to hold the company information and then create a link table to link the ticket table to the company table. 

Make changes to the link table and understand the types of error messages that can occur. 

Creating a user form using the Form Wizard. 

Adjust the properties of the form using the Property Sheet and Form Properties. 

Make modifications to the way the form looks and behaves by switching it to Single form view.

Make design changes to a form using Layout View. 

Make design changes to a form using Layout View. 

Create a blank form, add fields, and make changes to the form in Design View. 

Continue editing the form in Design View. 

Create a new table, populate it with information, and link it to the ticket table in preparation for creating a subform. 

Continue setting up the subform and protect it from editing.

Creating your first query to search through records in a database.

Learn how to use joins to create a query using information from more than one table.

Use the Query Wizard to build different types of query and perform aggregation.

Use an expression to perform calculations on fields and display new information, such as an end date.

Create a basic report using the Report Wizard and explore Print Preview.

Explore the basics of modifying a reports design.

Add a Yes/No checkbox control to a form.

Add an attachment form control. 

Add option buttons to the form. 

Switch between different themes and customize a theme. 

Limit users to just the forms they need by creating a navigation form. 

Explore the different ways you can export tables, forms and reports. 

Modify database properties and encrypt the database with a password.

Repair and fix errors in a database.

How to adjust Print Properties and Print database objects.