An introduction to Microsoft Access.
Video time: 6m 34s
Enter a new record into a table and move between fields.
Video time: 5m 55s
Create a form and combo box for easy data entry and storing numbers for foreign keys.
Video time: 6m 33s
Modify the form created in the previous lesson, set properties and add controls.
Video time: 6m 09s
Make great looking forms by changing colors, creating a close button and sorting or filtering columns.
Video time: 7m 11s
Create a query from scratch to line up data for a report that is grouped by something.
Video time: 7m 05s
Import objects from Access and manage Trust Center settings.
Video time: 7m 08s
Import data from Excel spreadsheets into tables in Access.
Video time: 6m 22s
Further explore the Navigation Pane and learn how to use a query to calculate data.
Video time: 7m 26s
The Navigation Pane is an area on the left side of the database that enables you to open and change the design of objects.
Video time: 5m 01s
Overview of the Access objects covered so far. The main object types are Tables, Queries, Forms, Reports, Macros, and Modules.
Video time: 5m 17s
Recognize the different Number Data Types. The actual Data Type of a Number is specified by the Field Size property.
Video time: 6m 04s
Learn about Short Text and Long Text Data Types and how to change the Data Type of a field.
Video time: 6m 58s
Change the format of a Currency field and define the currency symbol in Windows Region settings.
Video time: 4m 32s
Best practices for using the Yes/No Data Type, which can be displayed as a check box to show when something is active.
Video time: 6m 00s
Date/Time is an important, but problematic, data type. Recognize Date/Time functions and formats and how to enter them into fields.
Video time: 5m 22s
A review of Simple, Special and Complex Data Types.
Video time: 13m 06s
Learn how to lay out the Relationships Diagram to see what you have in the database.
Video time: 7m 30s
Add a subform to a main form and store when a record was changed in a Date/Time field.
Video time: 8m 22s
Customize the Quick Access Toolbar (QAT) for form and report design.
Video time: 4m 15s
Create a complex query to be used as the source for a grouped report.
Video time: 7m 28s
Learn how to create a new report and fix a broken report.
Video time: 7m 58s
Create a report from scratch using Report Design, add field to Record Source and align controls.
Video time: 8m 11s
Learn how to add grouping and sorting to a report to order information.
Video time: 5m 44s
Learn how to change report Record Source to show all records.
Video time: 3m 48s
Identify how to switch between different views such as Report View, Design View, Layout View and Print Preview.
Video time: 3m 36s
Learn calculation to Sum Field in Group Footer/Header, Page Header/Footer, or Report Header/Footer and calculation to get percent of a total in another control.
Video time: 17m 01s
Identify Page Setup options and learn how to force a new page between sections of a second grouping.
Video time: 8m 24s
Choose and customize themes for forms, animate Command Buttons and define an alternate back color so that rows will display in alternating colors.
Video time: 5m 16s
Define a Running Sum, hide duplicate information and copy formats with the Format Painter.
Video time: 8m 13s
Learn how to Repeat Section on the next page so you can see the group value that detail continues from, and use VBA to add a Continued label to group header on a report.
Video time: 11m 59s
Change sort to group using the Group Sort and Total pane, and change the Default View of a report to Print Preview.
Video time: 6m 02s
Learn how to hide sections and controls on a report, such as key fields, when you don't want them to show.
Video time: 3m 29s
Create a textbox to show the date and time a report was printed, page number, and total pages at the top of each page.
Video time: 12m 57s
Create a form to use as a Main Menu and make a command button to open a form using a macro.
Video time: 7m 40s
Create a command button to open a report using a macro or VBA and create a Combo Box using the wizard to show Customers and Store CustID.
Video time: 7m 35s
Use criteria from a Form Control when opening a report with VBA.
Video time: 9m 34s
Use multiple criteria from Form Controls when opening a report.
Video time: 9m 05s
Create a command button to open a table or query and make it the Startup form when the database opens.
Video time: 6m 54s
Add logo to Main Menu Form and review what has been covered in the course.
Video time: 8m 47s
Share this course
Start a tour to see how the lessons work
or dive right into your course. You can always access the tour at a later time.
How is your GoSkills experience?
Your feedback has been sent
© 2020 GoSkills Ltd. Skills for career advancement