Access 2013 Essential Training with Adam Wilbert
Join author and database expert Adam Wilbert on a tour of the essential features of Microsoft Access 2013 and discover how to build a database and store your data more efficiently. First, Adam explains the concepts behind relational databases, before moving onto 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; build an interface for the database from forms, complete with interactive buttons and combo boxes; create reports for printing and sharing; and automate these tasks and many others with macros.
Understanding table structures and relationshipsSetting primary and foreign keysEstablishing relationships and maintaining referential integritySorting and filtering dataBuilding queries with constraints and criteriaEditing table data with queriesGenerating forms from tablesAdding form controlsCreating reports with totals and labelsEmbedding macros in buttonsRepairing your databaseProtecting databases with passwords
Business, Computer Skills (Windows), Databases
Access, Office, Office 365
Kujiunga na mwandishi na mtaalam wa hifadhidata Adam Wilbert kwenye ziara ya vipengele muhimu vya Microsoft Access 2013 na kugundua jinsi ya kujenga hifadhidata na kuhifadhi data yako kwa ufanisi zaidi. Kwanza, Adam anaelezea dhana nyuma ya database uhusiano, kabla ya kuhamia juu ya kujenga meza - msingi wa database yoyote. Kisha anaonyesha jinsi ya kufafanua mahusiano kati ya meza na kutumia maswali ya kupata na kuchuja data. Mafunzo pia kuonyesha jinsi ya kutumia sheria na uthibitisho wa kupunguza makosa ya kuingia data; kujenga interface kwa ajili ya database kutoka fomu, kamili na vifungo maingiliano na combo masanduku; kuunda ripoti kwa ajili ya kuchapisha na kushiriki; na automatize kazi hizi na wengine wengi na macros. Kuelewa muundo wa meza na mahusiano: Kuanzisha uhusiano na kudumisha uadilifu wa kumbukumbu: Kupanga na kuchuja data: Kuunda maswali na vikwazo na vigezo: Kuunda data ya meza na maswali: Kuunda fomu kutoka kwa meza: Kuongeza fomu: Kuunda ripoti na jumla na vitambulisho: Kuingiza macros katika vifungo: Kurekebisha hifadhidata yako: Kulinda hifadhidata na nywila: Office 365