On Demand Webinar
Webinar Details $219
- Webinar Length: 100 Minutes
- Guest Speaker: Mike Thomas
- Topic: Business Administration, Business Skills, Finance, Software, Taxation and Accounting
- Credit: CPE 2.0
-
A relational database application such as Access can help you and your organization collect and manage large amounts of data. You can use it as a personal data management tool, or you can use it as a construction set to develop applications for an entire department or organization.
In this training you will learn the fundamental skills required to design and build a database using Microsoft Access. This session covers database terminology, building tables and the relationships between them, creating queries and creating a simple data-entry form.
Why you should attend:
If you need to create databases in Access, having a good understanding and working knowledge of how to construct Tables and Queries is the critical first step.
Topics covered:
- Database terminology
- Building a database: Flat File v Relational
- Creating Tables
- Field types
- Entering and editing data
- Modifying a Table structure
- Creating a basic Query
- Selecting records using criteria (simple and complex)
- Creating a simple data-entry Form
Who should attend:
This training is classed as introductory level. It is aimed at new users of Access who need to learn how to create a database. No prior knowledge of Access is required.
The training will be delivered using the latest version of Access although much of the functionality is available in earlier versions of the application.
- Introduction
- What Is Microsoft Access? 00:02:25
- Source File - Headings 00:03:46
- Starting Microsoft Access 00:07:39
- Creating a New Database 00:07:47
- Creating A New Table From Scratch 00:16:41
- Viewing Or Making Changes To An Existing Table Structure 00:27:08
- Adding A Column 00:37:53
- Changing An Employee Location 00:40:01
- Linking Two Tables Together 00:42:15
- Deleting A Field Directly From Table View 00:45:13
- Deleting A Table 00:47:24
- Forms 00:48:00
- How To Create A Drop-Down List On The Form 01:03:52
- Creating Calculations In A Form 01:06:24
- Queries 01:11:34
- Saving A Query As A New Table 01:23:34
- How To Create A Query That Shows Hire Date, Not Including Employees Who Have Left 01:26:46
- Parameters 01:31:06
- Creating Queries From Multiple Tables 01:35:28
- How To Append Data To Table 01:39:05
- Speaker Closing 01:40:48
- Presentation Closing 01:41:05
- .accdb 00:09:07
- Column 00:05:23, 00:06:34, 00:09:45, 00:13:10, 00:37:51, 00:43:47, 01:10:36, 01:37:45
- Column Headings 00:07:06, 00:09:21, 00:11:11, 00:38:39
- Formula 01:09:36
- Microsoft Access 00:01:18, 00:06:07, 00:07:42
- Parameter 01:31:06
- Primary Key 00:11:29, 00:22:48
- Query 01:11:38, 01:13:22, 01:16:52, 01:19:20, 01:25:10, 01:32:38
- Row 00:07:39, 00:11:14, 00:17:03, 00:25:11, 00:36:30, 00:55:06
- Table 00:09:16, 00:10:38, 00:12:50, 00:16:40, 00:40:59, 00:47:25, 00:52:46, 01:11:43
- TextBox 01:09:15
- VBA - Visual Basic for Applications 01:00:21
- Worksheet 00:10:45
.accdb: The default Access file format is .accdb. The .accdb file format supports a number of newer features, such as calculated fields and attachments.
Column: A column is a vertical series of cells in a chart, table, or spreadsheet in Excel.
Column Headings : The column heading or column header is the gray-colored row containing the letters (A, B, C, etc.) used to identify each column in the worksheet. The column header is located above row 1 in the worksheet.
Formula: A formula is an expression which calculates the value of a cell.
Microsoft Access: Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is used to store large amounts of data in an organized and efficient manner. It allows you to create tables, forms, queries, and reports to manage your data.
Parameter: A parameter is a piece of information you supply to a query right as you run it. Parameters can be used by themselves or as part of a larger expression to form a criterion in the query. You can add parameters to any of the following types of queries: Select. Crosstab.
Primary Key: A primary key is a field or set of fields with values that are unique throughout a table. Values of the key can be used to refer to entire records, because each record has a different value for the key. Each table can only have one primary key.
Query: A database query extracts data from a database and formats it in a readable form. A query must be written in the language the database requires; usually, that language is Structured Query Language (SQL). For example, when you want data from a database, you use a query to request that specific information.
Row: A row is the range of cells that go across (horizontal) the spreadsheet/worksheet. Rows are identified by numbers e.g. row 1, row 5. Examples of use. A row might contain the headings of a table e.g. product ID, product name, price, number sold.
Table: A table is an arrangement of data in rows and columns, or possibly in a more complex structure. Tables are widely used in communication, research, and data analysis. Tables appear in print media, handwritten notes, computer software, architectural ornamentation, traffic signs, and many other places.
TextBox : Textboxes are used in worksheets or userforms to display information or to allow the user to input information.
VBA - Visual Basic for Applications : Visual Basic for Applications is a computer programming language developed and owned by Microsoft. With VBA you can create macros to automate repetitive word- and data-processing functions, and generate custom forms, graphs, and reports. VBA functions within MS Office applications; it is not a stand-alone product.
Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.
