Join our newsletter today for free
Get all these courses for only $39/month
An introduction to Microsoft Access.
Video time: 6m 28s
Enter a new record into a table and move between fields.
Video time: 5m 49s
Create a form and combo box for easy data entry and storing numbers for foreign keys.
Video time: 6m 27s
Modify the form created in the previous lesson, set properties and add controls.
Video time: 6m 03s
Make great looking forms by changing colors, creating a close button and sorting or filtering columns.
Video time: 7m 05s
Create a query from scratch to line up data for a report that is grouped by something.
Video time: 6m 59s
Import objects from Access and manage Trust Center settings.
Video time: 7m 02s
Import data from Excel spreadsheets into tables in Access.
Video time: 6m 16s
Further explore the Navigation Pane and learn how to use a query to calculate data.
Video time: 7m 20s
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: 4m 55s
Overview of the Access objects covered so far. The main object types are Tables, Queries, Forms, Reports, Macros, and Modules.
Video time: 5m 11s
Recognize the different Number Data Types. The actual Data Type of a Number is specified by the Field Size property.
Video time: 5m 58s
Learn about Short Text and Long Text Data Types and how to change the Data Type of a field.
Video time: 6m 51s
Change the format of a Currency field and define the currency symbol in Windows Region settings.
Video time: 4m 26s
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: 5m 54s
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 16s
A review of Simple, Special and Complex Data Types.
Video time: 13m 00s
Learn how to lay out the Relationships Diagram to see what you have in the database.
Video time: 7m 24s
Add a subform to a main form and store when a record was changed in a Date/Time field.
Video time: 8m 16s
Customize the Quick Access Toolbar (QAT) for form and report design.
Video time: 4m 09s
Create a complex query to be used as the source for a grouped report.
Video time: 7m 22s
Learn how to create a new report and fix a broken report.
Video time: 7m 52s
Create a report from scratch using Report Design, add field to Record Source and align controls.
Video time: 8m 05s
Learn how to add grouping and sorting to a report to order information.
Video time: 5m 38s
Learn how to change report Record Source to show all records.
Video time: 3m 42s
Identify how to switch between different views such as Report View, Design View, Layout View and Print Preview.
Video time: 3m 30s
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: 16m 55s
Identify Page Setup options and learn how to force a new page between sections of a second grouping.
Video time: 8m 18s
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 10s
Define a Running Sum, hide duplicate information and copy formats with the Format Painter.
Video time: 8m 07s
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 53s
Change sort to group using the Group Sort and Total pane, and change the Default View of a report to Print Preview.
Video time: 5m 56s
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 23s
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 51s
Create a form to use as a Main Menu and make a command button to open a form using a macro.
Video time: 7m 34s
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 29s
Use criteria from a Form Control when opening a report with VBA.
Video time: 9m 28s
Use multiple criteria from Form Controls when opening a report.
Video time: 8m 59s
Create a command button to open a table or query and make it the Startup form when the database opens.
Video time: 6m 48s
Add logo to Main Menu Form and review what has been covered in the course.
Video time: 8m 41s
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.
© 2018 GoSkills Ltd. Skills for career advancement