MS Access Flashcards
It is a RDBMS and a complete application development environment. Unlike other RDBMS’s, It also includes the tools you need to develop user-friendly interfaces and reports.
Microsoft Access 2013
It stores its objects in a single file with the .accdb file name extension.
Access 2013 database
It stores information. Tables are the heart of any database, and you can create as many tables as you need to store different types of information.
Tables
It lets you quickly perform an action on a table. Usually, this action involves retrieving a choice bit of information.
Queries
These are attractive windows that you create, arrange, and colorize.
Forms
It provides an easy way to view or change the information in a table.
Forms
It helps you print some or all of the information in a table.
Reports
These are mini-programs that automate custom tasks. Macros are a simple way to get custom results without becoming a programmer.
Macros
These are files that contain Visual Basic code. You can use this code to do just about anything—from updating 10,000 records to firing off an email.
Modules
.accdb
Access database
A panel of command buttons and icons organized into sets of tabs. The BLANK appears across the top of the program window. Each tab on the ribbon contains groups of commands related to specific database tasks.
Ribbon
A pane on the left side of the program window that displays database objects
Navigation Pane
A collection of options on the File tab of the ribbon.
Backstage view
You can customize a table in two ways:
- Design View
- Datasheet View