Introduction to Microsoft Access.
In this lesson, we will learn about Microsoft Access. Access is Database program. The database is a collection of records and record is a collection of fields.
Key database concepts.
What is an Access Database?
An Access database provides all of the tools for:
- Efficiently moving data in or out.
- Maintain the validity and consistency of the data.
- Performing analysis.
An Access database provides all of the tools for:
- Generating statistics.
- Creating organized reports.
- Automating repetitive tasks.
1 Tables.
Store data organized into records (rows) and fields (columns).
2 Queries.
Gather records for analysis or further processing.
3 Forms.
Interact with your database and allow data entry.
4 Reports.
Prepare data for export or printing.
5 Macro.
Automate processes and control interactivity.
Object Views.
Data-Oriented Views for interacting with the data.
- Datasheet view.
- Form view.
- Report view.
- Print preview.
Structure-oriented views for creating functionality.
- Design view.
- Layout view.
- SQL view.
Launching Microsoft Access and the backstage screen.
Creating the database file.
Understanding the Trust Center.
Digging into Ribbon tabs.
Backstage View:
Save as. (To give a name to the database.)
Save.(Update or save the work into the database.)
Close.(close the database.)
Open.(open the database.)
Collapse the Ribbon.
Pin the Ribbon.
Using the Navigation pane.
Using the Tell Me feature.
The tell me search box is the new feature of office suite makes it easy to find out commands.
You can type any command in the box.
Example:
Query Design.
Using the Quick Access Toolbar
At the very top of the interface, above the ribbon tab appears, is a grouping of icons, collectively refer to as a quick access toolbar. This is the easy place to shortcut you use most often. By default quick access toolbar includes a save button, undo, and redo.
For adding additional commands you can click on little arrow button and for adding more commands click on more commands option.
Signing into a Microsoft account.
If you have Microsoft account then signing in Access, allowing you to easy way share your databases through your OneDrive folder as soon as allowing you to sync across to the other computer might use.
In order to sign your account.
File.
Making backups.
Access is the one of the only Program in Office suite that does not have the feature of Auto Recovery option. When program crash or unexpected shutdown. Because of this, you want to make sure backing up your databases on regular basis lucky access may create backup absolutely no reason not protect you and your data.
In order to create your backup.
File
Accessing Access help
If you find yourself need help you might consider Access built-in help system.
Type any query.
Suppose type here a query like delete query.
Help window stays on screen.