While Microsoft Access is made up of seven components, this text will focus on the main objects: tables, forms, queries and reports. Together, these objects allow users to enter, store, analyze and compile data in various ways. When an Access database is opened, the objects are illustrated in the Navigation Pane on the left side of the window. The standard view in the Navigation Pane displays all objects in the database organized by object type. The Navigation Pane is used to run, open, and manage the objects of a database.
Double-clicking an object will open the object in a document window. A table is the database object that stores data organized in an arrangement of columns and rows. Each row is a record and each column is a field within each record. A record is all of the data pertaining to a person, place, thing or event. Each record will have one or more fields and every database must have at least one table. A relational database must have more than
one table. The other three objects are typically based off of the tables, so take the time to set up the tables correctly, the first time! A form object is typically used for entering new records into a table, or edit/deleting/display existing records in a table. Forms are the primary interface that most users of a database enter and display data. A query object retrieves specific data from other database objects and then displays only the data that the
user specifies. Queries are the equivalent of asking questions about the data. The report object summarizes the records from a table or query into an easy-to-read format suitable for printing or exporting to other software programs. Access objects have several views. Each view gives users different perspectives and offer different functionality. The two most important views are Datasheet view and Design view. Datasheet view displays a table in a datasheet where fields are in columns and records are in rows.  This view is useful for comparing records and is often used when sorting or filtering data. This view is also practical for printing data since many of the records can fit on a single sheet of paper. Records can be added in datasheet view, but forms are a more typical object for data entry. Nonetheless, the asterisk (*) that appears to the left of the row below the last record indicates where a new record will appear. The grey box to the left of each record is a record selector. Clicking a record selector will make the record active. Right-clicking the record selector will allow users to delete the selector record or add a new record to the table. Design view allows users to setup and edit the fields in an object. Microsoft Access is designed to help its users connect with Microsoft databases at the back end and help them manage and store their data efficiently. Using MS Access has been extremely helpful to many enterprises since they can manage and access their data in a more user-friendly manner. MS Access has four entities that help people to have hassle-free work. These entities are called objects. In brief, objects are the collection of tools supported by MS access that helps the users get their job done. There are four types of objects in MS access: 1. Tables– Tables are the places where any information is stored. The most basic work of any database is to store useful information, and tables are meant for that purpose. Tables don’t perform any other operations but simply store the data that would be used later for other useful operations. Below is an example of what an MS access table looks like: 2. QUERIES- Queries are statements asking the software to conduct a detailed search from the database. Consider the example of a library having at least 1000 books. Now, there would be a database where all the relevant information of those books is stored. You don’t have to search the whole database to get that book’s information if you need a particular book. Instead, you could simply write a query statement that will fetch all the information about the book you are looking for. Queries are very helpful when it comes to extracting only useful pieces of information from a heap of data. Below is an example of an MS Access query. 3. FORMS– Forms display data from your table itself and help perform the necessary tasks. Forms are basically an easy way to guide people using the software to perform various operations like sorting, adding, displaying in a more presentable manner, and so on. Whatever you do in a form, you are actually doing it on the table itself. You can directly do it from the table also. Still, the main challenge in doing so is if your data set is of a very large size, then it might be a problem for you to delete the non-useful data by finding it from the whole table and tracing out the useful columns for performing the important operations. Below is an example of what a form looks like- 4. REPORTS- Reports are static, easy to understand, and easy on the eyes documents, which are presentable and portable. Colors can be added to it, and it & will help in better managing the data that we need to present to someone. Reports are the objects which help in showcasing a particular section in order to highlight the important section. It’s more of an on-paper presentation of data. Below is an example of a report of data. 5. MACROS– Macros in MS access are used for automation purposes. It can automate tasks like opening forms, querying, changing values, or even running other macros. It helps in adding functionality to your forms, reports, and controls. This helps in improving efficiency when using the database. If you need to manage the data well, then coordination of all four entities is required. If you consider the case of a book directory in a library, then the place where all the information of books is stored is called tables. If you want to search for a particular book, then the search command is the query, the place where you put your search criterion in the form, and last but not least, the result that the query has produced can be represented in a portable format as a report. Which of the following is not an object used in a database?Answer: Queries, reports and tables are all related to database and relationships are not the database object and it is related to functions in mathyematics.
Which access object contains all of the data in the database?Tables contain all of the raw data in the database. Access information can be printed from forms, queries, and tables.
What forms the basis for all other database objects?Records and fields form the basis of all databases. A simple table gives us the clearest picture of how records and fields work together in a database storage project.
Which of the following is used to find data in a database?Queries. Queries can perform many different functions in a database. Their most common function is to retrieve specific data from the tables.
|
An Access database uses five main components database objects which is not one of them
zusammenhängende Posts
Urheberrechte © © 2024 paraquee Inc.
