Office 365: Access Essential Training with Adam Wilbert (2015)
Office 365: Access Essential Training with Adam Wilbert (2015)
MP4 | AVC 148kbps | English | 1280x720 | 15ps | 5h 04mins | AAC stereo 128kbps | 622 MB
Genre: Video Training
oin author and database expert Adam Wilbert on a tour of the essential features of Microsoft Access 2013, the database application included with every Office 365 subscription, and discover how to store, organize, and access your data more efficiently. First, Adam explains the concepts behind relational databases, before moving on to building tables—the foundation of any database. He then shows how to define the relationships between tables and use queries to find and filter data. The course also shows how to apply rules and validation to minimize data-entry errors; use forms to build a database interface complete with interactive buttons and combo boxes; create reports for printing and sharing; and automate these tasks, and many others, with macros.
Topics include:
Understanding table structures and relationships
Setting primary and foreign keys
Establishing relationships and maintaining referential integrity
Sorting and filtering data
Building queries with constraints and criteria
Editing table data with queries
Generating forms from tables
Adding form controls
Creating reports with totals and labels
Embedding macros in buttons
Repairing your database
Protecting databases with passwords
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 10.8 MiB
Duration : 5mn 23s
Overall bit rate : 280 Kbps
Encoded date : UTC 2015-01-27 15:14:47
Tagged date : UTC 2015-01-27 15:14:47
Video #1
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 5 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 5mn 23s
Bit rate : 148 Kbps
Maximum bit rate : 1 922 Kbps
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.011
Stream size : 5.68 MiB (53%)
Title : Telestream Inc. Dib Library - ReleaseVantage 2014.59.138974
Writing library : x264 core 129
Encoding settings : cabac=1 / ref=5 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=7 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=14 / lookahead_threads=2 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=1 / b_pyramid=0 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=150 / keyint_min=15 / scenecut=60 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=23.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=672 / vbv_bufsize=6720 / crf_max=0.0 / nal_hrd=none / ip_ratio=3.00 / aq=1:1.00
Language : English
Encoded date : UTC 2015-01-27 15:14:47
Tagged date : UTC 2015-01-27 15:14:47
Audio #2
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 5mn 23s
Bit rate mode : Constant
Bit rate : 128 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 48.0 KHz
Compression mode : Lossy
Stream size : 4.93 MiB (46%)
Title : Telestream Inc. Dib Library - ReleaseVantage 2014.59.138974
Language : English
Encoded date : UTC 2015-01-27 15:14:47
Tagged date : UTC 2015-01-27 15:14:47
Office 365: Access Essential Training with Adam Wilbert (2015)
Office 365: Access Essential Training with Adam Wilbert (2015)
Office 365: Access Essential Training with Adam Wilbert (2015)
No mirrors please