Microsoft Access: Database Creation and Management through Microsoft Access
()
About this ebook
It also contains Microsoft Access multiple choice question and answers that will be of great help to you. These are what you will learn:
*Database Terminologies
*Relationships in Relational Database
*Database Application Areas
*Starting and Exiting Microsoft Access
*Microsoft Access Data Types
*Creating a Database Using Datasheet View
*Creating a Database Using Form Wizard
"Basic Operations You Can Perform On Access Database.
*Microsoft Access Shortcut Keys
Read more from Steven Bright
Biogas Plant: Biogas Digester Design, Gas Production and Purification Rating: 0 out of 5 stars0 ratingsSPSS: The Ultimate Data Analysis Tool Rating: 5 out of 5 stars5/5Web Design and Development: Website Technologies Fundamentals Rating: 0 out of 5 stars0 ratingsComputer for Kids: Input, Output and Storage Devices Rating: 0 out of 5 stars0 ratingsStage Event Lighting Fundamentals: Event Lighting Setup and Control Rating: 0 out of 5 stars0 ratingsComputer for Kids: A Comprehensive Guide Rating: 0 out of 5 stars0 ratingsTools and Function Lists: Engineering Tools Manual Rating: 0 out of 5 stars0 ratingsMicrosoft Access: Database Creation and Management through Microsoft Access Rating: 0 out of 5 stars0 ratingsComputer for Kids: The Fundamentals Rating: 0 out of 5 stars0 ratingsExcel VBA Programming: Automating Excel through Visual Basic for Application Rating: 0 out of 5 stars0 ratingsMicrosoft Excel: Microsoft Excel User Interface, Excel Basics, Function, Database, Financial Analysis, Matrix, Statistical Analysis Rating: 0 out of 5 stars0 ratingsComputer for Kids: History of Computer Rating: 0 out of 5 stars0 ratingsMicrosoft Office Productivity Pack: Microsoft Excel, Microsoft Word, and Microsoft PowerPoint Rating: 0 out of 5 stars0 ratingsPhotoshop Manual: Introduction to Photoshop Rating: 0 out of 5 stars0 ratingsHypertext Markup Language (HTML) Fundamentals: How to Master HTML with Ease Rating: 0 out of 5 stars0 ratingsPhotoshop Fundamentals: Advance Photoshop Rating: 0 out of 5 stars0 ratingsComputer for Kids: The Operating System Rating: 0 out of 5 stars0 ratings
Related to Microsoft Access
Related ebooks
Advance Excel 2016: Training guide Rating: 0 out of 5 stars0 ratingsMicrosoft Access: Database Creation and Management through Microsoft Access Rating: 0 out of 5 stars0 ratingsExcel 2019 – Business Basics & Beyond Rating: 0 out of 5 stars0 ratingsExcel 101: A Beginner's Guide for Mastering the Quintessence of Excel 2010-2019 in no time! Rating: 0 out of 5 stars0 ratingsAccess Essentials: Access Essentials Rating: 0 out of 5 stars0 ratingsIntermediate Access: Access Essentials, #2 Rating: 0 out of 5 stars0 ratingsAccess Essentials 2019 Rating: 0 out of 5 stars0 ratingsSQL Programming & Database Management For Noobee Rating: 0 out of 5 stars0 ratingsMicrosoft Word Advanced Techniques for Productivity and Automation Rating: 0 out of 5 stars0 ratingsAccess for Beginners: Access Essentials, #1 Rating: 0 out of 5 stars0 ratingsEXCEL: Microsoft: Boost Your Productivity Quickly! Learn Excel, Spreadsheets, Formulas, Shortcuts, & Macros Rating: 0 out of 5 stars0 ratingsMs Access 2007: Step by Step Rating: 5 out of 5 stars5/5Exploring Data with Access 2019 Rating: 0 out of 5 stars0 ratingsMicrosoft Access 2003 Rating: 5 out of 5 stars5/5Excel Pivot Tables & Charts Rating: 0 out of 5 stars0 ratingsMicrosoft Office 365 for Business Rating: 4 out of 5 stars4/5Microsoft Office Excel 2013 New Features and Power Tips Rating: 0 out of 5 stars0 ratingsAccess 2016: Up To Speed Rating: 5 out of 5 stars5/5Access 2019 Beginner: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsMastering Microsoft Excel 2016: How to Master Microsoft Excel 2016 in 30 days Rating: 5 out of 5 stars5/5Access 2019 Intermediate: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsSPSS: The Ultimate Data Analysis Tool Rating: 0 out of 5 stars0 ratingsAdvanced Analytics with Excel 2019: Perform Data Analysis Using Excel’s Most Popular Features Rating: 4 out of 5 stars4/5Excel 2003 Power Programming with VBA Rating: 5 out of 5 stars5/5Pivot Tables for everyone. From simple tables to Power-Pivot: Useful guide for creating Pivot Tables in Excel Rating: 0 out of 5 stars0 ratingsExcel VBA 24-Hour Trainer Rating: 3 out of 5 stars3/5Excel VBA Programming: Task Optimization and Daily Work Automation Rating: 0 out of 5 stars0 ratingsExcel Programming with VBA Starter Rating: 0 out of 5 stars0 ratingsExcel 2016 All-in-One For Dummies Rating: 3 out of 5 stars3/5
Computers For You
Mastering ChatGPT: 21 Prompts Templates for Effortless Writing Rating: 5 out of 5 stars5/5Procreate for Beginners: Introduction to Procreate for Drawing and Illustrating on the iPad Rating: 0 out of 5 stars0 ratingsElon Musk Rating: 4 out of 5 stars4/5The Mega Box: The Ultimate Guide to the Best Free Resources on the Internet Rating: 4 out of 5 stars4/5ChatGPT Ultimate User Guide - How to Make Money Online Faster and More Precise Using AI Technology Rating: 0 out of 5 stars0 ratingsThe ChatGPT Millionaire Handbook: Make Money Online With the Power of AI Technology Rating: 0 out of 5 stars0 ratingsThe Best Hacking Tricks for Beginners Rating: 4 out of 5 stars4/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Deep Search: How to Explore the Internet More Effectively Rating: 5 out of 5 stars5/5How to Create Cpn Numbers the Right way: A Step by Step Guide to Creating cpn Numbers Legally Rating: 4 out of 5 stars4/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us About Who We Really Are Rating: 4 out of 5 stars4/5Practical Lock Picking: A Physical Penetration Tester's Training Guide Rating: 5 out of 5 stars5/5People Skills for Analytical Thinkers Rating: 5 out of 5 stars5/5Slenderman: Online Obsession, Mental Illness, and the Violent Crime of Two Midwestern Girls Rating: 4 out of 5 stars4/5CompTIA Security+ Practice Questions Rating: 2 out of 5 stars2/5The Designer's Web Handbook: What You Need to Know to Create for the Web Rating: 0 out of 5 stars0 ratingsLearning the Chess Openings Rating: 5 out of 5 stars5/5The Professional Voiceover Handbook: Voiceover training, #1 Rating: 5 out of 5 stars5/5Web Designer's Idea Book, Volume 4: Inspiration from the Best Web Design Trends, Themes and Styles Rating: 4 out of 5 stars4/5CompTIA IT Fundamentals (ITF+) Study Guide: Exam FC0-U61 Rating: 0 out of 5 stars0 ratingsRemote/WebCam Notarization : Basic Understanding Rating: 3 out of 5 stars3/5Ultimate Guide to Mastering Command Blocks!: Minecraft Keys to Unlocking Secret Commands Rating: 5 out of 5 stars5/5101 Awesome Builds: Minecraft® Secrets from the World's Greatest Crafters Rating: 4 out of 5 stars4/5
Reviews for Microsoft Access
0 ratings0 reviews
Book preview
Microsoft Access - Steven Bright
Author
INTRODUCTION
A database is the collection of data organized in such a way that allows access, retrieval, and use of the data. The organization of data is done through the use of table called database table. A row in the table is called a record while a column is called a field.
Microsoft Access is one of the most commonly used database packages or Database Management System (DBMS) used in the creation and management of database others being Oracle, and FoxBASE.
Microsoft Access is a Relational database package that is it is structured to recognize relations between stored items of information. The characteristics of relational database are listed below.
Data is organized in table format.
A column represents a field.
A row represents a record.
Tables can be related.
DATABASE TERMINOLOGIES
There are many important terms used in database. The following are some of the common ones and their meaning.
Field or Data item: This is an item of data in a record. It is made up of characters and it describes the attributes of a person, object or event. These attributes includes Name, Address, Height, Age, Gender. Occupation, etc.
Record: This is a collection of related fields about a person or event in a database.
File: This is a collection of related records in a database.
Primary Key: This is the unique field through which a record can be accessed in a database.
Foreign Key: This is a field in one table that is a primary key in another database table.
Database: This is a collection of related files.
Relational Model: This is a Relational Database Management System (RDBMS) that is based on the relational model (related by the primary keys).
Constraints: These are rules enforced on data columns on database table. They are used to limit the type of data that can go into a table and this ensures the reliability of the data in the database.
SQL: This stands for Structured Query Language which is a computer language for creating, storing, manipulating, and retrieving data stored in relational database. All relational database management systems like Microsoft Access, MySQL, Oracle, and SQL Server uses SQL as standard database Language.
Database Object: This is a data structure used to store or reference data in a database. Examples of Microsoft Access objects are Table, Form, Query, Modules, Macros, and Report.
RELATIONSHIPS IN RELATIONAL DATABASE
There are three main types of relationships in relational database i.e. One to One
, One to Many
and Many to Many
. These relationships imply that the data in one table is related to the data in another table(s).
One to One
In One to One
relationship, each record in one table has at most one related record in another table. For example, in a One to One
relationship each record in Table1 can have only one matching record in Table 2, and each record in Table 2 can have only one matching record in Table 1. This relationship is mostly used to divide a table with