Home Database Mysql Tutorial Access入门教程7.6补充内容[1]

Access入门教程7.6补充内容[1]

Jun 07, 2016 pm 04:02 PM
access Getting Started Tutorial content data

补充一 各种数据类型的含义和使用方法 在表的设计视图中 每一个字段都有设计类型 Access允许九种数据类型 文本 备注 数值 日期/时间 货币 自动编号 是/否 OLE对象 超级链接 查询向导 文本 这种类型允许最大 个字符或数字 Access默认的大小是 个字符 而且系统

    补充一各种数据类型的含义和使用方法

    在表的设计视图中每一个字段都有设计类型Access允许九种数据类型文本备注数值日期/时间货币自动编号是/否OLE对象超级链接查询向导

    文本这种类型允许最大个字符或数字Access默认的大小是个字符而且系统只保存输入到字段中的字符而不保存文本字段中未用位置上的空字符可以设置字段大小属性控制可输入的最大字符长度

    备注这种类型用来保存长度较长的文本及数字它允许字段能够存储长达个字符的内容但Access不能对备注字段进行排序或索引却可以对文本字段进行排序和索引在备注字段中虽然可以搜索文本但却不如在有索引的文本字段中搜索得快

    数字这种字段类型可以用来存储进行算术计算的数字数据用户还可以设置字段大小属性定义一个特定的数字类型任何指定为数字数据类型的字型可以设置成字节整数长整数单精度数双精度数同步复制ID小数五种类型在Access中通常默认为双精度数

    日期/时间这种类型是用来存储日期时间或日期时间一起的每个日期/时间字段需要个字节来存储空间

    货币这种类型是数字数据类型的特殊类型等价于具有双精度属性的数字字段类型向货币字段输入数据时不必键入人民币符号和千位处的逗号Access会自动显示人民币符号和逗号并添加两位小数到货币字段当小数部分多于两位时Access会对数据进行四舍五入精确度为小数点左方位数及右方位数

    自动编号这种类型较为特殊每次向表格添加新记录时Access会自动插入唯一顺序或者随机编号即在自动编号字段中指定某一数值自动编号一旦被指定就会永久地与记录连接如果删除了表格中含有自动编号字段的一个记录后Access并不会为表格自动编号字段重新编号当添加某一记录时Access不再使用已被删除的自动编号字段的数值而是重新按递增的规律重新赋值

    是/否这种字段是针对于某一字段中只包含两个不同的可选值而设立的字段通过是/否数据类型的格式特性用户可以对是/否字段进行选择

    OLE对象这个字段是指字段允许单独地链接嵌入OLE对象添加数据到OLE对象字段时可以链接或嵌入Access表中的OLE对象是指在其他使用OLE协议程序创建的对象例如WORD文档EXCEL电子表格图像声音或其他二进制数据OLE对象字段最大可为GB它主要受磁盘空间限制

    超级链接这个字段主要是用来保存超级链接的包含作为超级链接地址的文本或以文本形式存储的字符与数字的组合当单击一个超级链接时WEB浏览器或Access将根据超级链接地址到达指定的目标超级链接最多可包含三部分一是在字段或控件中显示的文本二是到文件或页面的路径三是在文件或页面中的地址在这个字段或控件中插入超级链接地址最简单的方法就是在插入菜单中单击超级链接命令

    查阅向导这个字段类型为用户提供了一个建立字段内容的列表可以在列表中选择所列内容作为添入字段的内容

[]  []  

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
Will R.E.P.O. Have Crossplay?
1 months ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to convert deepseek pdf How to convert deepseek pdf Feb 19, 2025 pm 05:24 PM

DeepSeek cannot convert files directly to PDF. Depending on the file type, you can use different methods: Common documents (Word, Excel, PowerPoint): Use Microsoft Office, LibreOffice and other software to export as PDF. Image: Save as PDF using image viewer or image processing software. Web pages: Use the browser's "Print into PDF" function or the dedicated web page to PDF tool. Uncommon formats: Find the right converter and convert it to PDF. It is crucial to choose the right tools and develop a plan based on the actual situation.

How to read dbf file in oracle How to read dbf file in oracle May 10, 2024 am 01:27 AM

Oracle can read dbf files through the following steps: create an external table and reference the dbf file; query the external table to retrieve data; import the data into the Oracle table.

AI startups collectively switched jobs to OpenAI, and the security team regrouped after Ilya left! AI startups collectively switched jobs to OpenAI, and the security team regrouped after Ilya left! Jun 08, 2024 pm 01:00 PM

Last week, amid the internal wave of resignations and external criticism, OpenAI was plagued by internal and external troubles: - The infringement of the widow sister sparked global heated discussions - Employees signing "overlord clauses" were exposed one after another - Netizens listed Ultraman's "seven deadly sins" Rumors refuting: According to leaked information and documents obtained by Vox, OpenAI’s senior leadership, including Altman, was well aware of these equity recovery provisions and signed off on them. In addition, there is a serious and urgent issue facing OpenAI - AI safety. The recent departures of five security-related employees, including two of its most prominent employees, and the dissolution of the "Super Alignment" team have once again put OpenAI's security issues in the spotlight. Fortune magazine reported that OpenA

70B model generates 1,000 tokens in seconds, code rewriting surpasses GPT-4o, from the Cursor team, a code artifact invested by OpenAI 70B model generates 1,000 tokens in seconds, code rewriting surpasses GPT-4o, from the Cursor team, a code artifact invested by OpenAI Jun 13, 2024 pm 03:47 PM

70B model, 1000 tokens can be generated in seconds, which translates into nearly 4000 characters! The researchers fine-tuned Llama3 and introduced an acceleration algorithm. Compared with the native version, the speed is 13 times faster! Not only is it fast, its performance on code rewriting tasks even surpasses GPT-4o. This achievement comes from anysphere, the team behind the popular AI programming artifact Cursor, and OpenAI also participated in the investment. You must know that on Groq, a well-known fast inference acceleration framework, the inference speed of 70BLlama3 is only more than 300 tokens per second. With the speed of Cursor, it can be said that it achieves near-instant complete code file editing. Some people call it a good guy, if you put Curs

China Mobile: Humanity is entering the fourth industrial revolution and officially announced 'three plans” China Mobile: Humanity is entering the fourth industrial revolution and officially announced 'three plans” Jun 27, 2024 am 10:29 AM

According to news on June 26, at the opening ceremony of the 2024 World Mobile Communications Conference Shanghai (MWC Shanghai), China Mobile Chairman Yang Jie delivered a speech. He said that currently, human society is entering the fourth industrial revolution, which is dominated by information and deeply integrated with information and energy, that is, the "digital intelligence revolution", and the formation of new productive forces is accelerating. Yang Jie believes that from the "mechanization revolution" driven by steam engines, to the "electrification revolution" driven by electricity, internal combustion engines, etc., to the "information revolution" driven by computers and the Internet, each round of industrial revolution is based on "information and "Energy" is the main line, bringing productivity development

An American professor used his 2-year-old daughter to train an AI model to appear in Science! Human cubs use head-mounted cameras to train new AI An American professor used his 2-year-old daughter to train an AI model to appear in Science! Human cubs use head-mounted cameras to train new AI Jun 03, 2024 am 10:08 AM

Unbelievably, in order to train an AI model, a professor from the State University of New York strapped a GoPro-like camera to his daughter’s head! Although it sounds incredible, this professor's behavior is actually well-founded. To train the complex neural network behind LLM, massive data is required. Is our current LLM training process necessarily the simplest and most efficient way? Certainly not! Scientists have discovered that in human toddlers, the brain absorbs water like a sponge, quickly forming a coherent worldview. Although LLM performs amazingly at times, over time, human children become smarter and more creative than the model! The secret of children mastering language. How to train LLM in a better way? When scientists are puzzled by the solution,

How to solve the problem of third-party interface returning 403 in Node.js environment? How to solve the problem of third-party interface returning 403 in Node.js environment? Mar 31, 2025 pm 11:27 PM

Solve the problem of third-party interface returning 403 in Node.js environment. When we use Node.js to call third-party interfaces, we sometimes encounter an error of 403 from the interface returning 403...

The inside story of Google's search algorithm was revealed, and 2,500 pages of documents were leaked with real names! Search Ranking Lies Exposed The inside story of Google's search algorithm was revealed, and 2,500 pages of documents were leaked with real names! Search Ranking Lies Exposed Jun 11, 2024 am 09:14 AM

Recently, 2,500 pages of internal Google documents were leaked, revealing how search, "the Internet's most powerful arbiter," operates. SparkToro's co-founder and CEO is an anonymous person. He published a blog post on his personal website, claiming that "an anonymous person shared with me thousands of pages of leaked Google Search API documentation that everyone in SEO should read." Go to them! "For many years, RandFishkin has been the top spokesperson in the field of SEO (Search Engine Optimization, search engine optimization), and he proposed the concept of "website authority" (DomainRating). Since he is highly respected in this field, RandFishkin

See all articles